JQL is not working for some records.

jitendra daswani January 30, 2014

Hi,

I ran the following Jql query:-

project = STK and issuetype="Internal Stakeholder" And "First Name"~"Atul" AND "Last Name"~"A"

I am not getting records which are starting from 'A', but the same query with different firstName and lastName, I m getting records.

I think there is bug in JIRA JQL for the records which starts from the "A".

Can anyone quickly help me to sort out this issue?

3 answers

1 accepted

0 votes
Answer accepted
jitendra daswani January 30, 2014

Thanks for information :)

0 votes
Udo Brand
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 30, 2014

According to Atlassian this is a wanted feature.

see: https://jira.atlassian.com/browse/JRA-36713

0 votes
Udo Brand
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 30, 2014

have you tried to use a wildcard?

"Last Name" ~"A*"

jitendra daswani January 30, 2014

Yes I tired, not working.

Last name was only "A", I changed the lastname with "B" and I m getting records.

There is some problem with character "A" only.

Udo Brand
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 30, 2014

hmm , "A" is not a reserved word. Can you try to use

"Last Name" ~"\"A\""

jitendra daswani January 30, 2014

I tried with both.

"Last Name" ~"A*"

"Last Name" ~"\"A\""

Unfortunately, Not working.

Suggest an answer

Log in or Sign up to answer