[Feature] Filter based on parameter value

inventree / InvenTree

Open Source Inventory Management System

https://docs.inventree.org

MIT License

4.12k stars 735 forks source link

[Feature] Filter based on parameter value #4851

Open SchrodingersGat opened 1 year ago

SchrodingersGat commented 1 year ago

After https://github.com/inventree/InvenTree/pull/4823 is completed, add ability to define custom filters for the 'parametric part table' based on parameter value

e.g.

?param_3_gt=9000 : Find parts with length > 9,000mm
?param_4=0402 : Find components with package 0402

Support operators like:

-eq (equality)

lt (less than)
gt (greater than)

Would have to use some complex queryset annoations on the server (much like in https://github.com/inventree/InvenTree/pull/4823) to make this performant

Upvote & Fund

We're using Polar.sh so you can upvote and help fund this issue.
We receive the funding once the issue is completed & confirmed by you.
Thank you in advance for helping prioritize & fund our backlog.

agooddaytowork commented 1 year ago

Hi @SchrodingersGat Have you been working on this? I really need this feature to be implemented.

In case you have not worked on this feature, I would like to implement this my self locally first. Could you drop more guidelines on where I should start?

SchrodingersGat commented 1 year ago

@agooddaytowork no work on this to date, so if you want to take it on, that's great!

References

As a starting point, look at these recent PRs which have added parameter filtering, and parameter units:

Currently we support:

Sorting parts by specific parameter value
Filtering parts which have a particular parameter value associated

also check out the filter_parametric_data function which was implemented in the PRs above:

https://github.com/inventree/InvenTree/blob/20b59c35752fdcae25578ab5399efaa96080f27f/InvenTree/part/api.py#L1217

Let me know if you need any other pointers! Be very keen to see this feature get off the ground.

github-actions[bot] commented 1 year ago

This issue seems stale. Please react to show this is still important.

SchrodingersGat commented 1 year ago

Not stale. @agooddaytowork did you ever get anywhere with this? Would be keen to see this working :)

agooddaytowork commented 1 year ago

@SchrodingersGat

I made some updates but not going anywhere near what I want. I'm snuggling to get used to the UI part. you could take a look at this PR. https://github.com/agooddaytowork/InvenTree/pull/1/files

SchrodingersGat commented 11 months ago

@agooddaytowork given the user interface changes requied to get this to work, I think we should park it until the react user interface is further along...

matmair commented 11 months ago

@agooddaytowork the API work looks intresting. Do you mind opening a PR against (this) upstream repo so we can discuss and maybe build a UI around it?

github-actions[bot] commented 9 months ago

This issue seems stale. Please react to show this is still important.

SchrodingersGat commented 9 months ago

Not stale. @agooddaytowork any updates on this from your end?

matmair commented 7 months ago

@agooddaytowork any status on this on the backend? We could probably integrate it easily into the new frontend.

github-actions[bot] commented 4 months ago

This issue seems stale. Please react to show this is still important.

SchrodingersGat commented 4 months ago

Not stale. Adding to horizon milestone