Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Search for issue in another way

Is there a way to search for issues when we give the specific "serial number" which is put in the issue?

We created a new request type "serial number" and now we wanted to know if it´s possible how to find an issue by just giving the serial number. Might there be a setting somewhere that need to be set?



  • After it accepts the serial number, the field shows like this. (with dots, I did not put them)

Screenshot 2021-07-14 080646.png


  • So I tried to put both variants. First without dots

Screenshot 2021-07-14 080730.png


  • Second with dots

Screenshot 2021-07-14 080757.png

9 answers

I presume the field = Seriennummer is an open string field rather than a pre-populated drop-down menu - if so - try this:

Seriennummer ~ "123.456.789"

If the field = Seriennummer is a pre-populated drop-down list - you will need to use slightly different syntax - try this:

Seriennummer = 123.456.789

I hope this helps. 

If this is a Text field try using ~ operator to compare this with part values.

Hi @Sinemnur Dasdemir ,

You should type in the search string and hit enter. then you will see the search results. Jira does not show a preview on searches on text fields (afaik).


I hit the enter button and there still were no results :)

What type of field is serial number? Single line text? 

No, it´s a number field

Screenshot 2021-07-16 082420.png

Strange, when I search I get:


And when I hit enter it gives me the search result:image.png

thank you I will check it :)

is it also a number field or a text field?

It's a single line text field

With regards to the comment @Tanya C added, this was the setting I used.


@Rudy Holtkamp 

Based on the screen snap above your JQL Search in Jira should be:

"serial number (tf)" ~ 123.456.789

Hi @Sinemnur Dasdemir , can you please give us more details on this? 

Did you create a new custom field called "serial number" or did you create a new issueType called "serial number"?




We created a new custom field called "serial number". It´s not an issue type.

fine, then you need to search something like this in advanced search ( JQL )

"serial number" = "12345789"

Hi Sinemnur,

I would think you should at least add the name of the customfield you would like to search the number in. Something like

Seriennummer = 123456789

My older version of Jira was having problems trying to search without the customfield name and when adding the thousand separator ("not a valid number") on a number customfield.

Hope that helps.


If 'seriennummer' is an open-string field, use this query:

seriennummer ~ 123.456.789

If the serial number has spaces, you will need to use speech marks i.e.:

seriennummer  ~ "123 456 789".

If the field is not an open string and it is a drop-down pre-populated menu, use this query:

seriennummer ~ 123.456.789

again, if there are spaces, use the quotation marks.

n.b. an additional hint at no extra cost to you (xD). To get to the JQL screen from any other screen in JIRA, use the shortcut: 'g', 'i'.

I hope this helps.

Hi there,


just try to use the advanced search as mentioned in your Screenshot. I have marked it for you with a green circle ...



After that you should see something like the advanced search in Jira where you are able to easily create your JQL. 

Choose your field Seriennummer = "123.456.789" or Seriennummer ~ "123.456.789" and you should succeed.

Kindest regards

Try - "serial number" ~ "123.456.789"

 Go to the custom fields screen in admin and check the searcher select list.  Change it to exact search, or natural.... I can't recall the choices from memory. 

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you