Confiform filter specific value from multiselect field

[Markisio]

Hi there

I have multi select field in Confiform called pods and has these specific selections (each bullet is a row):

1. A, B, C, D
2. D, X, Y
3. A
4. C, A

Form has the following fields 

• Function
• pods

Would like to retrieve the rows that contain pod A, based on above it will return 1, 3, & 4 within tableview filter

thanks 

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

Just use the filtering expression like this

pods:A

Alex

[Markisio]

hi @Alex Medved _ConfiForms_ 

I just realized what you suggested doesn't work, it's returning only record # 3 as per example above. I tries to use entry._func.asEntryRef() but that didn't work either. thanks

[Alex Medved _ConfiForms_]

Hi

I absolutely dont know how the "entry._func.asEntryRef()" is related here

To match ANY record that HAS an option A you may consider doing this

pods.hasValue(A):true

But honestly, it works fine using both approaches

Alex

[Markisio]

thanks @Alex Medved _ConfiForms_ , if I have the values right on the form then yes it will work, but if I have smart multi select for instance pod.key:A it won't work. is there a different syntax if I use filter against smart multi select? let me add more context. 

Here is form 1 called podForm, has the following fields 

podName - contain the following: X, Y, Z

key - Contain the following: A , B , C

here is form 2 called issueForm, has th following fields 

issueType

issue

pod <-- Smart MultiSelect

I want to display in tableview the data based on pod key A, so I did pod.key:A won't work, but it will work like this pod.podName:X or pod.key:*A*

I dont want to use pod name, off course the actual names are not single letter :) 

thanks 

[Alex Medved _ConfiForms_]

Well, this is a completely different task... in comparison to what you have asked initially

Basically you want to filter by values in a different form that your smart multi-select is using

See this demo: http://recordit.co/Atdt3GlTmj

Alex