Executing Queries

The simplest way to execute a query inside a dataset is using the execAsync method on the dataset.  This is the same method that is available on the DataSource class.
1
const dataset = new wire.data.DataSet({
2
    Source: new wire.data.DataSource("custom", {
3
        ServiceRoot: "./account"
4
    }),
5
    Query: wire.data.select().from("Users")
6
});
7
​
8
const data = dataset.execAsync().done((data) => {
9
    // 'data' will contain the results of the query
10
});
Copied!
Data Promises
One difference between methods on the dataset and methods on the data source is that the data set methods return an instance of wire.data.DataPromise instead of a deferred jQuery promise.
Depending on the method used, the dataset will put the promise it returns into a stack of promises to be updated when it picks up changes to its query and refreshes its data from the data service.  
The execAsync method does return a data promise but it does not add the promise to the internal stack of promises that receive updates when data changes.  This is a one-time request much like the behavior of the same method on the data source.
To get a data promise that is updated when data changes, use execAsyncListen.  This method will return a new data promise and add it to the update stack.  
1
const dataset = new wire.data.DataSet({
2
    Source: new wire.data.DataSource("custom", {
3
        ServiceRoot: "./account"
4
    }),
5
    Query: wire.data.select().from("Users")
6
});
7
​
8
dataset.execAsyncListen().done((data) => {
9
    // 'data' will contain the results of the query
10
    // This will be called if any changes to the query in the dataset 
11
    //  are detected and new data becomes available
12
});
Copied!
Note, do not use this method unless you want the updates.  Calling this method over and over for one-time query requests will unnecessarily build up a stack of updates that are sent out when not needed.  This method is mainly used by presentation components that want updates so they can refresh their UI.
Promise Callbacks
A data promise contains the same callbacks as a jQuery promise but adds an addition method to let consumers know when data is being refreshed in the data service.  This allows them to provide feedback such as a spinning icon in a presentation component.  
1
...
2
​
3
dataset.execAsyncListen()
4
    .done((table) => {
5
        // initial or new data avaialble
6
    })
7
    .processing(() => {
8
        // dataset going to the data service for data
9
    })
10
    .fail((ex) => {
11
        // service request failed
12
    });
Copied!
DataTable Results
Another difference between the exec methods on the dataset vs the same ones on the data source is that data returned to the caller using a data set is a DataTable by default.
Notice in the example above, the object returned in the done callback is named a table for this reason.  This can be turned off using an optional configuration setting passed into any of the data set methods.  
In the example below, the result set is not cast into a data table and stays in its native format by using the cast option on the configuration parameter.
1
...
2
​
3
const config = { cast: false };
4
​
5
dataset.execAsyncListen(config).done((data) => {
6
    // 'data' will be in whatever format was 
7
    // returned from the data service
8
});
Copied!
Refreshing Data
Use the data set refresh method to force a dataset to go back to the data service for new data and then update its promises letting consumers know about the change.  This method does not return a new promise.
This method is most used when the dataset's query is updated manually through code.  Here, the data set needs to be refreshed manually instead of via a data event listener.
1
...
2
​
3
//
4
// Add a where clause to the requst for Users from the previous examples
5
//
6
dataset.Query.where().eq("Active", true);
7
​
8
//
9
// This will force a refresh of the data per the new query 
10
// and notify any consumers using the dataset
11
// waiting for updates via their data promises
12
//
13
dataset.refresh();
Copied!
Response Data
As seen in the examples above, the data returned from data service queries is available in the done callback of a data promise.  In addition, the data is also stored inside the dataset and can be accessed anytime via the data method on the dataset.
1
const users = dataset.data();
Copied!
For TypeScript applications, a helper method on the data set called table is defined in the WireBootstrap typings file as returning an IDataTable object for auto-casting into a DataTable in TypeScript.  This is helpful if the default data table casting behavior is not turned off.
1
//
2
// This method is defined as returning an IDataTable object
3
//
4
let usersTable = dataset.table();
5
​
6
//
7
// We can now jump right into coding locally with 
8
// the strongly typed DataTable object
9
//
10
const jamie: User = usersTable.where().eq("UserName", "jkratz").first();
Copied!
For more on executing queries in data sets, visit the DataSet reference page.  For more on data tables, visit the DataTables reference page.

Introduction

Transforms

Last modified 11mo ago

Copy link

Contents