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

Select return type when using CAML query

I have a site with a list where one column is defined as lookup with multiple values.

Now I’m trying to query an item/column from this list from another site.

As the list and the workflow is not in the same site I’m using CAML query.

I would like to be able to select return type (Lookup Value as Text, Comma Delimited).

How can this be done in a CAML query?

Alternative: How can I format the result to plain text (without the list id and ;#) after the query-list?

 

 

0 Kudos
Reply
5 Replies
Automation Master
Automation Master

Re: Select return type when using CAML query

you cannot influence this with CAML, CAML always returns raw data from sharepoint.

save resultset into a collection and then parse/handle it accordingly

0 Kudos
Reply
gardal
Nintex Newbie

Re: Select return type when using CAML query

Thank you for your answer but it didn’t help.
I do save the resultset into a collection. Subsequently, I perform a collection operation: Exists.

But this results in a not correct answer regarding if the variable can be found in the collection.

I’m sure it is because the collection doesn’t contain just values but also ID’s.

 

If I instead call a web service “GetListItems” I receive a more correct result: [Id];#”Value”;# [Id];#”Value”
Then I think I should use the “Query XML” action to get only the values and not the ID's but this doesn’t really work:

 

0 Kudos
Reply
Automation Master
Automation Master

Re: Select return type when using CAML query

I'm not sure what're trying to do...

above you've asked how to get singe lookup (text) values out of multiselect lookup field, which I advised possible approach for.

now you seem to search for something specific within the collection or within the selected lookup options. but I'm totally out of picture what you're searching for.

0 Kudos
Reply
gardal
Nintex Newbie

Re: Select return type when using CAML query

I just need to check if a value X is existing in a column in a list on another site which is defines as ”lookup” with multiple values.

0 Kudos
Reply
Automation Master
Automation Master

Re: Select return type when using CAML query

then I'd define directly CAML to return just items that have selected specific value 'X' among lookup options and didn't complicated things with filtering in workflow

0 Kudos
Reply