Limit Global Search retrieved records according to roles configuration : Portal

Start a new topic

Answered

Limit Global Search retrieved records according to roles configuration

Stéphanie FOURRIER

started a topic over 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

Stéphanie FOURRIER said over 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

Stéphanie FOURRIER

said over 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, ',')