It's all about the answers!

Ask a question

BIRT- SQL query debugging-how to


RTC User (216) | asked Sep 29 '20, 4:57 a.m.

 I want to debug SQL query of BIRT report. I tried below code to get the generated query log but was not much helpful.


I added below script in Data Set -> open event.
importPackage( Packages.java.io );
out = new PrintWriter( new FileWriter( "c:/birt_logs/query.txt", true ) );
out.println( "My Query: " + this.queryText);
out.close();

if anyone knows how to get a runtime generated query logs, it will be helpful to everyone.


Comments
Ralph Schoon commented Sep 29 '20, 10:14 a.m. | edited Sep 29 '20, 10:14 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Consider to ask your questions on a BIRT forum. At least the ones that are only BIRT related.

Be the first one to answer this question!


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.