Scriptlet method beforeReportInit() calls AFTER execution of main query

[aprilsw]

I made a test with scriptlet and main query (pl/sql call procedure with cursor returns)

And find out that sql execution of main query starts earlier than beforeReportInit()

How can i do something (write logs into DB and etc) before main query is executed?

[Michael Bielkiewicz]

Unfortunately, I don't think a Scriptlet will work for you in this instance. I believe beforeReportInit is triggered just before the Report is initialized which happens after the query is executed. See https://community.jaspersoft.com/jasperreports-library/issues/4551 for more details on the flow. Per that link, I think a custom SQL Executor is what you will need - then you can do whatever you want before our SQL is executed. I hope this helps.

-Mike

[aprilsw]

Thank you!