Dynamic Where Clause

[jainpran]

Hi,

 

I want to dynamically pass where cluase to the query. Situation is, I have written query in jrxml file like this:

 

select empId, empName

from emp

 

I want to dynamically build where clause depending on what user has entered as search parameters. It can be either empId or empName or both. So final query can be:

 

select empId, empName

from emp

where empId = 1

 

OR

 

select empId, empName

from emp

where empName LIKE '%ab%'

 

OR

 

select empId, empName

from emp

where empId = 1

and empName LIKE '%ab%'

 

Can you please tell me how to create such where clause (passing it as parameter)?

[Pedja]

You can do this by setting the query to

 

select empId, empName

from emp

where $P!{WHERE_PARAM}

 

and then putting what you want in WHERE_PARAM.

[jainpran]

thanx..:)