APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is there a report that has a search filter for one column but applies to other columns?

Idkfa2Jan 29 2021

Hello all,
I think what I'm looking for is the facet search, but wanted to make sure that's what I need.
I have one table with column APPT_DATE and another table with RCHDL_DT1, RCHDL_DT2, and RCHDL_DT3. The user uses APPT_DATE to search a date range.
Is there a way that when the search criteria for APPT_DATE is selected (say a date range), that the date range will be searched in columns RCHDL_DT1, RCHDL_DT2, and RCHDL_DT3 in another table if I can join the tables?