I have a classic report displaying all the records from folders table.
For a child folder, I would like to display all the records, but the EDIT should be displayed only for those parent folders. In folders table, I have the column PARENT which has the parent folder id.
To solve this :
1. I added a condition to Link Column as Value of Item / Column in Expression 1 = Expression 2 as Expression1=#PARENT# & Expression2= : P3_ID_FOLDER
But this does not work. This is the first time I am taking this approach to display edit link based on a condition.
2. I put this in the query
SELECT
CASE WHEN dcd.DOS_NUMERO_DOSSIER = dcd.DOS_PARENT THEN
'<a href="' || APEX_UTIL.PREPARE_URL(
p_url => 'f?p=111:6:::NO::P6_ID_DOSSIER:'||N DOSSIER,
p_checksum_type => 'SESSION') || '">
<img src="#APP_IMAGES#gavel-16.png" class="apex-edit-pencil" alt="">
</a>'
ELSE ''
END
AS "EDIT_DEC"
But i still have the edit button in all records.
Can someone help? I don't know where I am going wrong.