Calling stored function in queryString

[2006 IR Open Discussion]

By: agalper - agalper

Calling stored function in queryString

2003-05-11 23:40

I'd like to call a stored function that returns a ResultSet from within the queryString element of a JasperReport specification. The syntax would look like:

 

<queryString> { ? = call myStoredFunc($P{param1}, $P{param2}, $P{param3} } </queryString>

 

I've modified JRQueryExecuter to handle this.

 

Question: Is there a better way to do this that does not require modification of base JR code? I really want to keep the query specification in the report spec, so wrapping a ResultSet in a JRDataSource before sending off to the filler doesn't cut it.