This feature was removed from Ignition in version 8.0.0

This function is used by Ignition's Expression language.


This function is only available in Transaction Group Expression Items and Expression Tags.

Executes a select query using the given ConnectionName (or the default connection it omitted) and stores the result into a global ResultSetName.


executeQuery(query, resultName[, datasource])

  • Parameter

string query - The query to execute.

string resultName - The name of the global result set.

string datasource - Optional. The name of the database connection.

  • Results

int - The number of rows in the returned table.

Code Snippet
executeQuery("SELECT * FROM table", "MyResult", "MySQLConnection") //would store the results in "MyResult" and return an integer based on how many rows were in the table.
  • No labels