Query Triggers

By default, queries will run when a calculate event occurs, either automatically or with the press of an action button. You might want to change this behavior for reasons like improving the application load and calculation performance, or tie the data to certain other...

Decoupling Data from a Spreadsheet Using Queries

One of the most common uses of the Queries feature is for decoupling the data from the spreadsheet. You can easily decouple the data from your workbook to reduce its size and increase calculation performance using queries. You can copy large data sets into a separate...

Binding Query Results to Named Ranges

You can create database queries to pull data from any web application or data map under your SpreadsheetWEB account. The resulting data from these queries can be bound to named ranges from your workbook to be used in runtime calculations. The dimensions of the outcome...

Using Query Results in Calculations

We can split queries into two groups in terms of how they are evaluated in calculations, static queries and dynamic queries. The main difference between the two is how they affect the order of calculations. Static queries are those that don’t depend on input fields...

Displaying the Results of Queries

You can display the results of queries created with the Queries module by binding the results to a named range in your workbook. Named ranges with query results bound to them can be used in UI controls and content fields. QueriesQueries Basics Displaying the Results...

Queries Basics

In the Queries module you can create database queries to retrieve data from applications and data maps. Queries are created using an intuitive user interface and you can bind these queries to named ranges to use the query results in other runtime calculations. What is...