Skip to Main Content
Feature Request FR-3146
Product Area Page Components
Status CLOSED

21 Voters

Faceted Search for Multiple Regions on a Page

kcannell-2 Public · May 15 2023

Enable Declarative Facet Search on Multiple Regions on a Page
On pages with a Faceted Search region, allow the faceted search to apply to more than one “results” region on the page.  Right now we can do this by adding a WHERE condition that tracks the facet items to the non-faceted-search region(s).  But it would be cool to be able to do this declaratively.

Use Case
For example, allow a single Faceted Search region to apply to/filer both a map region and a report region, or multiple report regions.  The faceted search controls te visible display on the map and the contents of te report or reports.  

Preferred Solution (Optional)
Instead of allowing only one region for facets search results, allow multiple.  Even a multi-select may work.  The regions of course need to be faceted-search-enabled like Map or Classic Report.

Or this could operate like master-detail - if there is a faceted search region on the page, for all eligible reagions on the page there would appear a Enable Faceted Search on this region?  element in the region's attributes.

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Known Duplicates

Known duplicates

FR-2252
FR-2252 Faceted Search, search results can be toggled as report or cards.

Comments

Comments

  • carsten.czarski APEX Team OP 2 years ago

    Currently, this blog posting describes the most appropriate way to hook up additional regions with Faceted Search: https://blogs.oracle.com/apex/post/add-a-chart-to-your-faceted-search-page

    There is one caveat with this requirement, for which I would like to get people's opinions:

    In the Facet, there is a mapping to a database column, which is provided by the report, cards or map region, e.g. the PX_SAL facet references the SAL column, provided by the classic report. Different regions could provide columns under different names (and even having different data types). How would people want to have APEX dealing with that, i.e. which configuration choices would you like to see?

  • greg OP 2 years ago

    I could see allowing the Facet to map to multiple region-columns by name. If the name of the column matches across regions then let it filter them all. 

    However I see how this whole thing could be difficult if you want to do anything with the counts of records.

    I don't want to derail the discussion but I can see how there could be a desire to have multiple regions (with facets) that all use the same base query. Maybe a report combined with a a map of those same results. Here rather than having a filter against multiple regions I would prefer a sort of data block region that the other regions could use as their source.

  • kcannell-2 OP 1.7 years ago

    I was thinking as Greg - multi regions w the same base query, or similar.

    I totally get the having to specify the column name - I would have accepted the requirement that the column names have ot be the same, or, the key column for each region has to be identifed.  Somethign simillar to how master-detail reports get linked (though in this case there is no DB relation behind the scenes).

    Anyways, thank you very much for considering this - I totally understand there are bigger issues to address in APEX-land - and we have the workaround.

    Many thanks - Karen