Mechanism to Globally Hide/Show Records

[hcallen]

Hello,

We have a requirement for globally hiding some locations on the cmn_location table, but still allow the ability to view all locations in-case some of the hidden records need to be updated to become visible by everyone at some point.

My solution currently is to add UI actions on the cmn_location table which toggles a "view all locations" user preference. Then have a before query business rule key off the "view all locations" user preference in-order to view/hide the location records.

I was curious if there's another (or better) approach for globally hiding certain records in a table, but also still allow some users to view/update all records when needed.

[Shivalika]

Hello @hcallen 

What you have done seems good for your requirement. There are actually several other options - ACL, reference qualifier, modifying the default filter in location table. 

But all this might need update with time, if your role or group changes - the people who need access. 

But if it's just a UI Action, you can easily control that. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[hcallen]

Is it possible to create a default filter for a table that's applied to every view of that table regardless of which module the table was viewed from?

[Shivalika]

Hello @hcallen 

You will need to create default filter for all the views also. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[Ankur Bawiskar]

@hcallen 

I believe your approach is a good workaround but did you test if it's working fine.

share some more details about that UI action and the preference you are playing with

If my response helped please mark it correct and close the thread so that it benefits future readers.