Print this page

INTERNAL: SOQL does not return expected results in Sandbox

Knowledge Article Number 000206575
Description Issue:

Sometimes , customers may notice that the SOQL returns incorrect results in their sandbox. Although the data exists in the Sandbox, query may not be able to pull the records. 

This may be due to the fact that the index on the query filter may have been corrupted during the sandbox refresh.
Resolution Dropping the existing index and recreating it should resolve the issue.

promote demote