Skip to main content
Version: 7.9


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.