How to create a filter with JQL with roll-up date?

[Tiziano Viglongo]

I use the "Advanced Roadmap" (we set roll-up date in the settings of our plan) and I have tried to create a filter for Initiative, Epic and task that enable me to extract all items that haven't the "End date" set. There is no problem for Task because all persons that create a task have to insert it in the field "End date" but the problem is when I try to check Epic and Initiative that have only "roll-up date" so when I run the query all Epic and Initiative will appear. I can't find the field for "roll-up date".

This is the query that I create: ""End date[Date]" is EMPTY AND project ="MyProject"

Can someone help me?

Tiziano Viglongo

P.S. sorry for my English but I'm Italian. 

[Walter Buggenhout · Accepted solution]

Hi @Tiziano Viglongo,

when you choose to roll up the date in advanced roadmaps, it is not set on the parent issues. It is calculated and displayed in the plan in italics. Also, the roadmap bars in your plan will be displayed using colour shadings, like this (the top item is rolled up, all other dates are set , manually):

The field that you are looking for to filter on, is the one you see in your plan. In my screen, it would be the due date. You should check what it is in your plan, but it is the same as the one you use on tasks.

If end date is the field you use, then there does not seem to be anything wrong with your query. But it is quite common that your initiatives are stored in a different project than your epics and stories. So make sure you're searching in the correct project as well.

Hope this helps! 

[Tiziano Viglongo]

Hi @Walter Buggenhout ,

I can only access to one Project so is not possible that epics and initiative are in a different Project.

If I Share the project via "CSV" I can find this:

This is my screenshot (which is very similar to what you put in the answer, but in csv file you can see that for Initiative and Epic the "Star date" and "End date" are empty but the value is in the column "Star date (roll-up)" and "End date (roll-up)") 

If I run the query "End date[Date]" is EMPTY AND project ="MyProject" these are part of results:

As you can see "End date" is Empty. I think that Jira save, I don't know where, the "End date (roll-up)" somewhere else. 

I have tried to search some variable through JQL but I couldn't find anything.

Can you or someone else help in order to solve my problem?

Thanks

[Walter Buggenhout]

Hi @Tiziano Viglongo,

Jira does not save the roll up date (in the database). It is calculated and if you export your data to csv, you are getting them out of Jira. The API seems to be intelligent enough to export the rolled up date as well to present you with a consistent export, but I can assure you that this data is not in a hidden field somewhere. It really is just calculated information. 

As per your comment:

If I export the plan in "csv" format, I see that the Initiative and Epic dates are present in the "Start date ( roll-up)" and "End date ( roll-up)" column
Trying to write a query (JQL) that extracts all the activities present in the plan with start date and/or end date not valued. But I can't find the roll-up field in JQL.

Sharing your csv file helped me understand where you get the idea from, but the logic to export the rolled up value is in the export process. There is no roll-up field in Jira nor in JQL.

[Tiziano Viglongo]

@Walter Buggenhout 

Thank you very much!