Eclipse Community Forums: BIRT » SQL with Parameters

Help

Home

Home » Archived » BIRT » SQL with Parameters

Show: Today's Messages :: Show Polls :: Message Navigator

SQL with Parameters [message #1772441]

Sat, 09 September 2017 21:21

Dave Paulson

Messages: 7
Registered: September 2017

Junior Member

I'm new to BIRT, so please excuse my naivete. I'm working on a BIRT report that uses report parameters at runtime. These are linked to the appropriate dataset parameters, but the report fails with an error message that suggests the parameters are not effectively passing to the actual SQL query.

Is there a way to see the actual query string passed to the server? I tried setting the logging level to FINEST, and even though this logs the query, it doesn't appear to log the value of the parameters. After running the nonworking report and finding the "?" markers still in the string, I ran a report that works without error, and it too showed the markers and not the runtime values.

Any help would be appreciated.

Thanks,
Dave

[Updated on: Tue, 12 September 2017 18:34]

Report message to a moderator

Re: SQL with Parameters [message #1772580 is a reply to message #1772441]

Tue, 12 September 2017 15:37

Jerry Sheets

Messages: 76
Registered: July 2009
Location: Salt Lake City, UT

Member

Check this site http://developer.actuate.com/community/articles.html/_/articles/birt-books/le-birt-experts-guide-to-birt-best-practices-r24

the eBook 'LeBIRT; Experts Guide to BIRT Best Practices' has some code for creating a Debug Window. It will allow you to view 'this.queryText' and other data elements. It's the best debugging tool I have found.

Report message to a moderator

Re: SQL with Parameters [message #1772581 is a reply to message #1772580]

Tue, 12 September 2017 15:39

Jerry Sheets

Messages: 76
Registered: July 2009
Location: Salt Lake City, UT

Member

Free Alternative:
You can grab the complete query in the dataSet script with 'this.queryText'. Set it to a variable (i.e. myScript') in the Data Set 'afterOpen' method and display it on the report in a dynamic text element to view it.
// Capture the complete Query
reportContext.setPersistentGlobalVariable("myScript",this.queryText.toString());

myScript (place in a dynamic text element)

Report message to a moderator

Re: SQL with Parameters [message #1772593 is a reply to message #1772580]

Tue, 12 September 2017 18:47

Dave Paulson

Messages: 7
Registered: September 2017

Junior Member

The link to the book doesn't work. I tried searching Google too but found no links to buy the book. Are you aware of anyplace where it may be available?

Thanks,
Dave

Report message to a moderator