on 2024 Aug 14 8:11 PM
Hello,
I need to count the number of items in a warehouse. I already have the query to retrieve the items, but I'm not sure how to use $count to perform the count
URL :
https://<my sever>:50000/b1s/v1/$crossjoin(Items,Items/ItemWarehouseInfoCollection)?$expand=Items($select=ItemCode,ItemName)&$filter=Items/ItemCode eq Items/ItemWarehouseInfoCollection/ItemCode and Items/ItemWarehouseInfoCollection/WarehouseCode eq '1'
Thanks!.
Request clarification before answering.
| User | Count |
|---|---|
| 40 | |
| 21 | |
| 15 | |
| 6 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.