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.

To create a Query Interface display in GraphWorX:

  1. Open GraphWorX and on the Controls 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, click next to the Data Source text box to open Data Browser.
  4. Expand the desired component, such as Data Connectivity > BACnet or Alarms and Notifications > Alarm Historian Query Interface, select the .Query data point, and then click OK to close the Data Browser dialog.
  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 and 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 .