Creating Dashboard with below Condition

[Maktumhusain Taseeladar]

Could you please help me to create Dash board with below Condition and let me know the Gadget need to be used and Filters,

Showing

• Epics, BP, BPT, Interface with no Assignee
• Epics, BP, BPT, Interface with no Solution Verification Target Start/Target End
• BP’s with no linked issues
• Epic’s with no linked issues

[mauricio.groth · Accepted solution]

Hi @Maktumhusain Taseeladar 

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

About your two firsts questions, you can use these queries:

• Epics, BP, BPT, Interface with no Assignee

assignee is empty and issuetype in (Epic, BP, BPT)

• Epics, BP, BPT, Interface with no Solution Verification Target Start/Target End

issuetype in (Epic, BP, BPT) and “Solution Verification Target Start/Target End” is empty

Unfortunately, your other two questions are impossible using only Jira JQL. You can check a few apps in the marketplace that extend the search for you by clicking here.

In the app where my team works, JQL Search Extensions for Jira, you can use these queries to solve your requests:

• BP’s with no linked issues

issuetype = BP and linksCount = 0

• Epic’s with no linked issues

issuetype = Epic and linksCount = 0

Please contact our support if you have any other questions about these queries. 

We’ll be happy to help you!
Best regards,
Maurício

[Maktumhusain Taseeladar]

@mauricio.groth  Thank you

[Nic Brough -Adaptavist-]

You've almost written the queries you need yourself - see https://support.atlassian.com/jira-service-management-cloud/docs/use-advanced-search-with-jira-query-language-jql/ 

Your first two are simple "issue type in (x, y, z) and not <something else", the third probably needs a function like "linkedissues" and the last one just needs to look at "epic link" or "parent" (depending on exactly what version you are using)

I can't suggest what gadgets to use - you've not told us what you want on the dashboard.