Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Table view filter based on multi select field

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

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.
Feb 01, 2023

This really as simple as just having this

color:B

Alex

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.
Feb 02, 2023

Well... then just put

color:B OR color:W

Alex 

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.
Feb 02, 2023

Then you just put

color:B

as explained before

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

thanks! will try color:B 

It worked, thanks again

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events