Filter Records using Request Parameter

Introduction

This guide outlines the process of filtering records based on the value provided in a request parameter. Filtering records allows you to dynamically display data that meets specific criteria, improving the relevance and usability of your data lists.

How does it work?

1. Identify the column you want to filter. For example, if you want to filter records based on approval status, this will be the column you use for filtering.
   

2. Navigate to Source > Select Source of Data (data store) (Advanced Form Data data store) > Advanced, and add in the appropriate Extra Filter Condition.

   Example code to filter records where the "approval" column is set to 'Approved':

   e.customProperties.approval = 'Approved'

   

3. If you are using the Advanced Form Data List Data Store, you can add the filter in the same way as shown below:

   

4. Once configured, the list will now filter records based on the specified condition. For instance, the records displayed will only include those with the status set to Approved.