So, what if we wanted the following query response:ĬustomerOrder_Id, CustomerOrder_Title, Customer_Title, Region_Titleīut how do we stitch together the tables? We use joins. (parent) CustomerOrder: Id, Title, CustomerID The table tied to that reference contains a reference to another table under that. So, we have a parent table that contains a reference. ParentTable: Id, Title, ChildTableReferenceĬhildTable: Id, Title, BabyTableReference Just spent a considerable time this morning trying to work this out and I think I have a solution for you.įirst - let's start with some generic pseudo structure: How do I convert the Customer AS c1 ON t.CustomerEMail = c1.EMail WHERE (c2.Email = CAMLJS, I got this far: (CompanyNo is equivalent to Nav_CustomerNo) var query = new CamlBuilder()īut I'm not sure how to proceed from here. I'm trying to convert the following SQL statement to a CAML query: SELECT t.Id, t.Name, t.CustomerIdĬustomer AS c1 ON t.CustomerEMail = c1.EMailĬustomer AS c2 ON c1.CompanyNo = c2.CompanyNo
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |