dynamic where clause in query

[ojha]

hello,

i want to use dynamic where clause with help of $P!{...}. Please tell me which jasper report version will support this tag.

 

thanking you

ojha

[aniruddh4u]

Hi,,

You can't change query dynamically like

for condition1 .... QueryA or condition2...QueryB

but yes ireport 1.3.1 support u writing filter expression for query in this you can write expression

 

 

-- Aniruddh

[janejiang]

You can define parameters in your report, and use the parameter in the report query.

 

For example, if you define a parameter param_report_id, your report query can be something like

 

SELECT * FROM table_name WHERE column_name = $P{param_report_id}

 

If you need to use numeric parameter, it is easier to define it as string then do

 

SELECT * FROM table_name WHERE to_char(column_name) = $P{param_report_id}

 

Hope this helps,

 

Jane

[ojha]

:) thanks jane .

i got it.

...ojha