cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Automation Master
Automation Master

Query List Filter Parameter - Choice with Checkbox Values

How can I use choice with check box values as a filter value in query list action?

 

  1. I've list 1 having choice column called "Group" with check box.....values are A,B,C,D,E,F,G
    1. Item # 1 was created and has value B, C, F
  2. In list 2, I've choice column called "Grouping" with check box....values are A,B,C,D,E,F,G, ALL (ALL is default)
    1. Item # 1 was created and has value B, F
    2. Item # 2 was created and has value ALL
    3. Item # 3 was created and has value ALL, A, C, G
    4. Item # 4 was created and has value A, D, G
  3. Now in list 1, I'm running the list workflow:
    1. I'm querying list 2 and passing below filter parameters:
      1. Grouping = ALL or Grouping = Item Property:Group (based on filter parameters, aim is to get Item # 1, 2 & 3 from list # 2)

I've also tried "Contains" in the filter but neither of them is working. Also tried CAML query but no luck.

Labels: (1)
0 Kudos
Reply
2 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: Query List Filter Parameter - Choice with Checkbox Values

It looks like the comma special character is causing issues and I tried everything I know to escape it but none worked.
You would have to do two queries. One that looks for ALL and the other that looks for B and F to return the results you want.
Then merge the collection variables.
0 Kudos
Reply
Highlighted
Automation Master
Automation Master

Re: Query List Filter Parameter - Choice with Checkbox Values

@SimonMuntz ....I was thinking something similar, approach which I was thinking is:

  • Using RegEx split list 1 column by ;# and create collection
  • For each value in collection check if that item exists in list 2 column
  • If it does for all the values then add that ID into collection

 

I was hoping I'll have something more simple solution !!!!

0 Kudos
Reply