Is there a JQL command to locate a [URL Field]

dale.harris May 3, 2024

I have tried using text ~ "https://specific.url.com"
and it never finds anything.

4 answers

4 accepted

1 vote
Answer accepted
Camilo Galleguillos
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.
May 3, 2024

Hi, @dale.harris

For Jira search to be able to find the URL, you would need to use the exact phrase search operators "\" and \"" like the following example:

text ~ "\"https://specific.url.com\""

 

Best,
Camilo Galleguillos R. 

0 votes
Answer accepted
Zach May 4, 2024

Is it expected that the URL you are looking for is to be populated in the same field in every ticket?

If so you could figure out the JSON custom field id and create JQL based on that. Here is a link to the guide.

https://confluence.atlassian.com/automation/find-the-smart-value-for-a-field-993924665.html

0 votes
Answer accepted
Jehan Bhathena
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 4, 2024

Hi @dale.harris ,

What is the use case your trying to fulfill here?

Are you searching for the exact URL or maybe part of the URL in the ticket text or fields?

You can try the below to see if it works

text ~ "specific.url.com*"

The above Jal will search for any instances and the * is for any wild card after the string.

0 votes
Answer accepted
Ankit Srivastava
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.
May 3, 2024

Hi @dale.harris ,


Unfortunately, JQL itself doesn't have a direct way to search for custom fields based on their type (like URL) within Jira.

If your adding the URL in the summary/description of the project issue, then please follow the below JQL syntax:


project = "MyProject" AND (description ~ "https://specific.url.com" or summary ~  "https://specific.url.com")


 

or if you have any custom field like JiraURL field with URL field type, so JQL be like:


project = "MyProject" AND JiraURL is not EMPTY




Hope this will work.

Thanks,
Ankit Srivastava

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events