2 Replies Latest reply on Aug 20, 2014 8:32 AM by 2655429

    Custom query conditions in db adapter




      How to execute custom query in bpel db adapter?

      For example :

      1. select * from employee where status = 'N' and address is not null

      2. select * from empoyee where substatus = 'Y' and phone is null


      after where keyword - query part is dynamic, parameter combinations and count is unlimited ( depends on business logic ). It is not possible to implement each condition parameter as parameter in db adapter configuration.

      Db adatper query has to be something like  : select * from employee where #condition# , but #condtion# need to be interpretated as condition not string with quotes..


      best Regards,