Is it possible to utilize the data that is returned by a CUSSTOM SQL query on a database to create the DasshBoard elements ?
So far i was ablle to connect to a specific Table and use it in AS IS form ( no interaction with multible tables )
Any pointers in this topic would be much appreciated.
Thanks, IP.
I'd recommend creating a View in your database and creating a datasource that connects to that view. The view would join all the tables you need.
Edit:
If you don't have permissions to create a view, you still have some options: