Hello,
Am trying to build a search form using a complex VO (i.e. not backed by EO) which joins several tables to fetch the data and display in a separate table similar to ADF LOV popup. To make matters worse, it uses a key value rather than descriptions to query for some columns. My UI design shouldn't be using any of the standard ADF search forms. I'm kind of struggling to make it work because that form should only append criteria to query if the user entered value is not null on the form. How can I achieve this?

Thanks,
Phani Vemi