Query for Related Tickets

Question

I am working on setting up a JSM project which will be used by internal agents in requesting help from seniors. In addition to the Confluence articles which are suggested as the agent is submitting the request, I would like the agent to be able to see related tickets.

Use case: if an agent submits a ticket about a feature being broken, this could automatically find any bug tickets that could be related, allowing the agent to be aware of bugs without relying on a senior to memorize all the bugs in the backlog.

I know there's the "similar tickets" on the senior's end, but we want the initial agent to be able to self-serve as much as possible. I'm assuming this could be possible through some kind of JQL query, but haven't been able to figure out how to do it.

I tried with the "Elements Overview" app from the Marketplace, but it's just listing every ticket, not anything targetted.

Kayde Adair · Answer

Hello Maelle! This would be great!

When I try to copy and paste the two options above, I get an error? I've included screenshots if I can please ask you to review and see if maybe I'm doing something wrong?

Maelle Cartron - Elements · Answer

Hi @Kayde Adair  !

Welcome on Community!

You can achieve this use with Elements Overview app by configuring it to display related tickets dynamically based on JQL. For your scenario, you can create an overview that shows unresolved bug tickets related to the agent's request.

Here’s a sample JQL query you could use:

jqlCopier le codeissuetype = Bug AND status != Done AND text ~ "{{issue.summary}}" OR text ~ "{{issue.description}}"

This query searches for unresolved bugs that match the text in the current request's summary or description. If you’re using linked issues, you could try:

jqlCopier le codeissueLinkType = "Relates" AND linkedIssues = {{issue.key}} AND issuetype = Bug AND status != Done

To set this up in Elements Overview go on configuration page and use the above JQL in the focus section to filter tickets. You can test the JQL and see if it's working as you want it.

Let me know if you need further help setting it up!

Best regards,

Maelle, Elements Overview Product Marketing Manager

Kayde Adair · Answer

Thank you so much! I appreciate your quick response and expertise.