Table view filter based on multi select field

Markisio February 1, 2023

Hi there

 

trying to find the formula on how to filter dataset based on a multi select field value 

 

for instance

multi select dropdown field name is color and contain the values

Id: B

Value: Black

Id: W

value: White

 

One of the record has Black and White

 

in table view confiform would like to filter based on color contain black

I tried this: color.asArrayOfIds:B

but doesn't work, please help

1 answer

1 accepted

0 votes
Answer accepted
Markisio February 1, 2023

I figured this answer, color.id:*B*. Works fine but not sure if there is a better answer

Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 1, 2023

This really as simple as just having this

color:B

Alex

Markisio February 2, 2023

Hi @Alex Medved _ConfiForms_ 

 

yes if the value is single selection, but remember the field is multi select Color so I could have black and white as a value, your suggestion was my first attempt but only work if value only black but it doesn’t work when I have both Colors

so I hope my solution *B* is correct as I want return any records that contain black 

thanks 

Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 2, 2023

Well... then just put

color:B OR color:W

Alex 

Markisio February 2, 2023

Not sure if that will work, i simplified the values here, I could have 15 colors. My goal is get me records that contain black 

Color is multi select drop-down, so some records has only black some has on white some has both 

The result I am looking for any records that contain black in multi select value, therefore I shouldn’t get records with white only, I should get a records with black only or records with black and white 

thanks 

Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 2, 2023

Then you just put

color:B

as explained before

Markisio February 2, 2023

Oh I see, I was trying with color.Id:B  

thanks! will try color:B 

Markisio February 2, 2023

It worked, thanks again

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events