What is a Query?

Data exists everywhere throughout an organization and in various formats: on shared network servers, in databases, or in the cloud; as structured text files, spreadsheets, or database records.

In Informer, a Query pulls data from a DatasourceA connection from Informer to a database or other system of record, such as PostgreSQL, SQL Server, or UniVerse.. A Query has two main parts: Fields and Criteria. The Fields correspond to fields on a SQL table or a U2 file. Criteria use WHERE clauses to filter the data to a smaller number of rows.

These articles cover creating, editing, and customizing Queries, and the differences between the two types of Query in Informer 5: Dataset and Ad hoc.

Also available through the REST API

Everything on this page is built on Informer's public REST API, the same one the product uses, so your scripts and integrations can do it too. Developer reference: Queries.