2020 Dec 17 3:30 AM - edited 2024 Feb 03 8:25 PM
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.
Request clarification before answering.
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.