Define a Query Data Block

The Query Data block retrieves data based on a SQL query and makes it available to a grid or other visualization objects. For users who are not completely familiar with writing SQL queries, the Query Data block also includes a Query Builder to help you build a SQL query to access SysTrack data. Query Data blocks can be saved in the Library for others to use.

Depending on how you define a Query Data block, icons will display on the block to indicate whether the block is linked to the Library, has an external data source,or both:
  1. Drag the Query Data Block from the Toolbox onto the workspace.
  2. With the Query Block selected, the Object tab on the Properties pane becomes active and reflects configuration fields and information for a Query Data block.

  3. Optionally rename the Query Data Block in the Name field, and provide a Description. This is useful if you intend to save the Query Block in the Library for others to use.
  4. Click the Expand Query box button. You can click this several times to expand the field as necessary.
  5. Enter or paste a SQL query into the Query field, or use the Query Builder(See Using the Query Builder for more information.)

  1. Click the Test button to make sure the SQL statement is valid. A message displays stating either that the query is valid or invalid.
  2. Click the Apply button to save your changes.