Using Query Interface

Some of the GENESIS components contain a Query Interface. You can use the feature to display requested data in a clearly organized table in GraphWorX.

As a prerequisite, you need to make sure that the related service is running. Learn more

For some components, such as Assets, the primary service for the point manager implicitly supports the query interface, while for other components, such as Alarm Historian or BACnet, you need to start a separate query interface service, as shown in the image.

Once enabled, data is stored in a .Query data point that you can connect to a GraphWorX Table control.

To display query data in GraphWorX:

  1. Open GraphWorX and on the Control ribbon, select Table, and then drag the mouse diagonally across the canvas to make a rectangle for inserting the table control.
  2. Double-click anywhere inside the control to open the configuration dialog.
  3. On the GENERAL tab in the Data Source section, set Type to Query.

  4. In Data Source, click to open Data Browser. Then expand the desired component, such as Assets, Data Connectivity > BACnet, or Alarms and Notifications > Alarm Historian Query Interface, select the .Query data point, and click OK to close the Data Browser dialog. The selected data point is entered in the Data Source text box.

  5. In Table, select the desired table from the drop-down list of available tables for the selected query.

  6. On the FIELDS tab, click next to the field list to load the fields available for your query. Optionally, customize the settings for each field as desired. Use the button menu to add, remove, or copy fields and change the order in which they appear in the table.

  7. On the COLUMNS tab, click next to the column list to load the columns available for your query. Optionally, customize the settings for each column as desired. Use the button menu to add, remove, or copy columns and change the order in which they appear in the table.

  8. Modify the remaining table settings as desired. When finished, click Apply, and then click OK to close the configuration.

  9. Verify the settings by viewing the query in runtime. Use the options on the upper right of the GraphWorX screen to switch to the runtime mode or to open the display in a web browser .