Edited Surveys not showing in INBOX

Question

We have a survey that collects inspection and leak data. Recently when a leak has been edited via the INBOX, ie. repair method, date, etc. added, the survey no longer shows up in the INBOX. The data is in our database but the surveys will not display in the INBOX. This is a problem as we typically have 2 or 3 edits to a leak. This issue started approximately 1-2 months ago. Any assistance would be appreciated.

Survey created in Connect

Data collected using iPad/iPhone (all IOS users)

Edits via INBOX performed using Windows Laptop, IOS devices

SQL Server SDE database

Regards,

--gary

GaryBowles1 · Answer

Still not showing with query removed.

Tanks,

--gary

GaryBowles1 · Answer

The query was working fine. It still pulls the records for the past 365 days, I just don't get the edited surveys being pulled. The INSPECTION_DATE field is never edited, just info about repairs.

Thanks,

--gary

DavidSolari · Answer

The query looks correct at first glance. Two things you can try:

* Wrap the CURRENT_DATE - 365 part in parenthesis to guarantee the order of operations.
* Check the dates going into that field, if they're null or malformed that could cause the query to fail.