In which file can i add custom sql complex queries to fetch data from another database table and how?

Are you trying to offer a read-only view into another system's data?

I would consider a Dashlet in an Intelligence Pane for that, especially if the query to retrieve the data will need parameters from one of your Sugar records.

For example, we have Contacts in Sugar but Licenses elsewhere. I have a License Dashlet in the Intelligence Pane on Contacts that queries the License system and displays that Contact's Licenses.

There is an example of a dashlet with external data written by Olivier Nepomiachty here:

Write a dashlet that uses an external data source: the Football World Cup dashlet 

You will need to adapt it to pass the parameters from the Contact to your query to build the data to be displayed.

I can't find examples of this right now but what you want is a contextual dashlet.

Hope this helps,
FrancescaS

OMG Francesca, you dug up that old post from July 2014  ^_^

The code still works and the approach is still accurate. 

/Oli

OMG Francesca, you dug up that old post from July 2014  ^_^

The code still works and the approach is still accurate. 

/Oli

Hello Francesca Shiekh !!!

Thank you for your reply but let me explain through an example what i

exactly want..

Suppose i have a module let's say it as Patients and in the patients

module,i have further informations of patient including patient city and

near by hospitals.Now when i select patient's city from dropdown then in

the near by hospitals field,i want to display hospitals in that dropdown

fetched from another db table which contains all hospitals according to

cities.

On Thu, Jan 10, 2019 at 4:17 AM Olivier Nepomiachty <