Zum Hauptinhalt springen

Data query

A data query retrieves data from an external source (for example a database) so it can be used in your Nooxl App. A query is built from a connection, one or more commands, and optional parameters.

note

In older documentation and the API this is a bxlink. To bring the query result into a model's cells, use a query section.

Prerequisites​

  • A Nooxl App is open and Design mode is active ().
  • You have the external connection details.

Create a data query​

  1. Open Data integration and enter Design mode.
  2. Create a new data query and choose its connection type.
  3. Enter the connection string (or pick a preset connection from the configuration file).
  4. Save — then add one or more commands and, if needed, parameters via the button on the query in the tree.
Edit data query with name, connection type and connection string
  • 1 Enter a name.
  • 2 Choose the connection type.
  • 3 Enter the connection string.

Query parts​

PartFields
Data queryName, connection type, order.
CommandName, command type, command text, timeout (seconds).
ParameterName, order, and options: allow null values, optional, not modifiable.
note

Parameters let a query react to the current dataset — for example passing the selected labels as filter values into the command.