Finding SQL query from BO canned reports thru SDKs

system · August 17, 2009, 8:04am

Hi,

Is it possible to fetch the SQL queries generated by BO canned reports? I have list of 200 reports saved in my local desktop and I want to fetch the sql queries from them. This is required for documentation purpose. Please let me know if it is possible by using BO SDKs.

Thanks

maximus82 (BOB member since 2009-08-17)

system · August 17, 2009, 8:07am

Welcome to B:bob:B!

[Moderator Note: Moving to SDK - Jansi]

Jansi (BOB member since 2008-05-12)

system · August 17, 2009, 3:52pm

What version of Bus Obj?

I have java code for BOXI R2 that does this but it fetches the reports from the repository, not from a local drive.

jwhite9 (BOB member since 2006-07-28)

system · August 17, 2009, 4:03pm

Hi Sivaramky,

Give this utility a try:

I use to use it when I need to check queries of many DeskI reports.

Marek Chladny (BOB member since 2003-11-27)

system · August 17, 2009, 6:15pm

Hi Marek Chladny,

Amazing! If you dont mind, could you please explain the basics behind it?

maximus82 (BOB member since 2009-08-17)

system · August 17, 2009, 6:20pm

Hi jwhite,

Finding details from repository is also fine, even i have done a small java coding to find the SQLs but facing an error while opening the report document. Getting “unable to load the report” error.

Please share the code that you have written, that would help me to understand. Thanks

maximus82 (BOB member since 2009-08-17)

system · August 17, 2009, 7:50pm

The code of the utility opens reports from a specified directory in a loop. In every loop, all data providers of a report are checked and their queries written to a txt file.

Marek Chladny (BOB member since 2003-11-27)