Basic Queries

These are customizable queries used by and/or generated for the end-user, for particular use cases.

  • Custom Query – most generic query type, that you may create empty (value-based) or with tables, views and other subqueries.
  • Cloned Query – duplicate customizable query. Clone any read-only system query to be able to change it.
  • Parameterized Query – query with @paramXXX parameters.
  • Nested Query – separate query used as subquery in another query.
  • Demo Query – automatically generated query, under Queries/Demo Queries folder, generic (for any platform), not based on any database-sppecific table or view.

Special Queries

These queries use specific SQL features.

  • Skip-and-Keep Query – query using Skip and Keep values to slice the result: Skip first n records, then Keep up to m.
  • Inline Subquery – simple independent subquery generated inside a saved query, with no separate identity or definition.
  • Aggregate/Grouping Query – generic query using at least one Group By field in Groups. Drill-down to its special All Aggregates tab to instantly discover all aggregates for that row.
  • Pivot/Crosstab Query – emulated or native grouping query, in which one Group By column’s values have been pivoted as additional column headers.
  • Grouping Sets Query – emulated or native grouping query, extending its Group By clause by GROUPING SETS, CUBE or ROLLUP.
  • Total Rows Query – quick SELECT COUNT(*) aggregate query for a table, view or subquery.
  • Total Aggregates Query – quick query Group By a column, with Count aggregates for all other table fields.
  • Total Duplicates Query – quick query Group By a column, with Count of duplicate values in that field.
  • Random Row Query – query returning the same rows, but in a different order, each time it is executed.
  • Sequence Generator Query – query returning dynamic rows with n to m integers.

System Queries

Parameterized system queries are transparently created and used by the application for tables, relationships, objects, aggregates drill-down or hierarchical representations. They are frequently hidden, unique and/or read-only. Persistent or virtual instances are sometimes created for these parameterized queries.

  • Table-Based Queries – read-only system query, one per table or view. When you query directly a table or view, we generate and use this underlying hidden query, that you can however clone and customize. In Admin mode, they are saved under the Queries/Table-Based Queries folder.
  • Object Queries and Instances (Bookmarks) – parameterized hidden system query, one per table, created first time you save a bookmark from that table. In Admin mode, they are saved under the Queries/Object Queries folder. Related object instances (or bookmarks), are saved under the Bookmarks folder.
  • Relationship Queries and Instances – parameterized hidden system query, one per relationship. In Admin mode, they are saved under the Queries/Relationship Queries folder. Related relationship instances are not persistent and appear under the Bookmarks/Relationship Instances folder.
  • Group Queries and Instances – parameterized hidden query, generated for any group aggregate query, when you drill-down to an All Aggregates tab. In Admin mode, they are saved under the Queries/Group Queries folder. Related group instances are not persistent and appear under the Bookmarks/Group Instances folder.