Hi
How can we filter inventory items list by price...
# generalr
Rishikesh
08/20/2020, 1:00 PMHi
How can we filter inventory items list by price ,size and material ?
e
ericbirdsall
08/20/2020, 3:06 PMTo filter by price:
Create a saved search for Inventory items.
Add criteria of "Sales Price"
ericbirdsall
08/20/2020, 3:07 PMAssuming you have fields for size and material, you should be able to handle it similarly with your criteria being Size (or length, width, and height) or Material (not sure if this is a custom field or not)
r
Rishikesh
08/21/2020, 6:07 AMthanks but
when trying to filter inventory item by price
url = acc_id/record/v1/inventoryItem?q=price GREATER_OR_EQUAL 1000
response=
{
"type": "https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1",
"title": "Invalid search query Search error occurred: Field 'price' for record 'item' was not found..",
"status": 400,
"o:errorCode": "INVALID_PARAMETER"
}
and same happing when trying to filter with material and size
8 Views