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

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