I would like to able to click in the cells of the
generated report, and get the result of 'select * from
<measure table> where <filter for record making up the
cell>' in a table.
You can find a preliminary PoC patch attached.
If you supply a "queryOutput" page, which does the
SQL query given to it as argument, and s/"/\\"/ in the sql in
XTabHTMLRenderer.java, it would even work...
I do not suggest this use however, because such a page would
bring a lot of problems.
This patch brings in some infrastructure, and if someone
knows how to store the SQL in the session instead of giving
it to the user (I do not know Java web programming,
and even hate Java.), the problem is solved with help of
an SQl table viewer, which I guess is easy to borrow from
some other project.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=588095
This feature was planned, however development is currently
on hold (all the developers are busy with other projects).
Logged In: YES
user_id=674941
You can find a preliminary PoC patch attached.
If you supply a "queryOutput" page, which does the
SQL query given to it as argument, and s/"/\\"/ in the sql in
XTabHTMLRenderer.java, it would even work...
I do not suggest this use however, because such a page would
bring a lot of problems.
This patch brings in some infrastructure, and if someone
knows how to store the SQL in the session instead of giving
it to the user (I do not know Java web programming,
and even hate Java.), the problem is solved with help of
an SQl table viewer, which I guess is easy to borrow from
some other project.
The patch
Logged In: YES
user_id=674941
Forgot to mention that the patch also contains the fix in
1256951