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 ?
Solved! Go 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.
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?