Limit Global Search retrieved records according to roles configuration : Portal

Start a new topic

Answered

Limit Global Search retrieved records according to roles configuration

Stephanie Fourrier

started a topic almost 2 years ago

How to limit the Global Search for different roles? For e.g. if there is a role for Australia, the user should only be able to view Australian data in the Global Search. It seems to be working for all the Business views except Global Search.

Best Answer

Stephanie Fourrier said almost 2 years ago

thanks for your question! You can use the sem_f_split function that allows using IN with the result of a split, like this :

FID_GeographyID in sem_f_split( case when :V_USER_ROLE like '%AP_dEM1_XDM_SEASK_DS%' then 'PH,TH,VN,KR,MY,SG'  when <yourotheruser_rolesconditions> end, ',')

1 Comment

Stephanie Fourrier

said almost 2 years ago

Answer

thanks for your question! You can use the sem_f_split function that allows using IN with the result of a split, like this :

FID_GeographyID in sem_f_split( case when :V_USER_ROLE like '%AP_dEM1_XDM_SEASK_DS%' then 'PH,TH,VN,KR,MY,SG'  when <yourotheruser_rolesconditions> end, ',')