/
How to get SQLs for queries?
Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

How to get SQLs for queries?

For debugging purposes of query slowness, SQLs are required to check query performance.

In OpenSpecimen, it can be achieved easily by following the below steps.

  1. Log in as a super admin.

  2. Click on Queries card → Query Audit button → List view of queries.

  3. Click on user/unsaved query.

  4. The pop-up will come up, which will display a SQL query.

 

Related content

Querying for custom forms/fields from DB
Querying for custom forms/fields from DB
More like this
Software/Hardware Requirements
Software/Hardware Requirements
Read with this
Database Console
Database Console
More like this
How to fix 'Malformed Query' error?
How to fix 'Malformed Query' error?
Read with this
How to download query definition?
How to download query definition?
More like this
Data Dictionary
Data Dictionary
Read with this
Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com