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

huangbin chen_f0oevs

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)

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