- Getting Started
- Before You Begin
- How To
- Notifications
- Using VB Expressions
- Designing your App
- Events and Rules
- Rule: If-Then-Else
- Rule: Open a Page
- Rule: Open URL
- Rule: Close Pop-Over/Bottom Sheet
- Rule: Show Message
- Rule: Show/Hide Spinner
- Rule: Set Value
- Rule: Start Process
- Rule: Reset Values
- Rule: Upload File to Storage Bucket
- Rule: Download File From Storage Bucket
- Rule: Create Entity Record
- Rule: Update Entity Record
- Rule: Delete Entity Record
- Rule: Add to Queue
- Rule: Trigger workflow
- Leveraging RPA in your App
- Leveraging Entities in Your App
- Leveraging Queues in Your App
- Leveraging Media in your app
- Leveraging Actions in your app
- Application Lifecycle Management (ALM)
- Basic Troubleshooting Guide
The Query builder
The Query builder allows you to filter data from Data Service entities, while respecting a predefined syntax.
Fetch() function to evaluate and sort your Data Service entities.
As a prerequisite, you must reference existing Data Service entities into your app. To use the Query builder, proceed with the following steps:
- For the desired control, select a VB enabled property. You can identify these types of properties by the VB Data source field in the General tab.
Fetch() function to retrieve and manipulate entity data.
Fetch() function has the following parameters:
|
FilterGroup |
A group of filters in Data Service |
|
PaginationProps |
Specify page size and number of records to skip. |
|
SortOption [] sortOptions |
Specify the column to sort and the order for sorting. |
|
string[] selectedFields |
Specify the entity fields that should be returned. |
|
ExpansionFieldOption[] expansionFieldOptions |
Specify which column of a relationship entity should be expanded and returned. Apps allows level one expansions, meaning that if you have a relationship field, the expressions expects one level of properties to be accessible. The query builder automatically adds these properties, and they are mandatory for the non-system entities. |
Fetch() returns a ListSource<T>, which is the same type as for list controls, FetchOne() returns a single record of type T.
Fetch() function, to get more customized results:
Gets the number of records for an entity, for example SystemUsers.
Fetch(of SystemUsers)()Fetch(of SystemUsers)()Fetch(of SystemUsers)(createFilterGroup(new QueryFilter(){addFilter("Name", "=", "You")}), new PaginationProps(0, 10))Fetch(of SystemUsers)(createFilterGroup(new QueryFilter(){addFilter("Name", "=", "You")}), new PaginationProps(0, 10))Fetch(of SystemUsers)(createFilterGroup(new QueryFilter(){addFilter("Name", "=", "You")}), new PaginationProps(0, 10), new SortOption(){addSortOption("Date")})Fetch(of SystemUsers)(createFilterGroup(new QueryFilter(){addFilter("Name", "=", "You")}), new PaginationProps(0, 10), new SortOption(){addSortOption("Date")})Fetch(of SystemUsers)(createFilterGroup(new QueryFilter(){addFilter("Name", "=", "You")}), new PaginationProps(0, 10), new SortOption(){addSortOption("Date", true)})Fetch(of SystemUsers)(createFilterGroup(new QueryFilter(){addFilter("Name", "=", "You")}), new PaginationProps(0, 10), new SortOption(){addSortOption("Date", true)})Fetch(of SystemUsers)(Nothing, new PaginationProps(0, 100))Fetch(of SystemUsers)(Nothing, new PaginationProps(0, 100))For example, for the Edit Grid control:
Fetch(of SystemUsers)(Nothing, new PaginationProps(MainPage.EditableGrid.PageStart, MainPage.EditableGrid.PageLimit))Fetch(of SystemUsers)(Nothing, new PaginationProps(MainPage.EditableGrid.PageStart, MainPage.EditableGrid.PageLimit))Fetch(of SystemUsers)(createFilterGroup(new QueryFilter(){addFilter("Name", "=", "You")}), new PaginationProps(0, 10), Nothing, new string(){"Name"})Fetch(of SystemUsers)(createFilterGroup(new QueryFilter(){addFilter("Name", "=", "You")}), new PaginationProps(0, 10), Nothing, new string(){"Name"})- Using the Query builder
- The Fetch function
- The FetchOne() function
- Simple Fetch
- Fetch with filter condition
- Fetch with filter condition and sort order (ascending)
- Fetch with filter condition and sort order (descending)
- Fetch with static PaginationProps
- Fetch with control bound PaginationProps
- Fetch with projection
