JQL to list problem Issues created by Incidents

[Anas Gueroihi]

Hello,

I have created a transition post function for Incident Issue Type that creates a problem linked to the Incident. The problem is that I can't list the problems created by Incidents. I tried this JQL : 

project = "Project Name" AND issuetype = Problem AND issueFunction in hasLinkType("Relate to")

But it's showing all the problems that has links to other Issues. I want to list only the ones that were created by Incidents.

Do you have any idea on how to do it ?

Thanks

[Anas Gueroihi · Accepted solution]

issueFunction in linkedIssuesOf('issuetype=Incident') and issuetype=Problem

[iryna_k_SaaSJet_]

Hi @Anas Gueroihi ,

I want to advise you to try using the gadget Text to JQL. My team developed it. It converts queries from plain language to JQL queries.

Find out how this app works - Documentation.

It's free, and I hope you find it helpful.

[Anas Gueroihi]

Thank you @iryna_k_SaaSJet_  I'll give it a try.

[Leslie Coleman]

Based on your description above, the ISSUE TYPE = Incident (not Problem). 

Is "Problem" a custom field?  If so, you will need to know the custom field ID number.  (My workaround is to pull up a Jira issue that is using "Problem", then look up to the search window to see the custom field number.) 

Then, your JQL would be:

project = "XXXXX" AND issuetype = Incident and "[Custom field ID number]" = {which ever Problem you are interested in}

[Anas Gueroihi]

Actually problem is an Issue type, I finally found out how :

issueFunction in linkedIssuesOf('issuetype=Incident') and issuetype=Problem

But thanks anyway :)