Dynamic selection criteria for query

[Former Member]

I need to write a query which will dynamic entries for where clause. The criteria's for where clause may change accordingly. For eg: For selecting some employee details, the search may be on employee id or birthday. How do i set dynamic parameters for my query in web dynpro java.

[Former Member]

Hi Ankita,

As per your example make the emp id or emp b'day as key field in table where u have saved employee's data.

and give emp id or emp b'day as select options and then use that select options in your where clause.

bhupender.