Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL

Marquis Stevens September 1, 2021

When creating a JQL utilizing the "Project Name" field, can we on do fuzzy searches for this field or is there a way to have it search for an exact match?

The issue that I am running into is that two of my project names have similar titles so when I want to search for one project name, my query pulls in the results of the similar name as well.   

2 answers

1 vote
Jack Brickey
Community Champion
September 1, 2021

I don’t understand how your JQL could pull in an unwanted or unspecified project. Could you share your JQL and explain further what is happening? Project it is rather specific in JQL, e.g. project = abc. JQL doesn’t support  ~ function.

Marquis Stevens September 1, 2021

project = PRILOG AND status not in (Done, Resolved, Rejected) AND "RICD Type" = Issue AND Component = component_name_example AND "Project Name" ~ "thinkpipes"

Marquis Stevens September 1, 2021
Jack Brickey
Community Champion
September 1, 2021

Ok so “project name” must be a custom field? If you are using the “~” operator then you will get approximate matches. Maybe you want…

project = PRILOG AND status not in (Done, Resolved, Rejected) AND "RICD Type" = Issue AND Component = component_name_example AND "Project Name" = "thinkpipes"

I guess my question is exactly what project name is used for and exactly what you are trying to query for here. 

0 votes
Alexander Bondarev
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.
September 1, 2021

Hi, @Marquis Stevens ! 
Welcome to the Community! 
I strongly agree with @Jack Brickey , it seems to me that you have custom text-field with name “Project Name”(not system field “project”).

Alexander Bondarev
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.
September 1, 2021

Look at the documentation - Search syntax for text fields 

There you can find relevant search examples.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events