Confiforms Filter Control filter IF CONTAINS certain Tag

Daniel Santa Cruz

Hello all,

I have a Coniform Form with a Dynamic Multi-Label named "Tags" that allows multiple values entered in.

Within my display page I have a Matrix View, with a Filter Control macro to filter the tags. I notice however that the filter control will only return entries that ONLY have what is entered into the Filter. 

Example: 

Entry 1 Tags: Hello, World

Entry 2 Tags: Lorem, Ipsum

If within the Filter Control I enter "Hello" it will return no results. I have to enter "Hello, World" to show the entry. I want it to return anything that contains "Hello" even if it isn't the only tag in the entry.

 

Thank you,

Peter_DevSamurai

Hi @Daniel Santa Cruz ,

What you’re seeing is how ConfiForms works by default with multi-value fields like your Dynamic Multi-Label “Tags” field. With the tag Hello, World -> The filter Hello is treated as an exact match on the full valiue so it would not match. For the best solution, you need to use a contains operator in the filter.

Use ~ (contains) in the filter:

• In a where / filter parameter on the view ->  Tags ~ "Hello"
• Or in Filter COntrol binding syntax: Tags:~Hello
  

The key change is using ~ on the Tags field so that it matches any record where the multi-label field contains that value among its labels, not only where the full string equals that value.

I hope the below documents are helpful for you:

• Filters & IQL syntax (operators like ~ / contains)
• Filter Control macro config
• Views (Table/Matrix)

Hope everything works out well for you.

Best regards, 

Peter