SQL Power Software Forum

I found some bugs relate to the power*dashboard related data function:

1. the column name of the related data table sometime saved in lower case, that makes that line of related data setup invisible, unchangeable, undeletable, and it wouldn't show up in the dashboard view.
2. in the popup window of related data, most of the window size is taken by the mete-data, that's useless for the end-user, how about put the description in the window title and hide the mete-data.
3. the dashboard should support custom SQL instead of just database table in the setup of related data.

Hi! Thanks for the input. Here are my responses:

1. This looks like a bug. I've filed it in bugzilla.

2. I agree. The table of data is far more important than the header information that takes up most/all of the popup window. I've filed this in bugzilla as well.

3. Although that would be convenient, I don't think we should do it. The problem is, we go to great lengths in the Dashboard to keep certain information away from certain users. There are privacy concerns around a lot of customer information, so we have to keep this in mind when contemplating new features. If we allow end users to formulate arbitrary queries, we will open a huge hole in our data privacy shield.

If you need to join to more than one table to obtain your related data, you could create a view and use that as your related "table."

-Jonathan