nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

return all tasks,story if its epic's TargetEndDate is between two dates

Shachi Prasad

So, I have a list of 25 epics. Out of these, I am trying to list all issue types (task, story, subtask) if the epic's TargetEndDate is between two dates say Feb 1 to April 30.

I have tried:

"Target End Date" >= 2023-11-01 AND "Target End Date" <= 2024-01-31 AND parent in (A-1234, A-5678, A-9129) ORDER BY status ASC

"Target End Date" >= 2023-11-01 AND "Target End Date" <= 2024-05-31 AND issueFunction in epicsOf("parent in (A-1234, A-5678, A-9129)") ORDER BY status ASC

Accepted answers

Laurie Sciutti

Hello @Shachi Prasad and welcome to the Community! If you use ScriptRunner, the following should work:

issueFunction in issuesInEpics("'Target End Date' >= 2023-11-01 AND 'Target End Date' <= 2024-01-31")

All comments

Laurie Sciutti

Hello @Shachi Prasad and welcome to the Community! If you use ScriptRunner, the following should work:

issueFunction in issuesInEpics("'Target End Date' >= 2023-11-01 AND 'Target End Date' <= 2024-01-31")

Shachi Prasad

this will search all the epics. I want the query to search only from the given list of epics

Shachi Prasad

If I add the list of epics, it doesnt return anything.

issueFunction in issuesInEpics("'Epic Link' in (A-1234, A-5678, A-9129) AND 'Target End Date' >= 2023-11-01 AND 'Target End Date' <= 2024-01-31")

Kalyan Sattaluri_iinm1n

@Shachi Prasad Are you in Cloud or data center?

If in DC:

issueFunction in issuesInEpics("'Epic Link' in (A-1234, A-5678, A-9129) AND 'Target End Date' >= 2023-11-01 AND 'Target End Date' <= 2024-01-31")

If in Cloud:

issueFunction in issuesInEpics("'Parent' in (A-1234, A-5678, A-9129) AND 'Target End Date' >= 2023-11-01 AND 'Target End Date' <= 2024-01-31")

If still issues, try to first find the epics. Does any of below query give you data?

'Epic Link' in (A-1234, A-5678, A-9129) AND 'Target End Date' >= 2023-11-01 AND 'Target End Date' <= 2024-01-31

'Parent' in (A-1234, A-5678, A-9129) AND 'Target End Date' >= 2023-11-01 AND 'Target End Date' <= 2024-01-31

Cause if above query is not give you Epics, obviously issuefunction will not return any stories.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

unknown-hosting-type