rest icon indicating copy to clipboard operation
rest copied to clipboard

missing operator to select datetime range

Open serveryang opened this issue 1 year ago • 3 comments

if have a create_at coloum in table, how to filtering using gte and lte operator to select by range.

serveryang avatar Jun 25 '24 09:06 serveryang

@serveryang you can check the detail document here https://rest-go.com/docs/guides/api#filtering

shellfly avatar Jun 25 '24 09:06 shellfly

I have read the document, can't find logic operator to implement filter create_at column in range. sql statement like select * from tablename where create_at >= '2020-10-10 12:12:12' and create_at <= '2024-10-10 12:12:12' multi create_at in querystring of api will ignore first one.

serveryang avatar Jun 26 '24 07:06 serveryang

@serveryang it's supported now, you can try the latest master to use it.

shellfly avatar Jul 05 '24 23:07 shellfly