How to use WMS API with multiple filters for an or operation
I need to pull inventory_history via the API where the history_activity_ID in 1,2,3,4,11,13,17,19,27,51,87 and status_id=90
or history_activity_id__in=10 and status_id=any ID
How would I go about the get string for this?
We currently have 3 Million records with status 90, but if I add all the statuses that number number would grow to 13.5 million rows so I only need id 10 and all statuses or status 90 for all other history activity ids
0