Inbox does not return all matching records
I have a query clause in the Inbox, however, it does not return the same records when I compare it to queries made in ArcGIS Pro:
Survey123: 1,031 records
ArcGIS Online/Pro: 1,087 records
I've already tried some SQL combinations and they all return the same difference in values. Some of the tests carried out:
- LOWER(conclusao)='ausente' OR LOWER(conclusao)='pendente' OR LOWER(conclusao)='recusou'
- UPPER(conclusao)='AUSENTE' OR UPPER(conclusao)='PENDENTE' OR UPPER(conclusao)='RECUSOU'
- conclusao<>'Concluído'
- NOT(conclusao='Concluído')
I noticed that many of my most recently edited records do not appear in the Inbox in Survey123:
I also noticed that when updating the inbox, the correct value (1,087) is displayed in the popup, but at the end of the process, only 1,031 are displayed:
When you break down the query (e.g.: conclusao='Pendente'), the number of records returned by Survey123 is correct. However, when I combine two or more queries, the difference happens.
Another thing I noticed is that, without any query clause, the return is always 4,758, while the Inbox limit is 5,000 (and the query layer has almost 9,000 records). This, in itself, is also a big problem.
This issue has been seen on different computers, with different internet connections, both using Field App v.3.20.65. Faced with so many tests, on different programs, computers and connections, the only explanation I have is that there is a problem with the Inbox itself.
Any solution for this case? Any abnormal behavior recorded in the Inbox in this update?
Thank you all
No, I do not have Sent enabled in Connect, nor do I have any records sent in the Field App.
I even created a new test form (with a much simpler structure than the original), pointing to the same layer, and the error persists. The form settings follow:
Update: I created a visualization layer with the filtered records and removed the query from the Survey123 settings and the problem still persists.
In other words: there is no problem with SQL syntax, domains or anything like that. For some reason, the input box is not returning all records from the layer.
