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 Queries: Used to view and modify data stored in Operations Hub entities. Refer to Get, Update, Insert, and Delete.
  • SQL Queries: Used to view and modify data stored in an external SQL database by executing existing stored procedures for that database.
  • REST Queries: Used to view and modify data stored in external sources by accessing their exposed REST APIs, such as Historian.
  • Extension Queries: Can be used with Historian, OPC UA, and data from asset models.

On installing Operations Hub, you also get a list of out-of-the-box (OOTB) queries for use. 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 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.
  • 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.
  • Historian Write Comment: Use this query to write comments to a Proficy Historian data source.
  • Historian Read Comment: Use this query to read comments from a Proficy Historian data source.
  • OPC UA Write: Use this query to perform write operations to Proficy iFIX and Proficy CIMPLICITY data sources.
  • Historical By Interval-Calculated Mode: Use this query to retrieve historical values (calculated mode) against a Proficy Historian data source.
  • 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.