This article is part of the RCM Queries troubleshooting content. If a query unexpectedly returns no results, work through the checks below before assuming there's a data problem. For day-to-day query tips such as testing changes in a copy before altering the original, see Working with Queries; for when and why queries are used in RCM, see RCM Queries – Background.
What to check
If your query comes back empty, check the following before concluding the data is not there.
Check the fields selected — make sure Select All is applied and that the objects you expect actually exist in the database. If you're not sure, create a new test object and confirm it appears.
Check the scoping bar — make sure Select All is applied there as well.
Check that no Criteria are selected, even by accident. Clear any criteria using the Clear control before rerunning the query.
Note
An accidentally-selected criterion is one of the most common causes of an empty result. If you're not sure why a query returned nothing, clearing all criteria first is a good first step.