Skip to Content
0
Dec 17, 2020 at 03:30 AM

Search Restriction not appearing on backoffice

59 Views

I've added the following restriction on stocklevels, but it is not applying on stock levels

INSERT_UPDATE SearchRestriction;code[unique=true];name[lang=en];query;principal(UID);restrictedType(code);active[default=true];generate[default=true]

;InventoryVisibilityDealer;;{item:warehouse} in ({{ select {s:pk} from {StockLevel as s JOIN Warehouse as w on {s:warehouse}={w:PK}} where {w:code}='dealer-A}});dealer-AStockLevel;;

I have made the employee and warehouse name as same to help in the query, but am seeing all the stocklevels even after this restriction.