I have a table containing images, where each image features a group of people. Another table stores the names of the individuals in each image, forming a one-to-many relationship. An image can include one or more people, and a person can appear in one or more images.
I created a faceted search page with two facets:
- Event Name
- Names of Persons
When I select an event, one or more images are displayed, and the list of persons is filtered to include only those visible in the displayed images. This works perfectly!
However, if I do not restrict the images to a single event, I want to use the Persons facet to search for images that show only the individuals I select in the Persons facet.
Currently, the behavior is to show images featuring Person A or Person B, but I would like to modify it so that it only shows images featuring Person A and Person B.
My Questions:
- Can this be achieved declaratively in Oracle APEX?
- If not, how can I implement this?
- Is it possible to add a clause to the
WHERE section of the query to restrict the rows based on the selected facets?