topic Re: How to Create Inbox Query with DateTime Question? in ArcGIS Survey123 Questions

How to Create Inbox Query with DateTime Question?

Billy — Wed, 17 Jan 2024 15:39:28 GMT

Hi,

I'm using Survey123 Connect Version 3.19.104 and the survey is used in the mobile app only.

I want to create an Inbox Query expression using a DateTime question. I tried different date-time formats in the SQL expression with no luck and I haven't found any documentation on how to this. I'm getting "Code 400 Cannot perform query. Invalid query parameters."

What is the query syntax for this type of questions?

Regards.

Re: How to Create Inbox Query with DateTime Question?

YukoYokozawa — Wed, 17 Jan 2024 15:49:26 GMT

My Inbox query expression is thie

CREATED_USER = ${username} AND LAST_EDITED_DATE > CURRENT_DATE - 180

The users can download only their data within 6 months

Re: How to Create Inbox Query with DateTime Question?

Billy — Wed, 17 Jan 2024 16:39:22 GMT

Hi YukoYokozawa,

Thanks for the reply. That works but what if I need something more specific like the example in the Survey123 documentation ( Prepare to edit existing survey data—ArcGIS Survey123 | Documentation)

I tried this syntax and got the 400 error. The second image shows the properties of the dateTime field and the syntax that I used.

Re: How to Create Inbox Query with DateTime Question?

YukoYokozawa — Wed, 17 Jan 2024 18:23:35 GMT

Does your data show year-month-day? Check your data for the date, my data shows like this

I would try 10/1/2023, if not work, then 10/1/2023 12:00 PM. So try different ways to express your date

Re: How to Create Inbox Query with DateTime Question?

Billy — Thu, 18 Jan 2024 14:13:34 GMT

Hi,

I tried those but didn't work either. But search on the developer's documentation I found the syntax: Query (Feature Service)—ArcGIS REST APIs | ArcGIS Developers

Thanks for your answers.