Defining queries

Training course

Important! Poorly written queries can cause performance issues in iMIS.
Before starting to work with queries in the Intelligent Query Architect, review the Best practices for writing IQA queries.

IQA provides two modes for query definition: Basic and Advanced. The general steps for defining a query are the same in either mode, but additional functionality is available in Advanced mode. Use Basic mode for querying and displaying simple lists of results from one or more sources with optional filters to narrow the results. Use Advanced mode for more complex queries and displays.

Basic Mode Advanced Mode
  • Define sources and (optional) filters
  • Specify display details
  • Use calculations, such as sums and averages
  • Use queries in iMIS searches
  • Use SQL expressions in queries
  • Use complex filters, such as displaying only unique results
  • Allow or require end user to supply parameters at run time
  • Aggregate data and display
  • Assign aliases to field names for display
  • Link a display property to another page

See Reporting in IQA for information about using queries for reports.

Note: iMIS starts you in Basic mode, but it remembers the last mode you were in, even after you log out.