Below Minimum Stock Level Filter

[partke...@gmail.com]

Hello All,

I created a python script that takes data from one schema/table (outside of PartKeepr) and changes stock levels on the Part and StockEntry tables. Everything seems to be working fine except the Stock Level < Minimum Stock Level filter.

Any pointers on how that filter works / why it does not show the stock levels altered by the above script I'd appreciate the consideration.

Thanks,

- Corey 

[Felicia Hummel]

> Any pointers on how that filter works / why it does not show the
> stock levels altered by the above script I'd appreciate the
> consideration.

It's because for simplifying queries, the filter checks the lowStock
column in the Parts table. Of course it would be possible for PartKeepr
to do a sum of all StockLevel entries for a certain part, but that is
not supported by the JSON-LD API right now and would probably slow down
the query a bit.

If you manipulate stock levels via the API, this is taken care of by
the system itself, but in your case you'd need to update the lowStock
flag yourself.

All the best
Felicia

[partke...@gmail.com]

"It's because for simplifying queries, the filter checks the lowStock
column in the Parts table."

That's what I was looking for! Thanks Felicia!