[FR] Searching for PN with only alphanumeric characters

[LastEdit]

Please verify that this feature request has NOT been suggested before.

• [X] I checked and didn't find a similar feature request

Problem statement

Allow searching PNs (IPN,Mfg,Supplier) with only alphanumeric characters, ignoring things like - / \ _ " " , etc.

This would allow for a simpler user interface when typing in PNs that have those characters or when supplier/mfg PNs don't have consistent use of those symbols.

Suggested solution

Specifically for PNs, add additional db columns with stripped PNs and search against new columns. Have search remove characters before making query.

Describe alternatives you've considered

Search against the original database and automatically place regex between all characters in PN query so unknown to user. Such as [^a-zA-Z0-9_]*, but potential database performance hit.

Examples of other systems

No response

Do you want to develop this?

• [ ] I want to develop this.

[SchrodingersGat]

@LastEdit regex search is already an available option:

And there's a drop-down option in the new interface:

[LastEdit]

@SchrodingersGat Doesn't regex search require the user to input the expression manually into the search bar? I was looking for a more behind the scenes ability to ignore the specific characters during search.

[SchrodingersGat]

I do not want to make the regex search support any more complex than it already is - if you want to use regex, which is already supported, then go for it! But I think any further complications will make the experience more difficult for everyone.

[matmair]

I am with @SchrodingersGat on this one - making the regex search more complex ought to introduce bugs again. Additionally, regex opens up a whole class of security headaches against which the current implementation was tested but new stuff would have to be checked again.

[github-actions[bot]]

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