Skip to main content
Version: v10.15

Using Variables for Queries and Procedure

Showcases​

  • Use Variable for Queries created in Database. For example, Queries with/without parameters.
  • Queries such as Select distinct to populate select widgets also can be bound to variables.
  • Aggregate Queries also can be bound to Variable.
  • Stored procedures can be bound to Variable.

1. How-to use Variable for a DB Query​

2. How-to use Variable for a DB Query to be bound to select widgets which will be used to filter data​

3. How-to use Variable for an Aggregate query and bind it to Data table and Chart widgets​

4. How-to use Variable to execute a MySQL Procedure​

See Also​

How-to use Filter in Live Variables
How to use Live Variable APIs
How to work with Notification Actions
How to work with Navigation Actions
How to work with Service Variables in a Form