Hello,
I reviewed this topic (https://support.zendesk.com/hc/en-us/articles/229729947-How-to-use-JIRA-Filters-to-see-Zendesk-Tickets-in-JIRA), but it doesn't show me how to do what I need. We intentionally link ONE Zendesk ticket to ONE Jira issue. I want to find Jira issues that have NO linked Zendesk tickets. The following query does not work for me:
project = "my project" AND issuetype = "enhancement" AND "Zendesk Ticket Count" = 0 ORDER BY updated DESC
Hi Jennifer,
Without having access to your specific Jira instance it might be a bit hard to de-bug your query. Might be helpful looking through the Jira JQL documentation, see link here: https://confluence.atlassian.com/jiracore/blog/2015/07/search-jira-like-a-boss-with-jql
What I might try is filtering by the label not being jira_escalated (labels =! "jira_escalated") or the Zendesk Ticket Count being greater than 1 or not equal to zero ( "Zendesk Ticket Count" > 1 or "Zendesk Ticket Count" =! 1). See queries below.
project = "my project" AND issuetype = "enhancement" AND labels =! "jira_escalated" updated DESC
or
project = "my project" AND issuetype = "enhancement" AND "Zendesk Ticket Count" > 1 ORDER BY updated DESC
or
project = "my project" AND issuetype = "enhancement" AND "Zendesk Ticket Count" =! 1 ORDER BY updated DESC
Thanks,
David
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.