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.