About Queries

Using Operations Hub, you can create queries to access and manage data stored in Operations Hub, as well as data stored externally.

You can create the following types of queries:
  • Entity
  • SQL
  • REST
  • Extension
Entity Queries: Used to view and modify data stored in Operations Hub entities. Refer to the following topics:

SQL Queries: Used to view and modify data stored in an external SQL database by executing existing stored procedures for that database. See Create SQL Query (Classic).

REST Queries: Used to view and modify data stored in external sources by accessing their exposed REST APIs, such as Historian. See Create REST Query (Classic).

Extension Queries: Can be used with Historian, OPC UA, and data from asset models. See Create Extension Query (Classic).

On installing Operations Hub, you get a list of out-of-the-box (OOTB) extension queries. These are system queries and cannot be unlocked, modified, or deleted. You can duplicate such queries to modify and use them.

To access the list of OOTB extension queries, select QUERIES in the main navigation menu.

Current Value Use this query to retrieve the current values against Proficy Historian, Proficy iFIX, Proficy CIMPLICITY, and OPC UA data sources.
Historian Read Comment Use this query to read comments from a Proficy Historian data source.
Historian Write Comment Use this query to write comments to a Proficy Historian data source.
Historical By Count Use this query to retrieve historical values (by count) against a Proficy Historian data source.
Historical By Interval Use this query to retrieve historical values (by interval) against a Proficy Historian data source.
Historical By Interval-Calculated Mode Use this query to retrieve historical values (calculated mode) against a Proficy Historian data source.
OPC UA Write Use this query to perform write operations to Proficy iFIX and Proficy CIMPLICITY data sources.
OPC UA Write with Auth Use this query to perform OPC UA write operations with authentication.

To troubleshoot errors returned for OOTB queries, refer to Error Codes.