What is an Ad hoc Query?
Datasets are the recommended way to work with data in Informer, but there is sometimes a need for more temporary or real-time data requests. For example, when processing a payroll run, or when monitoring live data for a condition and emailing someone as soon as it happens, you need to see the data exactly as it is right then in the database. In these situations, Ad hoc Queries are an easier way to get data faster.
Ad hoc Queries support both the Query Designer and the Native SQL options for creating the Query, just like Dataset Queries. After running the Ad hoc Query, Informer creates a temporary result set that is visible only to the User who ran the Query. That result set works the same way as a Dataset result set: filtering, sorting, grouping, creating Pivot Tables, and more.
