JQL to search multiple values in part number field

[Mike Banes]

I'd like to better understand how to search multiple values in the part number field.  If I were to search for part number 1234 AND 4567 in the part number field, I would need the result to list records with either part number in the field.

The next question will be how to perform the same search with a wildcard; i.e. 123* or 456*

[Bhushan Nagaraj]

Hi Mike,

The number field only supports =, >, <, >= and <= operators. It does not support wildcard searches.

For your use case, you might want to consider using a text field custom field that supports wildcard searches.

Thank you

Bhushan

[Mike Banes]

Here is my solution.

AND ("Part Number" ~ "1500-3650*" OR "Part Number" ~ "1500-3700*")

Seems to have worked so far.

[Bhushan Nagaraj]

Glad you got it working. In that case, the Part Number field must be a Single Line Text custom field type and not a Number custom field type. Can you please take a look and confirm?