Search for issue in another way

[Deleted user]

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)

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

• Second with dots

[Tanya C]

 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. 

[Kyle Cooke]

Try - "serial number" ~ "123.456.789"

[Patrick Heidel]

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
Patrick

[Hurcus Ibrahim]

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.

[Manuel Bähnisch]

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.

Manuel

[Arthur Harutyunyan]

Hi @[deleted] , 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"?

Thanks, 

Arthur 

[Deleted user]

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

[Arthur Harutyunyan]

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

"serial number" = "12345789"

[Rudy Holtkamp]

Hi @[deleted] ,

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).

Rudy

[Deleted user]

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

[Rudy Holtkamp]

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

[Deleted user]

No, it´s a number field

[Rudy Holtkamp]

Strange, when I search I get:

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

[Deleted user]

thank you I will check it :)

[Deleted user]

is it also a number field or a text field?

[Rudy Holtkamp]

It's a single line text field

[Rudy Holtkamp]

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

[Tanya C]

@Rudy Holtkamp 

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

"serial number (tf)" ~ 123.456.789

[Vishal Biyani]

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

[Hurcus Ibrahim]

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.