In a previous posting regarding Faceted Search, we requested some assistance in obtaining data from the Faceted Search to drive a Mapbox/Maplibre filter. Advice was given which greatly assisted in the process. We tried the same approach with Smart Filters and it seemed not to work. We are hoping for some further assistance. In particular, the previous request resulted in the following code snippet:
l_context := apex_region.open_query_context(
p_page_id => :APP_PAGE_ID,
p_outer_sql => 'select json_arrayagg( to_number(VCHSTATEREPORTNUMBER) returning clob ) as json_array from #APEX$SOURCE_DATA#',
p_region_id => l_region_id );
The above was used to extract a key field from the Faceted Search for use in a Mapbox/Maplibre filter. When attempting this same approach with Smart Filters, it fails. I would assume that two components are built similarly and both make use of the #APEX$SOURCE_DATA# in similar fashion. If this is not the case, guidance would be appreciated.