How to get issues connected to particular custom field

[aravind1516]

Hello I am trying to get the issues connected to a custom field via jql but it is not showing up. Is there any alternative approach for this? Please do let me know.

[mauricio.groth]

Hi @aravind1516 

As you're on Jira Server, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all your  issues with the description field matching the regular expression find issues mat.

issue in fieldMatch("project = SEARCH", "description", "find issues mat*")

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

[Manish Ranjan]

@aravind1516 Project = "Test-Project" AND Issuetype = "Bug" AND cf(customfieldID) = 18.

you can get custom field from system administration page.

[aravind1516]

Hi @Manish Ranjan ,that 18 is not the value of custom field it's the count of the issue's connected to the custom field.

[Manish Ranjan]

 execute jql query where the custom field is not empty.

[Brant Schroeder]

@aravind1516 Welcome to the Atlassian community

JQL is used to search issues and fields in Jira.  If you created a custom field you will need to add it to an issue's screens so information can be added to the custom field.  (this will take you through the steps https://confluence.atlassian.com/adminjiraserver/adding-custom-fields-1047552713.html ) Once information has been collected in that field you can then query off of it using JQL.     If you are not getting any results it is most likely because there is no data in the field.  

[aravind1516]

Hello @Brant Schroeder , Thanks for your response, We have created a field added it to the appropriate screen and values are also set to the field. For now the field is saying that it has 18 issue's connected to it. But I could not get the list of issues in issue navigator. Correct me if I am wrong in any these steps.

[Brant Schroeder]

@aravind1516 18 issue connected does not mean that the issue associated with the custom field has a value.  I would suggest doing a query where the custom field is not null.  This will allow you to see issues that actually have a value in that custom field.