Example: Section Access w/ Data Reduction and OMIT linked to Show/Hide Conditions

Michael_Reese — Thu, 04 Aug 2022 10:23:08 GMT

Here are some example show conditions. The second is if you have multiple different groups that shouldn’t have access to a given field.

=if(OMITGROUP=’SALARY’,0,-1)

=if(match(OMITGROUP,’SALARY’,’CONTACTINFO’,’ACCOUNTING’)>0, 0, 1)

Re: Example: Section Access w/ Data Reduction and OMIT linked to Show/Hide Conditions

sjar1290 — Mon, 29 Aug 2022 00:25:08 GMT

HI Michael,

I have a requirement to implement column level security, I need your help

for instance I have 6 columns in the report

If you Login as Michael, you will have all the access to all the data

Id	Name	Product	Sales	Profit	Region
1	abc	xyz	100	20	US East
2	dfr	123	200	30	US West

If I login as Raj,

it should not change the structure of the Table. we should show the metadata (the column names)

the table structure should be same and I should not able to see the Sales and Profit values and instead of blank space I need to show "No access" message

Id	Name	Product	Sales	Profit	Region
1	abc	xyz	No Access	No Access	US East
2	dfr	123	No Access	No Access	US West

any insight would be appreciated.

Thank you,

Raj.

article Example: Section Access w/ Data Reduction and OMIT linked to Show/Hide Conditions in Member Articles

Example: Section Access w/ Data Reduction and OMIT linked to Show/Hide Conditions

Re: Example: Section Access w/ Data Reduction and OMIT linked to Show/Hide Conditions