I want to apply Filter in Aggregate on my "Date_Time" Column [ e.g 2018-03-16],not result came because time is also present with date in my column.
Can i use 'LIKE' Operator in ODK Aggregate Filter option?
Unfortunately, Aggregate can't use the
LIKE operator because it's not supported in AppEngine.
In any case, if you want to get all submissions for date 2018-03-16, I think you could try using a pair of filters:
These filters will take everything from the start of the day until (but not including) the start of next day.
Please tell me at a time i can filter one query not pair of filters i can used.
Please guide me
I'm not sure if I understand your question... You can't get all submissions from one day filtering a dateTime field with just one filter. What you can do is add two filters like so:
I am very grateful to you.