jql searching for issue type properties

[Florian Bauer]

Hello Community,

I am looking for a JQL to get all issues with an issue type, which contains a certain issue-type-property.

Issue type properties can be set by rest api as described here.

Issue properties can be used within JQL and accessed like this: issue.property.property_name.

It looks like issue.type.property.property_name does not work.

is there a way to search for issue type properties?

Thanks,

Florian

[Rachit Singhal]

Hi @Florian Bauer ,

As per my understanding of Jira and it's JQL, it doesn't seem to be possible to fetch the value of issuetype property. You might work with issue property in JQL in the context of searching for issues having some specific property. You can validate this by looking at the columns of issue navigator.

You can use the below REST API to get the keys of all the issue type property

https://yourinstancename.atlassian.net/rest/api/3/issuetype/{issueTypeId}/properties (use GET)

Then after you can use the below REST API with your required issue type property

https://yourinstancename.atlassian.net/rest/api/3/issuetype/{issueTypeId}/properties/{propertyKey} (use GET)

Please let me know if you need any additional help. 

Thanks.

[Bill Sheboy]

Hi @Florian Bauer 

I do not believe that is possible.

JQL is for searching for issues, and so that is always the context.  Entity properties set on an issue can be searched using JQL.

But entity properties set on other objects would need to be accessed using the REST API, a marketplace addon, or an app you write create.

Kind regards,
Bill

[Florian Bauer]

as per documentation properties for issue, project and user (not issue type) can be jql-searchable but It turns out to be wrong: you only can search for issue properties.

Thank you for your help!

Florian

[Sanjog Sigdel]

Hello @Florian Bauer 

In typical JQL query we can use these two functions to retrieve hierarchy level issuetypes.

StandardIssueTypes() and SubtaskIssueTypes

JQL:  issuetype in standardIssueTypes()

JQL: issuetype in subTaskIssueTypes()

I don't have any hands on experience with the REST API but I would retrieve these two levels of issue types using above query.