How to query an EPIC list that contain some special contidions of sub-tickets

[huangbin chen]

Hi Experts,

I would like to query an EPIC List with some special conditions,
but don't know how to specify such queries,
could anyone help on this?!

Example:

project in ("ABC") AND type in (EPIC) AND labels in ("DEF")
and
>>other conditions in
1) There is/is not sub-tickets/subt-tasks in this EPIC
2) There is specific word in sub-tickets' summary
3) There is specific name in sub-tickets' assignee

Thanks

[David Berclaz _Apwide_ · Accepted solution]

Hi @huangbin chen

You need ScriptRunner in order to do such queries.

There is/is not sub-tickets/subt-tasks in this EPIC

project = PRJ AND issuetype = Epic AND issueFunction in epicsOf("project = PRJ")

There is specific word in sub-tickets' summary

project = ECP AND issuetype = Epic AND issueFunction in epicsOf("project = PRJ AND summary ~ word")

There is specific name in sub-tickets' assignee

project = PRJ AND issuetype = Epic AND issueFunction in epicsOf("project = PRJ AND assignee = username")

Let me know if it helps.

Cheers,

David

[huangbin chen]

Many Thanks ! Yes, this is what I want !

[David Berclaz _Apwide_]

You're welcome, have a nice day.