JQL Question

[Chris Delgado]

How can I see all tasks within epics with a specific label?

Label = hi1 ----> shows me a list of epics and tasks with that label which is good, but there are tasks within some Epics that dont have this label and I need those to show as well.

I've been breaking my head for the past 30mins but no luck with Jira Cloud.

Thank you,

[Sam Nadarajan · Accepted solution]

Hello @Chris Delgado

You'll need to expand your query to include an OR clause so you can capture tasks without that specific label. What you have now:

Label = hi1

will of course only show you issues with that label.

If you want to include tasks within Epics that do not have that label, you could do something like:

Label = hi1 OR "Epic Link" in (<comma separated list of epics you want to look at)

If you need to include additional criteria within that Epic Link clause above don't forget your parantheses!

Hope this helps

[Chris Delgado]

Thank you much! i didnt know we could use csv in Jira.

[Chris Delgado]

Thank you

[Sam Nadarajan]

Hello Chris, I should clarify, when I mentioned "comma separated list of epics" I wasn't implying you could inject a CSV file into the query, just something like, "Epic1, Epic2, Epic3, EpicN"

If you are interested in general CSV importing that creates issues in Jira from rows in your CSV, you can take a look at the documentation here.

[Abhishek Pandey]

Can some 1 help me with below

Im trying to prepare a JQL that gives me list of tickets which is being not followed up for last 3 days and the query is (updatedDate < startOfDay(-3) ).

But this query also include the non working days (Saturday and Sunday).

Hence I need a query that eliminates the Weekend and consider only weekdays for output.

[Sam Nadarajan]

Hello @Abhishek Pandey , and welcome to the Community!

I think Phil's answer here will help you. There's a ton of stuff out here on the Community so don't hesitate to ask or search for an answer! 

Cheers,

[Abhishek Pandey]

Thanks alot manh, it helped.

Im Glad