I have problems with filters

[Aleksandra]

I have problem with the most basic filter (in my opinion).
I need to be able to select all the issues from the project and then - from the respectful epic.

I used query:

project = "CRM" AND "Epic Name" = "Questionnaire management" ORDER BY created DESC

and got 0 results, what should I do?

[Nic Brough -Adaptavist-]

There is a slightly odd way the Epics have been implemented here (it's a historical quirk from when Epics were first added to Jira, one Atlassian never refactored out)

• Epic Name is a field that names an Epic
• Epic Link is a field that links an issue to an Epic
• They are intertwined, so they provide the issue/Epic linking!

So, your query is actually looking for the Epic's name, on issues.  Which isn't there!

Try:

project = "CRM" AND "Epic Link" != "Questionnaire management" ORDER BY created DESC

[Aleksandra]

Unfortunately, it didnt work:

When I try replace the name with the Epic number which is CRM-1324, I get more issues from different epics :/

[Nic Brough -Adaptavist-]

Sorry, I've just realised there was a typo in there!  Remove the exclamation mark from the != - it is inverting the question to "show me all issues with epic links except the one I want"

[Aleksandra]

Yeah, I noticed that as well but still after removing the ! it is not working:

[Nic Brough -Adaptavist-]

What do you get from 

"Epic Name" = "Questionnaire management"

(Yes, ignore the project)

[Aleksandra]

there you go:



This is strange, when I go directly into this Epic, all the issues are linked, but of course, I can't get any statistics (how much of SP are for all the Stories, etc).

[Nic Brough -Adaptavist-]

So that query does not find any issues ?

[Aleksandra]

No, not even a one :/

[Nic Brough -Adaptavist-]

Ok, that's the problem - you don't have an Epic with the name "Questionnaire management", so there's no link to find when you're searching Epic link.

[Aleksandra]

If this would be so easy, I think I wouldn't be creating a ticket here. CRM-1324 is definitely an epic and below you will find a screenshot. I believe this is Jira bug, not mine. 

[Nic Brough -Adaptavist-]

But when you search for that Epic name, nothing appears (for Epic name or in Epic links) because you don't have an Epic with that name.

Your screenshot is of the Epic's summary, not its name, could you check the fields in the right hand bar for the actual name of the Epic?

[Aleksandra]

[Nic Brough -Adaptavist-]

So we need to look at why your search for "epic name =" does not find this Epic.

[Aleksandra]

Shall I create a ticket to support?

[Aleksandra]

Hi, can you please let me know? 
I am not sure how to follow now :(

[Nic Brough -Adaptavist-]

Yes, you probably should raise an issue with Atlassian.   It sounds like your index is broken when "epic name =" won't find an Epic that has the name.

[Kristján Geir Mathiesen]

@Aleksandra 

This link here.

Hope you get a resolution fast,

KGM

[Kristján Geir Mathiesen]

Hi @Aleksandra 

Have you tried:

project = "CRM" AND "Epic Name" != "Questionnaire management" ORDER BY created DESC

Also, are you sure you have the right project?

HTH,
KGM

[Aleksandra]

Yup, this is the right Epic, see the screenshot below:

 

unfortunately, this also didn't work (the one that you indicated) - this gave me back all the epics in the project.

[Kristján Geir Mathiesen]

Sorry to hear that. Is the value in the field "Epic Name" also Questionnaire management?

KGM

[Kristján Geir Mathiesen]

@Aleksandra  can you show us more details of this CRM-1324 issue?

Like how its fields are populates?

Thanks,
KGM

[Aleksandra]

Hi Kristjan,

I will gladly do it, but can you navigate me?
I wasn't setting ups this Jira so I need a more guidance :)

[Kristján Geir Mathiesen]

Hi @Aleksandra 

I mean a screen shot of this particular issue. So we can see the fields and their values.

Thanks,
KGM

[Aleksandra]

Sorry, I got ya.
See below:

[Aleksandra]

Hi, do you have any update for me?
It looks like one of the most basic queries and it is not working, so I have to do my calculations half manually, which is crazy time consuming :(

[Kristján Geir Mathiesen]

Hi @Aleksandra 

I´ve been following the discussion between you and @Nic Brough -Adaptavist-  and I am a bit baffled, to be honest.

We've established that CRM-1324 truly does have a field called "Epic Name" that has the value "Questionnaire management"

Is CRM-1324 an Issue Type "Epic"?

I wonder if this is an index error. Maybe you should create a support ticket and ask for a reindex on the project...  Sorry :/

KGM

[Aleksandra]

Yup, it is an epic, see, when I hoover, I see the name, for some reason it is not shown on the table in the right.



Can you please send me instruction how to create a jira support ticket? 
BR,
Ola

[Kristján Geir Mathiesen]

Hi @Aleksandra 

This link here.

Hope you get a resolution fast,

KGM

[Nic Brough -Adaptavist-]

I've just noticed - the issue you are showing us that has "Epic Name" on it does not have "Epic Status" beneath it.   I'm not sure it is a true Epic type. 

You could have an issue type called "Epic" that is not actually an Epic, and have added a field called "Epic Name" to it.