CAML Query List

[rj989]

Hi guys 

I have one sharepoint list at site A which has a unique id and the same unique id is present in other sharepoint site B at different location list called "Sys_id".

I want to bring the Go live date,"Status" value in site B, to site A list where  "Sys_id" = "Unique id" 

Site List A has fields  ID, Project Name , Status, Go live date

Site List B has fields  ID, Sys_ID, Project name , Status, Go live date

Trying to use "Query list" in nintex workflow..still no success

Thanks

[rickdemarco]

Hi @rj989 

If i understand correctly you are trying to find where id's match across different lists (lookup)? Firstly CAML is not a supported query language so you won't be able to use that. One way you might be able to solve this is by iterating through multiple loops, first query the items in the first list, then pass the ID of each item into the condition of a query across the second list and that you way the second loop will only return the item with matches the ID's. Hopefully this helps..

Cheers, Rick