How do I include sub-tasks in filter results while searching for issues meeting certain criteria?

[Svetlana Khrisanfova]

Hi there! What I'm trying to do is to generate a custom report based on a filter. In order to accomplish that I need a filter that would search for issues containing a certain field value and belonging to a given project. Moreover, any existing sub-tasks of these issues need to be included too.

ScriptRunner add-on did not work for me - some kind of an installation problem occurred. Due to this problem I could not even use my free trial properly.

So, basically, I'm looking for a workaround now. Any ideas are welcome! 

[Muhammad Ramzan(Atlassian Certified Master)]

If you explain your question further, i can help you more, What i understand is you need a filter where you need to match values. You can use JQL Search Extensions for Jira & reports  plugin to complete your tasks.

Following query will help you .

fieldMatch(jql-subquery, field-name, regexp)

FieldMatch can be used to find issues with field matching the regular expression in the argument. For instance:

issue in fieldMatch("project = SEARCH", "description", "find issues mat*")

Will find all issues with description field matching the regular expression find issues mat*. 

The asterisk * matches any alphanumeric characters. It is also possible to use all regular expression constructs, such as

issue in fieldMatch("project = SEARCH", "description", "find issu[a-z]{2} mat*")issue in fieldMatch("project = SEARCH", "my custom field", "f[a-z]{5}

 This function can be used with any system or custom field.

Documentation link:

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-fieldMatch(jql-subquery,field-name,regexp)

If you have any specific scenario , i can help you to create the query, as i am using this plugin since one year and know everything about it and scriptrunner.