External filtering allows you to define specific query conditions via an input. To use external filtering, you need to construct a JSON array defining the conditions of the search in the following format.
In this example, we are doing a simple search to check if a field contains a specific value. The left, op, and right values match exactly what we would see in the Query All Records expression builder. See this reference for a list of the operators available and what they mean.
If you want to define multiple search conditions, you can add additional objects to the "expression" array.
Next, link the configuration in the External query tab to the JSON input using the drop down menu.
Additionally, select "Allow Filtering Additions" permission.
Now, we are ready to use the filter by external query.
Because the external query takes a JSON input, we must format the input in a JSON like the examples below.
In this example, the input named "external" was added and is a JSON data type.
In this example, under the External tab of the Query all Records function, we linked up the input "external" for external filtering. Additionally, we selected the permission to Allow Filter Additions.
In this example, the code block above is pasted into the Run & Debug. This will filter by users with the email address "test@email.com."