Restricting Products visibility in Product cockpit based on Category

280 Views

Hi Experts,

I have to create usergroup based on Category. e.g For Cisco category I have to create ciscoemployeegroup and if user belongs to ciscoemployeegroup, logs into product cockpit then that user should only see products from CIsco category in product cockpit. for that i Have created Search Restriction. like below.

INSERT_UPDATE SearchRestriction;code[unique=true];name[lang=en];query;principal(UID);restrictedType(code);active;generate
;b2buserciscogroup_restriction;Restrict CISCO UserGroup visibility;{catalogVersion} IN ( ?session.catalogversions ) OR EXISTS ({{SELECT {pk} FROM {Category AS cat JOIN CategoryProductRelation AS c2p ON {cat:pk}={c2p:source} } WHERE {c2p:target}={item:pk} AND {cat:code}='Cisco' AND {cat:catalogVersion} NOT IN({{SELECT {pk} FROM { ClassificationSystemVersion} }})}});ciscoemployeegroup;Product;true;true

Now problem is when user (belongs to ciscoemployeegroup) logs in hmc, he able to see products from Cisco Category only which is right behavior but when user logs in Product cockpit, all categories products are visible to user.

Expected behavior : The user should see products from Cisco categories in Product Cockpit as hmc behavior.
Actual behavior : All categories products are visible to user when he logs into product cockpit.

Let us know whats the root cause behind this.

Many Thanks in Advance,