To enable columns sorting and filtering, and pagination on grid apps that display data from web services, it is necessary to enable the data cache option. Let’s assume that the ACCOUNT DETAILS classic grid app (widget), with a web service data source is already created in Canvas Studio. - In App Designer, click the View Config tab and then proceed to select the Caching option.
- Click the Enable Data Cache toggle and select the App Instance option in Caching Scope.
- To apply data filters, click the Filtericon.
- To configure the column properties of ACCOUNT_ID, click Configure.
- In View Column Configuration, click the Sort & Filter option.
- In Sort & Filter, configure the parameters, as shown in the following screen shot:
- Proceed to save the app.
Let’s assume that the ACCOUNT DETAILS app is mapped to the ACCOUNT SUMMARY workspace. The data of the ACCOUNT DETAILS app, fetched from the web service is displayed in the functional application, Modelhouse:
- Click the Filtericon on the right side of the app, select the Account_ID column and click Contains.
- In the Account_ID contains search box, enter the appropriate value and press Enter.
The data matching the search criteria provided for ACCOUNT_ID column appear in the grid.
|