After a few hours try to learn FunctionQuery from their wiki and ThriftDB API and cannot find the solution for what I am doing, I decide to post here hoping that someone can help me. My goal to get the recent highest score items within some range, let say in the past 5 days. I also see the thread from Jason Wang asking for similar filter for day range, but since I don't have specific range, I cannot apply his solution.
I try with:
decode: http://....filter[queries][]=div(div(ms(NOW,create_ts),3600000),24):[0 TO 7]
I got 500 Internal Server Error, and I think that part that I try to apply the function on the field
div(div(ms(NOW,create_ts),3600000),24)
is causing me error, but I don't know the syntax to fix it. Hope someone can show me the cause and the solution.
Thanks.