Portal

Is it possible to manage visible/invisible value in List depend on user role??

It is possible to filter the content of lists (references) on a form by applying a filter to a entity for a role in the Model Privilege Grants, or to a business view, or to a picker filter in a stepper. 

I have created a role 'BusinessUser' .  

I have also created secondary roles for sales region users: NewEngland, MidAtlantic, Midwest, South,  and West  

Then I created users that have User Roles such as "BusinessUser, NewEngland, MidAtlantic" and "BusinessUser, Midwest, South"

Model Privilege Grants Method

When I add the following filter to Model Privilege Grants for the role BusinessUser on the "SalesAgent" entity, the system restricts Sales Agent Data visibility to only the regions in the BusineUser's entire User Role:

FID_SellsInRegion is null  OR SEM_INSTR(:V_USER_ROLES, SellsInRegion.NameOf) > 0  

Thus given a business user "Liam" whose roles are "BusinessUser, NewEngland, MidAtlantic"

* Liam can only see Sales Agents that sell into the New England and Mid Atlantic regions

* In any form Reference Control or Browsing list that displays Sales Agents, that control or list will be restricted to only those Sales Agents that sell into the New England and Mid Atlantic regions.

And given a business user "Noah" whose role is "BusinessUser, Midwest, South"

* Noah can only see Sales Agents that sell into the Midwest and South regions

* In any form Reference Control or Browsing list that displays Sales Agents, that control or list will be restricted to only those Sales Agents that sell into the  Midwest and South regions

Such a filter is universal across the application.  

Note that applying such a filter may restrict the user's ability to manage suggestions as I understand that visibility to an entity must be unrestricted to conduct those operations.

Business View Root Filter Method

You can modify a business view's  root filter to the following:

FID_SellsInRegion is null OR SEM_INSTR(:V_USER_ROLES, SellsInRegion.NameOf) > 0 OR SEM_INSTR(:V_USER_ROLES, 'semarchyAdmin') > 0

Picker Filter in a Stepper 

Find the stepper associated with the Reference picker that you want to limit.

In the steps section of that Stepper,  select the Form Step for the entity that is associated with the reference you want to filter.

Select the "Reference Selection"  finger tab in the properties section.   (If  the table is empty, click the refresh button at the upper right corner of this section.  The table will then populate with all the references for that entity.)

The Picker Filter for the reference is the cell to adjust

Click on the Picker Filter Editor for the reference to be restricted.

Modify the SemQL condition to:

SEM_INSTR(:V_USER_ROLES, Referenced.SellsInRegion.NameOf) > 0 OR SEM_INSTR(:V_USER_ROLES, 'semarchyAdmin') > 0

This will limit the picker (list on the form) to only those regions associated with a business user's User Roles.

Let me know if this does not appropriately address your question. 

Murakami Toshihiro