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

Query list: Multiple return columns = multiple collections?

Jump to solution

I am querying a list for Name, Title, Phone with a filter so that the expected result is say 5 items (with the goal of building a contact list string to insert into a notification). The UI apparently wants me to store the results into a collection of Names, a collection of Titles, and a collection of Phones -- 3 collections total.

 

Is there a way to get the results from a list query into a single result set? Or is there just no Nintex construct that matches a "result set" or hashtable type of data structure? Without it I guess I need to do a ForEach with a couple Pops (collection operation) inside of it. Or is there a best practice here I'm missing that would serve me better?

 

Thanks.

Labels: (1)
0 Kudos
Reply
5 Replies
amchargue
Nintex Newbie

Re: Query list: Multiple return columns = multiple collections?

Jump to solution

My approach is more or less like the first one (his own) Dan lists here Formatting Results to an Email except I'm using Pop instead of Get (with index). So I guess there aren't better options (?).

0 Kudos
Reply
murphybp2
Nintex Newbie

Re: Query list: Multiple return columns = multiple collections?

Jump to solution

You could try using a web service call.  You can use the "GetListItems" method to query a list, and the results will be in a single XML.  Then use a Query XML to build your results.  But I don't think this is an easier way of doing it.

0 Kudos
Reply
amchargue
Nintex Newbie

Re: Query list: Multiple return columns = multiple collections?

Jump to solution

Vadim's post here uses a web service call here with XSL transformation, Nintex Workflow - XSL Transformation - Vadim Tabakman. Interesting approach - as he says "The impressive thing about all of this, is that the workflow required to get all the information from this list, transform it into something visually appealing and send it in an email just take 2 actions" - but usually would rather avoid XSLT. I understand it but others may not.

0 Kudos
Reply
murphybp2
Nintex Newbie

Re: Query list: Multiple return columns = multiple collections?

Jump to solution

I think this is the link to Vadim's post you meant to post. Nintex Connect - How to use Collection Operation to parse an XML string

0 Kudos
Reply
amchargue
Nintex Newbie

Re: Query list: Multiple return columns = multiple collections?

Jump to solution
0 Kudos
Reply