Skip to Main Content

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!

Faceted Search Input Field: Comparison Operator "starts with", match against two columns?

Cody ReandeauFeb 12 2024

Hello all,

With regards to the faceted search, was wondering if it was possible to match against two fields with one facet? Basically, I want to match against two different name fields (first name, and aka first name, i.e. Robert, Bob). I also want to use the “starts with” comparison operator. It seems as though I can't have a comma separated column source. Is there an out of the box way to do this? I know I can use the facet type “Search” to compare against multiple, however that is checking anywhere in the text, and not just the beginning.

Example: user types, “R”, Robert is shown in the results. If the user instead starts with “B”, Bob being the aka name, the same record is also in the results.

Any ideas?

Best,

Cody

Comments
Post Details
Added on Feb 12 2024
0 comments
325 views