Inbox Query by ISO Week Number

Question

While we can capture the week number in the forms, the inbox query does not recognize the ISO week number

Something like this FIELDNAME <> EXTRACT (month from CURRENT_DATE) but for week numbers.

Does anyone know when this will be supported?

DeonLengton · Answer

Hi From what i can tell the current ArcGIS REST API does not support the ISOWeek function yet. And there doesnt seem to be anything planned regarding supporting it. I have a possible workaround for your problem... You can consider a "helper" survey with embedded links in it to open the Inbox of your survey in question. In my "helper" survey I open the Inbox with specific parameters such as the week number which you seem to be able to calculate within the survey (https://community.esri.com/t5/arcgis-survey123-questions/how-to-calculate-the-week-number-of-a-date/td-p/1217824) Once you have the week number you can build a URL to open your Inbox with a week number whereclause: concat('&open=native&folder=inbox&update=true&download=true&q:where=WeekNumber=%27",${WeekNumber},"%27)"),'">

Retrieve Data for this week') This assumes your WeekNumber field is a string - which you should be able to change to an integer in the URL if required