4 Replies Latest reply: Jul 10, 2013 6:27 AM by Santosh M E RSS

    Dynamic where clause in database adapter




      I have requirement to develop SOA service for search page! The back-end query for search is required to have where clauses to be appended to SELECT statement dynamically depending upon search criteria the user selects!


      E.g. if user is searching employee from a portal! If employee selects mobile number of the employee, or joining date range or other criteria, then accordingly appropriate clauses are to be appended to SEARCH SELECT statement.


      Can we achieve same while implementing executing database query through database adapter from BPEL service?


      Thanks In Advance