Need to see orders specific to one site as Backoffice user.

[krishna2021]

Hi All,

I have a requirement to see orders specific to one site in backoffice for a particular user. I am running multiple sites on a single hybris instance.

Now I would like to restrict orders specific to one site for a particular user. I have used the below search restriction Impex, but its not working for me :

$languages = en
INSERT_UPDATE Usergroup;uid[unique=true];groups(uid);locname[lang=en];
;siteXemployeegroup;employeegroup; X  Employee Group;
;siteYemployeegroup;employeegroup; Y Employee Group;

INSERT_UPDATE SearchRestriction;code[unique=true];name[lang=en];query;principal(UID);restrictedType(code);active;generate
;orderVisibilitySiteX;;{item:store} IN ({{SELECT {bs.pk} FROM {BaseStore as bs} WHERE {bs.uid} = 'storeXuid'}});siteXemployeegroup;Order;true;true
;orderVisibilitySiteY;;{item:store} IN ({{SELECT {bs.pk} FROM {BaseStore as bs} WHERE {bs.uid} = 'storeYuid'}});siteYemployeegroup;Order;true;true