LIKE Operator in Filter-- ODK Aggregate


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?

Screen Shot:

Advance Thanks..


Any guidance Please.

Hi, @tasadduq786!

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:

  • Date_Time, >=, 2018-03-16T00:00:00.000Z
  • Date_Time, <, 2018-03-17T00:00:00.000Z

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:


Thanks Sir..
I understand.

I am very grateful to you.


1 Like