12-14-2016, 02:33 PM
Maybe a silly question, but I just assumed this was not possible: Can we use JOINS in queries made over webservice?
Can we use joins in webservice queries?
|
12-14-2016, 02:33 PM
Maybe a silly question, but I just assumed this was not possible: Can we use JOINS in queries made over webservice?
12-14-2016, 03:28 PM
Yes, you can but not the typical SQL join. The application knows how to setup the joins so you basically ask for what you need. For example:
select potentialname,Accounts.accountname from Potentials it will know how to join potentials and accounts to get the name. You can find some examples, with the resulting SQL here: https://github.com/tsolucio/coreBOSTests/blob/master/include/Webservices/VtigerModuleOperation_QueryTest.php#L138
Joe
TSolucio |
« Next Oldest | Next Newest »
|