{
  "user_id": 2,
  "beforetime": "2020-10-15"
}

// a new DataQL Query.
import 'net.hasor.dataql.fx.basic.DateTimeUdfSource' as time;
// select * from test_login where user_id = #{user_id} and date < #{time};
// return time.parser("2020-04-28 10:28:44", "yyyy-MM-dd hh:mm:ss")
// var beforetime = "2020-10-15";
// var user_id = 2;
var timeparser = (timestring)->{
    return time.parser(timestring, "yyyy-MM-dd");
};

var getUser = @@sql(user_id,beforetime)
<%
    select * from test_login where `user_id` = #{user_id} and `date` < #{beforetime} 
%>;

return getUser(${user_id},timeparser(${beforetime}))=> [{
    "user_id":user_id,
    "client_id":client_id,
    "time":time.format(date, "yyyy-MM-dd")
}
]

// a new Query.
// a new DataQL Query.
// page Segment Query.
hint FRAGMENT_SQL_QUERY_BY_PAGE = true
var dimSQL = @@sql(userName)<%
    select * from user where `name` like concat('%',#{userName},'%')
%>;
var queryPage = dimSQL(${userName});
run queryPage.setPageInfo({
    "pageSize"    : 5, // 页大小
    "currentPage" : ${pageNumber}  // 自定义想要获取的页面
});
//用Json结构返回结果
return {
    "pageInfo": queryPage.pageInfo(),
    "pageData":queryPage.data()
}
//返回前端处理分页的时候通常所需的分页信息，有了分页信息可以生成前端的页面序号按钮
// return queryPage.pageInfo()