BIRT- SQL query debugging-how to

RTC User (21●4) | 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!