Can CAML query handle multiple lists?
-
Is it possible for CAML query to handle multiple lists? If so, how would you write a single query to accommodate multiple lists? Any links for references? I can only find references on writing a query for a single list only. For example I want to write a summary page combining the following lists: Address List Phone Number List Customer Name List To create Customer Summary that will combine all the lists into one. Is this possible?
-
Is it possible for CAML query to handle multiple lists? If so, how would you write a single query to accommodate multiple lists? Any links for references? I can only find references on writing a query for a single list only. For example I want to write a summary page combining the following lists: Address List Phone Number List Customer Name List To create Customer Summary that will combine all the lists into one. Is this possible?
Clark Kent123 wrote:
To create Customer Summary that will combine all the lists into one.
I'm not sure, but as far as I know it's not possible with CAML, but you could use LINQ or you could use .NET for accessing and combing Lists.
------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.
-
Clark Kent123 wrote:
To create Customer Summary that will combine all the lists into one.
I'm not sure, but as far as I know it's not possible with CAML, but you could use LINQ or you could use .NET for accessing and combing Lists.
------------------------------ Author of Primary ROleplaying SysTem How do I take my coffee? Black as midnight on a moonless night. War doesn't determine who's right. War determines who's left.
Thanks for that reply. I have been doing more research and some people in other forums suggest to try using a "Join" query. I will give that a shot. This could be so much easier if I could use SQL. But oh well. Thanks though.