using JQL to pull the following without plugin ?

[kazu yama]

Greeting Dear community, 

How can I or if possible to pull the following without plugin ?

Basically I want to see all the no-closed ticket and its sub-task in a flatten view like below:

ticket_status	reporter	assignee	release	jira_ticket	desription	open sub-task	sub-task assignee
new	SR	SR	10.2	https://jira.qctsd.com/jira/i#browse/SMY-10966	SMY Support for unsinsh for Final Test DFST and DFHF	all-closed/resolved
open	bv	bv	10.2	https://jira.qctsd.com/jira/i#browse/SMY-11089	H+ 6.0 SMY changes, Schema update, outbound updates	https://jira.qctsd.com/jira/browse/SMY-11198	bv
open	bv	bv	10.2	https://jira.qctsd.com/jira/i#browse/SMY-11089	H+ 6.0 SMY changes, Schema update, outbound updates	https://jira.qctsd.com/jira/browse/SMY-11214	sd
open	bv	bv	10.2	https://jira.qctsd.com/jira/i#browse/SMY-11089	H+ 6.0 SMY changes, Schema update, outbound updates	https://jira.qctsd.com/jira/browse/SMY-11216	un-assign
open	bv	bv	10.2	https://jira.qctsd.com/jira/i#browse/SMY-11089	H+ 6.0 SMY changes, Schema update, outbound updates	https://jira.qctsd.com/jira/browse/SMY-11217	un-assign
open	bv	bv	10.2	https://jira.qctsd.com/jira/i#browse/SMY-11089	H+ 6.0 SMY changes, Schema update, outbound updates	https://jira.qctsd.com/jira/browse/SMY-11218	un-assign
open	bv	bv	10.2	https://jira.qctsd.com/jira/i#browse/SMY-11089	H+ 6.0 SMY changes, Schema update, outbound updates	https://jira.qctsd.com/jira/browse/SMY-11292	bv
open	bv	bv	10.2	https://jira.qctsd.com/jira/i#browse/SMY-11089	H+ 6.0 SMY changes, Schema update, outbound updates	https://jira.qctsd.com/jira/browse/SMY-11295	wr
open	bv	bv	10.2	https://jira.qctsd.com/jira/i#browse/SMY-11089	H+ 6.0 SMY changes, Schema update, outbound updates	https://jira.qctsd.com/jira/browse/SMY-11313	sp
open	bv	bv	10.2	https://jira.qctsd.com/jira/i#browse/SMY-11089	H+ 6.0 SMY changes, Schema update, outbound updates	https://jira.qctsd.com/jira/browse/SMY-11335	sp

[Nick]

I have just tried this

status not in ("Closed")

which displays all tickets which do not have status "Closed" both tasks and subtasks. You can further refine this with 

    issuetype in standardIssueTypes()

    issuetype in subTaskIssueTypes()

to filter either the tasks or the subtasks