Here are a few examples of queries that can be created in enQuiry. The examples include straight forward queries, grouping and filtering queries and queries with ordering of data and fields.
Entity Listing
This example is a simple query of entities:
Entity Listing (Filtered)
This query illustrates the entity listing above but with filtering applied:
Grouping with Sort in Descending Order
This query displays the maximum balance from accounts grouped into "Account Code", "Sub Account Code", and the balance period. It is sorted into descending order of balance:
Advanced Query using Linked Tables and Filtering
The following advanced query illustrates contact and address details for all entities with a first name of "Charles":
Multiple Criteria Handling
This query looks for a full name only containing the titles "Island Business Centre", "Hannam Associates" and "Islands Insurance":
