Introduction
According to the customer’s requirement, there is a table that contains both parent parts and child parts in one table. Once we create a part, a link must be available to create child parts under it. Once we click on that link, the parent part must be available in the breadcrumb along with the parent parts of the parent.
Steps to follow
Step 1:
Create a tabular form with source code as
SELECT NVL (VEHICLE_PART_ID, 0) “VEHICLE_PART_ID”,
“VEHICLE_PART_ID” VEHICLE_PART_ID_DISPLAY,
CATEGORY_ID “VEHICLE_TYPE_CODE”,
“VEHICLE_PART_NAME”,
IS_ACTIVE “ACTIVE_STATUS”,
NVL (PARENT_PART_ID, 0) AS “PARENT_PART_ID”,
CASE
WHEN VEHICLE_PART_ID IS NOT NULL
THEN
‘<a href=”’
|| ‘f?p=&APP_ID.:5:&SESSION.::&DEBUG.::P5_PARENT_PART_ID,P5_VEHICLE_TYPE,P5_PARENT_PART:’
|| VEHICLE_PART_ID
|| ‘,’
|| CATEGORY_ID
|| ‘,’
|| VEHICLE_PART_NAME
|| ””
|| ‘> Minor Parts</a>’
END
“link”
FROM AP_SY_VM_VHL_PRTS
WHERE CATEGORY_ID = :P5_VEHICLE_TYPE
AND ( (PARENT_PART_ID = :P5_PARENT_PART_ID
AND:P5_PARENT_PART_ID <> 0)
OR (:P5_PARENT_PART_ID = 0 AND PARENT_PART_ID = 0));
Step 2:
Go to Report Attributes à Link à Display As à Standard report Column
As per the query, it will redirect to the same page by setting the item value.
Step 3:
Create a Display item for displaying as breadcrumb with the following query
SELECT ‘<a href=”’
|| ‘f?p=&APP_ID.:5:&SESSION.::&DEBUG.::P5_PARENT_PART_ID,P5_VEHICLE_TYPE:’
|| ‘0,’
|| :P5_VEHICLE_TYPE
|| ””
|| ‘>’
|| AP_SY_VM_FN_GET_CTGRY (:P5_VEHICLE_TYPE)
|| ‘</a>’
|| ‘ -> ‘
|| LISTAGG (
‘<a href=”’
|| ‘f?p=&APP_ID.:5:&SESSION.::&DEBUG.::P5_PARENT_PART_ID,P5_VEHICLE_TYPE,P5_PARENT_PART:’
|| VEHICLE_PART_ID
|| ‘,’
|| CATEGORY_ID
|| ‘,’
|| VEHICLE_PART_NAME
|| ””
|| ‘>’
|| VEHICLE_PART_NAME
|| ‘</a>’,
‘ -> ‘
)
WITHIN GROUP (ORDER BY PARENT_PART_ID)
FROM AP_SY_VM_VHL_PRTS vp
START WITH VEHICLE_PART_ID = :P5_PARENT_PART_ID
CONNECT BY PRIOR PARENT_PART_ID = VEHICLE_PART_ID
ORDER BY LEVEL DESC
Step 4:
In the item, under Security select Escape Special Characters option as No.
Conclusion
Using above steps we can create breadcrumbs using item dynamically.
