Print this page

SOQL Queries returning incorrect results in Sandbox

Knowledge Article Number 000193737
Description Issue:
An SOQL Query that uses a filter which is unique and indexed, may return incorrect results in sandbox. With the refresh, the index on the custom field may get corrupted.

Resolution Remove and Recreate the External Id and unique properties of the custom field should resolve the issue.
If the field has a custom index  reach out to support for rebuilding the index on the field.

promote demote