7 Replies Latest reply: Feb 17, 2015 3:31 AM by Jarno Loubser RSS

    Section Access: Combining Field Reduction and OMIT

    Jarno Loubser

      I already know that what I want to achieve is not possible using Section Access, but describing the issue with reference to section access seams easiest.

       

       

      Data Source: HR

      Section Access Field Reduction: EmployeeID

      Section Access OMIT Field: SalaryAmount

       

      I need to cater for the following scenarios:

      1. UserA logs in a sees Employee1, Employee2 and Employee3. He also sees SalaryAmount for all three employees; - No Problem here
      2. UserB logs in a sees Employee1 and Employee3. He also sees SalaryAmount for Employee1 and Employee3; - No Problem here
      3. UserC logs in a sees Employee1 and Employee3. He does not see SalaryAmount for Employee1 and Employee3; - No Problem here
      4. UserD logs in a sees Employee1, Employee2 and Employee3. He also sees SalaryAmount for ONLY Employee1 and Employee3; - Problem

       

      As I said – I am aware that OMIT will hide the field (or not) for the user on all records or none.

       

      The question: can anyone think of a way to achieve the goal keeping the following in mind:

      1. The Salary Table can have many millions records;
      2. The field need to be hidden ‘n such a way that a self-service user must not be able to get to the values;