Compare Epic Name to Summary

[Luc Cosatto]

I'd like to list all the epics where the value of the "epic name" property doesn't match to the value of the summary property

Unfortunalety all the queries I tested don't work or don't deliver the expected results

- project in (vtpl) and issuetype = epic and summary is not "epic name"

- project in (vtpl) and issuetype = epic and summary != "epic name"

What should I do?

Thanks for help!

[Rudy Holtkamp · Accepted solution]

@Luc Cosatto

Sorry to tell you, but that is not natively possible. You are now testing if the summary is not equal to the literal string 'epic name' and not the content of the Epic Name custom field.

Let me ask you a question: Let say that if you have constructed such a query, what will you do with the result?

If it is to copy the Epic name in the Epic summary field then you might better look in to some automation tools that set the Epic summary to the value of the Epic name after you've created the Epic. For this you could use Automation for Jira or Scriptrunner. 

Note it does not show if you use Cloud or Server. If you use Cloud Automation for Jira is already available (Project settings > Automation).

[Luc Cosatto]

Hi Rudy,

I'm not the JIRA-administrator but I suppose we use Cloud.

With my Query I'm trying to identify the Epics, for which "Epic Name" and "Summary" are not longer identical, in order to correct them (because it leads to incomprehension by most of the users).

Is there any function such as ValueOf ("Epic Name"), that I could use in my query?

[Rudy Holtkamp]

No, there isn't. What you could do is create an automation rule that will send an email whenever somebody creates an epic where the summary and epic name are different. If you want that I can show you how that is done. But that does not look for already created Epics.

[Luc Cosatto]

Hi Rudy, 

Yes, I'm interested, but I don't know if I have enough permission (I never create an automation)

[Rudy Holtkamp]

First of all you need project admin rights. The you go to Project settings > Automation > Create rule

1. Select the rule trigger: Issue created
2. Add branch rule /  related issue component
3. In type of related issue choose 'JQL'
   JQL: project = VTPL and issuetype = Epic
4. Add New conditoin component > Advanced compare condition
5.  First value: {{issue.summary}}
   Condition: does not equal
   Second value: {{issue.Epic Name}}
6. Add New Action > Send email
7. To: <your email>
   Subject: Epic name is not equal to Epic summary
   Content: 

   Hi Luc,

   The epic name and summary of this Epic are not identical:

   <a href="{{issue.url}}">{{issue.key}} - {{issue.summary}} - {{issue.Epic Name}}</a>

   Your Robot

8. Publish rule and give it a descent name.

It should look something similar as below:

[Luc Cosatto]

Hi Rudy,

It seems that I haven't the needed permission.

I'll look ask my admistrator, if he could do something for me.

Thank you for your help!

Luc