Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

End-User facing expression builder in APEX?

AllenS.Sep 13 2022 — edited Sep 13 2022

Hi,
I've built a sort of Document confirmation page for employees. The document contains clauses specific to an employee. The document will be defined by admins as well as clauses which are mainly the content of a document. Kind of like a contract.
Each clause are employee specific. Meaning a certain clause will be available to some employees only. So some employees will have certain clauses in the document they received/see via page while others do not.
I'm having some difficulty on this part as I am not yet sure what's the best way to do this. Currently I am using an Interactive Report (using employees table) where I hide everything except the Filter menu then let the admins set all the filters there for each clause record. I then get the SQL of the said Interactive Report and parse the where clause of the SQL statement. Then I can just fetch this where clause and concatenate it as needed. One issue I have here is where the user wants to edit the current filters which I will need to programmatically add filters to the IR. Not sure how to do that yet.
Another approach would be to manually create fields (select list, checkboxes etc) for each of the columns required for the filter but that would be my last resort.
I would like to know if there's a better approach to this?
Were on APEX 18.2.
Appreciate any feedback.

Comments

Post Details

Added on Sep 13 2022
2 comments
297 views