Start a new topic
Discussions xDM xDM - Model and Application Design
Answered

Limit Global Search retrieved records according to roles configuration

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

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



Login to post a comment
More topics in xDM - Model and Application Design
See all 275 topics
Help Desk Software by Freshdesk