- Getting Started
- Demo apps
- 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
- Rule: Submit Action
- 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)
- UiPath® First-Party Apps
- 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:
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