apps
2023.10
true
- Getting Started
- Before You Begin
- How To
- Build Your First App
- Build a Mobile-friendly App
- Embed Apps
- Embed Maps
- General User Experience Guidelines
- Hide Containers Using a Button
- Include Excel Charts in Apps
- Include MailTo Links
- Include Star Ratings
- Use Count With Choice Set Values
- Use Document Viewer
- Use Master Detail View
- Use Selected Values From a Table
- Use the Send Interim Result Activity
- Set External Context
- Work With Data Source and Value Bind
- Notifications
- 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 Values
- Rule: Start Process
- Rule: Upload File to Storage Bucket
- Rule: Get File From Storage Bucket
- Rule: Reset Values
- Rule: Create/Update Entity Record
- Rule: Delete Entity Record
- Rule: Add to Queue
- Function: And, Or, Not
- Function: Concat
- Function: Contains
- Function: Count
- Function: EndsWith
- Function: If
- Function: IsBlank
- Function: Guid
- Function: Length
- Function: List
- Function: StartsWith
- Function: Sum
- Function: Sort
- Function: Now
- Function: Today
- Function: Time
- Function: Year
- Function: Month
- Function: Day
- Function: Hour
- Function: Minute
- Function: New
- Function: Lookup
- Function: Filter
- Leveraging RPA in your App
- Leveraging Entities in Your App
- Leveraging Queues in Your App
- Application Lifecycle Management (ALM)
- Basic Troubleshooting Guide
Function: Filter
LEGACY
Legacy Apps User Guide for Automation Suite
Last updated Jan 18, 2024
Function: Filter
Tip: To better understand how the Filter function works, check out the Using Apps with Data Service pages in the How To section.
Use this function to filter a table based on its fields.
This function performs a case insensitive check.
Tip:
Depending on your project's needs, you can choose to exclude certain conditions when using the Filter function. To exclude a condition, you can write an expression that resolves the filter field (first parameter of the condition
array) to a
null
. For example, you can use the following:
Filter(Customer, [If(IsBlank(Dropdown.Value), null, City), "=", Dropdown.Value])
In this case, the filter on City is only applied when the Dropdown contains a value other than blank.
Syntax |
Description |
Example |
---|---|---|
Filter(Entity, Condition) |
The function returns all records that result in true. These expressions can reference fields/columns by name. |
|
Argument |
Type |
Description |
---|---|---|
|
Required |
The entity to search (for example, a control's data property). |
|
Required |
The condition used to lookup for in the entity. The format for the
Condition argument should be as follows:
The following operators can be used:
|