I got a question regarding CAML and retrieving data. I need to determine the proper people based upon the places user submits.
So I created the lists People-Place where I have column Place and column User.
Now I would like to retrieve people from SP List based on the user Places choice. I was able to do it for each item separately - place A -> person A. This is easy with Eq operator in CAML.
Now I want to go a little bit further- user uses many places (place A, place B, place C). I pass the values into my retrieving function. I don't want to split my input string and iterate over asynchronous function. Is there any way how to check if the field with name People is a substring of Query value? In JS the indexOf function could do the job. Is sth similar in CAML or do I really need to use a loop?
Thanks in advance for you help !