TapeApp Filters with 'OR' boolean logic

🙏 Ask the Community
1

Hi community members, how can we use the filters with the OR boolean logic as currently we can apply the multiple filers which behave like the AND.
Use Case: I am working in ProcFu to get the filtered records and I need to apply the Single Text filters on multiple records where if any text entered to be searched in field A then it will return the record(s) and if not found then need to check in Field B and so on. But currently there seems no way to achieve this…
On ProcFu side I am writing the filters in Before Render and passing that in Content via custom token. See below
custom_tokens.library = “”; //shows all by default
my_variables[“param”] = url_parameters[“data”]; //we received the passed paramter from Dashboard

Filters on Before Process
my_variables.fieldVal1 = json_encode([

   [
    "field_id" => "669132",
    "field_type" => "single_text",
    "match_type" => "contains",
    "values" => [["value" => my_variables["param"]]],
    "type" => "text"

]
if(my_variables[“param”]!= “”){

if(my_variables.fieldVal1!=“” || my_variables.fieldVal2 !=“”){
custom_tokens.library = my_variables.fieldVal1;
}
}

here if I try to print any variable then it does not return the record(s) but only the filter with value of parameter like this

[{“field_id”:“669132”,“field_type”:“single_text”,“match_type”:“contains”,“values”:[{“value”:“trailhead”}],“type”:“text”}]

Filter Result
Filter Result1920Ă—835 54.4 KB

Filters
Filters1920Ă—653 108 KB

1 Like
2

Your option would be to run multiple queries one after one. However, this approach can be slower since it requires making several calls to the Tape API. At the moment, there’s no way to include this logic directly within the filters.

A simpler approach is to create a calculation field in Tape that concatenates the values from the fields you want to search. You can then filter based on this combined field. This is the method I use for Tape searches in ProcFu.

3

Thanks for the information and yeah, I am currently using the approach you shared but thought if the desired solution exist…