Jira integration - Using filters to find issues with no linked Zendesk tickets

1 Comments

  • David Gillespie
    Comment actions Permalink

    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

     

    0

Please sign in to leave a comment.

Powered by Zendesk