mysql query

No, you cannot execute queries outside the context of the application for instances hosted on our OnDemand environment as you do not have access to the database.

What exactly are you trying to retrieve?

I am trying to get all contacts related to the team of a specific user.

If I were running sql query, it would look like this.

SELECT * FROM contacts LEFT JOIN (

     SELECT DISTINCT team_set_id FROM team_sets_teams LEFT JOIN (

          SELECT team_id FROM team_memberships WHERE user_id = '7dcedfe6-a574-41a2-dd61-5147ea8ab460'

     ) AS ti ON team_sets_teams.team_id = ti.team_id

) AS tsi ON contacts.team_set_id = tsi.team_set_id

Thanks,

You should consider creating a custom endpoint for the REST API. There you would be able to execute your query and retrieve the necessary records. Although, I would consider trimming it down to just SELECT id FROM ... or the very specific fields you need.

Thanks for your input.

I wasn't actually planning on requesting all fields, just kept it as such for brevity.

I am familiar with the .net languages with very little exposure to php and therefor reluctant to do such.

It would seem to me that the team_sets_teams is not accessible at all via the api. For example adding the following to where clause (in get_entry_list function) "contacts.team_set_id in(SELECT tst.team_set_id FROM team_sets_teams tst)" returns access denied error.

Thanks,

Thanks for your input.

I wasn't actually planning on requesting all fields, just kept it as such for brevity.

I am familiar with the .net languages with very little exposure to php and therefor reluctant to do such.

It would seem to me that the team_sets_teams is not accessible at all via the api. For example adding the following to where clause (in get_entry_list function) "contacts.team_set_id in(SELECT tst.team_set_id FROM team_sets_teams tst)" returns access denied error.

Thanks,

Yeah, given that the data it contains is primarily used for internal purposes, it is not exposed through the API. Creating a custom endpoint isn't too difficult, hopefully this will help you: SugarCRM Cookbook – Adding a REST endpoint « Sugar Developer Blog – SugarCRM

I finally figures it out, and was able to get what I needed without custom endpoint. You can see some of the details at IN Keyword

If I have a chance at a later time I will give more detais for others to benefit.

Thanks,