The Reporting Queries feature allows users to return a desired set of data from their instance after specifying to the platform how to retrieve the data. In the Queries feature, one query corresponds to one set of data that usually answers one question (e.g., Who are the students in the class of 2024 who have an allergy?).
Once the platform has returned the proper results for your query, you may want to see additional information on the results. For example, the results of a query that answered the question "Who are the students in the class of 2024 who have an allergy?" display the following columns:
Last name
First name
Allergies - Allergen
Allergies - Severity
However, you may also want to see the the type of reaction for each of these allergies. Click into the box of column names above the query results to select and add additional columns to the results.
Additional columns are grouped by the subtype of data on the model (e.g., Conditions, Allergies, Sections) to aid identification.
You can also begin to type the name of your desired column to add, and the dropdown menu will refine the visible column names.
Select the checkbox for your desired column in the dropdown menu to display it in the results table.
You can also adjust your query results by taking action on the column. Select the gear button to the right of each column to adjust the query results based on that column.
For example, if I want to sort the list of students alphabetically by last name, I would first select the gear icon on that column.
I would then select the sort direction to ascending and hit the 'Save' button.
Doing do alphabetizes the results by last name.
It is also possible to filter the results by column values. To filter the results of a query by filter values, select the gear button on the desired column and select the 'Filter column values' checkbox.
Doing so will provide you the opportunity to define a new query based on the column. Adjust this query appropriately to refine the results based on the column values.
