Sugar SOAP request for selecting across modules

[openatrix]

Hi,

Does Sugar SOAP support selecting records across 2 or more modules. For example
what is the equivalent of the following in SOAP:

select accounts.name, cases.name, cases.status
from accounts, cases
where accounts.id = cases.account_id

search_by_modules does not join the modules. It simply sends back ids of all the matched
records for the requested modules.

Thanks

sc

[crmsiva]

Hi

There is no such facility available as of now. But it is possible by adding code to the existing soap.

[andopes]

Actually you can retrieve these data looking at Cases modules through SOAP.
You can get the account name when looking for a Case.

Cheers

[openatrix]

Thank you for responding to my query. I agree if it's basic info like account.name then you could use Cases module itself in SOAP Get_results_list query. However if you are looking to get more than that then you would need to do code changes at the server side.

I just hope the next major upgrade to Web Services API will address all these issues.

sc