cancel
Showing results for 
Search instead for 
Did you mean: 
davidjohnson500
Nintex Newbie

How to JOIN on 2 Query Filters

Jump to solution

I have 2 Query filters:

The First Query Filter list all the students current classes and levels

I am looping thru this Query Filter one record at a time and providing various information

Since I am now being asked for specific information on the class I have created a second Query Filter

The Second Query filter contains unique records based on the class name and class level.

As I am looping thru the First Query I want to link the current record from the First Query to the Second Query filter based on Class Name and Class Level.  If I match on this join then I wanted to assign a Teacher name found in the Second Query to a variable called txtTeach.

I have created both Queries and the initial loop, but I am stuck on the lookup to the second query.  Due to the amount of the records in the second query I want to avoid a second loop.  Also note my second query is a CAML query from an alternate site.  I suppose I could attempt to pass in the Class Name and Class Level from the First Query into the Second Query (CAML query) ?

What is a good approach ?

Labels: (1)
0 Kudos
Reply
3 Replies
sojanm
Nintex Newbie

Re: How to JOIN on 2 Query Filters

Jump to solution

Hope you are using the collection variable to store the records from the first list query.

You can also add the two more collection variable to for className and class level. While looping , use collection operation control to get the class name and class level to a variable. Use this variable to in second query to filter, if the record is uniqe on ClassName and class  level , you will get only one record.

Reply
emha
Nintex Newbie

Re: How to JOIN on 2 Query Filters

Jump to solution

do you query the same list in both queries or are they two lists?

how the lists are linked? some lookup fields or simple texts?

could you provide example of your setup?

Reply
davidjohnson500
Nintex Newbie

Re: How to JOIN on 2 Query Filters

Jump to solution

2 different lists but hey both contain 2 fields that are the same:className and class level

0 Kudos
Reply