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.

prd_name card_subtitle,
prd_description card_text,
‘<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

– End result will be like Shopping Cart website.

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




One thought on “Faceted Search – Shopping Cart Example

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s