Query List Filter Parameter - Choice with Checkbox Values

  • 30 October 2019
  • 2 replies
  • 8 views
K
Badge +12

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.

2 replies

SimonMuntz
Userlevel 6
Badge +22
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.
Cool Nintex courses: https://learn.nintex.com/
K
Badge +12

@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 !!!!

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings