how to filter value in "links"

[David Frinta]

hello,

how do i filter all entities in link with certain format like DEV(that is same for all appearances) and then some numbers

so for example i have in links for different bugs values like DEV-123, DEV-321

i need to filter just the bugs with this "DEV-xxx" value

thank you

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi David,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

1) Query for issues linked to any DEV ticket

issue IN linkedIssuesOf(' project = DEV ')

2) Query for issues DEV project having links

project = DEV AND issues IN haslinks()

3) Query for issues on DEV project linked to a subset of issues provided by another JQL

project = DEV AND issue IN linkedIssuesOf(' project = ANOTHER and status = Done ')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

[David Frinta]

thank you very much 

[Danyal Iqbal]

as far as i know, you cannot do that with the standatd jql functions. check out the scriptrunner JQL functions for this function

https://scriptrunner.adaptavist.com/4.3.1/jira/jql-functions.html

[David Frinta]

thank you