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,

[Alex Medved _ConfiForms_]

Hi  

Looks like the filtering for the multi-label misbehaves on DC version (works fine on cloud)

Something we need to fix, I afraid

Alex

[Daniel Santa Cruz]

That's unfortunate to hear, is there any work around I could try for this? I though of making another field, possibly a free text field that auto populates with Tags.asArray?

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

[Daniel Santa Cruz]

Hey Peter,

Thank you for the information. I am not sure if I am understanding correctly.

When I type in Tags:~Hello to the free text field, it still fails to find any entries with Tags INCLUDES Hello.

Also the links provided don't seem to work, "Page Not Found".

Thank you