Faceted Search – Shopping Cart Example

APEX 19.2 – Faceted Search

– Is a important key feature in Oracle Apex 19.2 version, we can find the faceted region in a page or we can directly create a faceted page.

– Create a faceted search page and search items.

– Modify the Classic Report Template, to show the search results in different UI format.

– Choose the Card template and modify the query columns.

“SELECT
prd_id,
prd_code,
prd_name,
prd_name card_subtitle,
prd_description card_text,
prd_status,
‘<i class=”fa fa-edit”></i>’ as edit_icon,
(case when length(APEX_UTIL.GET_BLOB_FILE_SRC(‘P3_PRD_LOGO’, prd_id)) > 0
then ‘<img src=”‘||APEX_UTIL.GET_BLOB_FILE_SRC(‘P3_PRD_LOGO’, prd_id)||'” width=”100%”></img>’
else ‘<img src=”#APP_IMAGES#coconut_oil.jpg” width=”100%”></img>’
end) card_title,
‘<span style=”background-color:#f44336; color:white; width:100%;” class=”t-Button t-Button–small t-Button–noLabel t-Button–icon add-favorite trans_status”>
<i class=”fa fa-plus” aria-hidden=”true”></i> Add Cart</span>’ as card_subtext
FROM
xx_prd_product_master_t” 

– End result will be like Shopping Cart website.

Demo URL : https://apex.oracle.com/pls/apex/f?p=31102:3:14824537420994::NO:::