LIKE Operator in Filter-- ODK Aggregate

Support
1

Hi,

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:

Like%20Operator
Like%20Operator1324×546 71.5 KB

Advance Thanks..

Regards,

2

Any guidance Please.

3

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.

4

Thanks..

Please tell me at a time i can filter one query not pair of filters i can used.

Please guide me

5

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:

image

6

Thanks Sir..
I understand.

I am very grateful to you.

Regards.

1 Like