---
title: "executeQuery"
description: "Executes a select query using the given ConnectionName (or the default connection it omitted) and stores the result into a global ResultSetName."
---

# executeQuery

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

:::note Deprecated
This function was deprecated in 8.0.0.
:::

**This function is used by Ignition's Expression language.**

## Description
:::note
This function is only available in Transaction Group Expression Items and Expression Tags.
:::

## Syntax
`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.

## Examples
```python title="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.
```