07-15-2022 02:26 AM
Is there a way to apply security on the records inside a Register ?
For example I have 10 Entities and 10 Workflow Profiles with distributed registers built, Now inside the Registers there is a column for CostCenters. There are around 10-15 CC's. Users specific to CC should only see their records in Plan Register table. Is that possible ?
07-15-2022 02:39 AM
By default it does not exist. But the code for the Register like in the TCR solution are open and you can amend and change it to set this up.
07-15-2022 02:43 AM
Sorry Nicolas - wats the TCR solution like , is that a table you are referring to ?
07-15-2022 06:05 AM
TCR is the market place solution Reporting Compliance.
I think, we need some additional information.
If you only want to restrict the drop down list by user, than you can do it, depending how you set the drop down list up.
If the drop down list is not based on a Business Rule, you always can change it to do so.
Within a business rule, you find the active user in the si object: si.UserName
I hope this helps for the moment and cheers
07-15-2022 11:17 AM
If you are planning to restrict one user from seeing data from other cost center, then it is not possible unless you do these two things
1. Change Cost Center to Entity and use workflow and entity security
2. Change the WHERE clause of the SQL editor object to use the security applied to the cost center.
Not sure whether you are making use of "Display member." If not, you need to use that or create a custom table that holds the security. It is doable.
07-18-2022 03:53 AM
Thank you all, will try out the above options