/
How to design and run queries programmatically using AQL?
Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com
How to design and run queries programmatically using AQL?
AQL is Krishagni's proprietary query language to query data without knowing the relational model of the underlying database. At present, there is no comprehensive documentation on AQL. Therefore we suggest users who are interested in running queries programmatically to use the below-mentioned approach:
- Create the desired query using the UI wizard. For more details, please watch the video Introduction to OpenSpecimen Query Tool - YouTube.
- Once you are satisfied with the query results, do the following
- Open the network tab in the browser's inspect mode.
- Rerun the query.
- You will notice a couple of API calls made to the resource /query using the HTTP POST method - one call for obtaining the counts and another to collect the data for display in the grid.
- The POST request body will have the required AQL for use in running the queries programmatically.
- Use the POST request body to invoke the query API and get the necessary data.
Refer to this document for more details on the Query API.
We agree. This sounds like a tedious method. Believe us, in the face of a continuously evolving software system, the working software itself serves as the comprehensive documentation about the topic you are interested in.
, multiple selections available,
Related content
Query
Query
Read with this
REST APIs
REST APIs
Read with this
And others...
And others...
Read with this
Sample Python: Participant, specimen, query etc.
Sample Python: Participant, specimen, query etc.
Read with this
Specimen
Specimen
Read with this
Get Specimens
Get Specimens
Read with this
Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com