×

Have You Seen Operations Hub Lately? Click here to check out all the new features in the latest version.

Supercharge your GE solution! Download a free trial of Proficy Operations Hub, CSense analytics, and more. Learn more about the Proficy 2023 releases, by signing up for one of our upcoming events.

Operations Hub Products Documentation

User Guide
- Overview
- Operations Hub (New Layout)
- Applications
- Entities
- Queries
  - About Queries
    Using Operations Hub, you can create queries to access and manage data stored in Operations Hub, as well as data stored externally.
  - Grant Group Access to Execute a Query (Classic)
    Steps for Operations Hub classic version.
  - Access a Query (Classic)
    Steps for Operations Hub classic version.
  - Create Get Query (Classic)
    This topic describes how to create a Get query.
  - Create Update Query (Classic)
    This topic describes how to create an Update query.
  - Create Insert Query (Classic)
    This topic describes how to create an Insert query.
  - Create Delete Query (Classic)
    This topic describes how to create a Delete query.
  - Create SQL Query (Classic)
    This topic describes how to create a SQL query.
    - Triggering/Non-triggering SQL Queries
      This topic describes the SQL triggering and non-triggering functionality.
  - Create REST Query (Classic)
    You can create a REST query for the GET, PUT, POST, and DELETE methods.
  - Create Extension Query (Classic)
    This topic describes how to create an Extension query.
  - Update Preloaded REST Queries after Import (Classic)
    Steps for Operations Hub classic version.
  - Update Entity Display Fields After an Import (Classic)
    Steps for Operations Hub classic version.
  - Copy a Query (Classic)
    Creates a duplicate copy of an existing query.
  - Delete a Query (Classic)
    This topic describes how to delete a query.
- Plug-ins
- Events
- Email Templates
- Parameters
- Users
- Roles
- Administration
- Data Sources
- Pages
- Navigation
- Explorer
- Themes
- Settings
- Widgets
- General Reference
- APIs
- Troubleshooting

Triggering/Non-triggering SQL Queries

This topic describes the SQL triggering and non-triggering functionality.

This feature is currently available only in Operations Hub Classic version under Query definition and Page designer.

Note: This functionality will be available in the Operations Hub new layout in an upcoming release.

When creating SQL queries in Operations Hub, you have the option to specify whether the SQL query should be triggered or not when a change occurs in its input value. You can also specify if the value is mandatory or optional to trigger a query. By default, the options are set to Triggering and Optional for all SQL queries. This is also the default behavior of Operations Hub page designer PAGE DATA tab > Query option > Auto submit on input change.

When you use the query in page designer, you can choose to modify the triggering/non-triggering settings. The page designer settings take precedence over the settings in query definition. Once the query is added to a page, any changes to the settings in query definition is not carried over to page designer.

Non-triggering

If the input parameter is set to Non Triggering, then at runtime any change to the input does not trigger the query.

Triggering

If the input parameter is set to Triggering, then at runtime any change to the input will trigger the query provided all the mandatory fields are set.

Optional

If the input parameter is set to Optional, then the input need not have any value for the query to trigger.

Mandatory

If the input parameter is set to Mandatory, then the input should contain a value for the query to trigger.