We recently ran a year end report for quarterly Inspection data collected using Survey123. Several of the inspections did not show up in the year end report. When we reviewed the quarterly reports, the data had appeared in those. A little digging led to finding that some of the objectid values have been duplicated in the hosted feature service. I am assuming this is why only one of the records is showing in our year end query and not all of them. I have attached a screen grab of a sql query to the datastore with the results.
Any idea how this can happen, and what is the fix?