[FR] Filter based on parameter value

[SchrodingersGat]

After #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 #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]

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]

@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:

• Parameter filtering #4823
• Parameter types #4935
• Part units #4854

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:

InvenTree/InvenTree/part/api.py

Line 1217 in 20b59c3

def filter_parameteric_data(self, queryset):

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

[github-actions]

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

[SchrodingersGat]

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

[agooddaytowork]

@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]

@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]

@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]

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

[SchrodingersGat]

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

[matmair]

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

[github-actions]

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

[SchrodingersGat]

Not stale. Adding to horizon milestone