# Why does my database query return no records?

Canonical URL: https://help.iagenify.com/faqs/databases/why-does-my-database-query-return-no-records

[← Back to Databases FAQs](https://help.iagenify.com/faqs/databases)

HELP CENTER · FAQ Databases 2 min read
# Why does my database query return no records?
An empty query result can mean that no records match, but it can also point to a scope or query mismatch. Verify the target and test the query in small steps before changing data.
IaGenify
Databases

## Confirm the target and the query
Start by confirming which connection, database, and environment the query uses. Development and production environments may have similar names while containing different records. Check the table or collection name and whether the connected account can read it; a successful connection does not prove that it points to the data you expected.
Next, temporarily review the filters and conditions. A date range, exact text match, or combined condition may exclude every record even when the collection is populated. Compare the query with one known record and add filters back one at a time so you can see which condition changes the result.
## Separate missing data from missing access
If a simpler read still returns nothing, verify that the expected records exist through the database's usual administration or application path. If they exist there but not through the connection, investigate permissions, schema selection, and environment before attempting a write or changing the query broadly.
Keep this investigation read-only until you understand the mismatch. Record the connection and query that produced the empty result, along with the target environment. That context makes it easier to reproduce the issue and prevents a troubleshooting change from accidentally altering the wrong database. [← Back to Databases FAQs](https://help.iagenify.com/faqs/databases)