Skip to main content
Version: Deprecated Pages


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])

  • Parameters

    • 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.