Data Filtration working on sc_task and sc_req_item lists but same records show in reports

Wm Hadley
Giga Expert

I've been struggling with this one and trying to find out what's happening where.

 

I have two (2) data filtration records, which are working as expected when viewing the table list for the respective tables (sc_task & sc_req_item); however, report lists on the same tables (sc_task for the rest of the examples) are showing the records that are not visible when in table list view.

 

I've traditionally worked with business rules and ACLs. I understand the Data Filtration rules apply between before query business rules and ACLs (correct me if I'm wrong here please). So the records are being retrieved because there is no before query business rule to block them (major drain on system performance). The data filtration should then pick it up and prevent the records from showing before an ACL would kick in.

 

Unfortunately, the records are still showing in the report list. I have spent hours drilling down into logs. The best I was able to do was, in the sc_task report, it would block there referenced RITM number/link from displaying; however, it would still show other column data. I am logged in as a user with the roles expected to have the data filtered (no impersonation, no admin, etc.). I have attached screenshots showing the exact filter for the table view and report list showing two different row counts and the obfuscated RITM number/link. Also uploading a screenshot of the sc_task data filtration record for review.

 

I'm stumped as to what I'm missing that would be allowing the report to show the exact data that is filtered from the table list view and also the individual record if I link to it directly. Any nudge in the right direction would be much appreciated since this is related to lifecycle management and restricting access to highly sensitive records. Thank you!

1 REPLY 1

Wm Hadley
Giga Expert

I was able to uncover something else; it is only when the sc_task report columns drill down into the RITM variables to include variable data in the report view. Attaching screenshot to show report without any drill down into variables and the expected results.