How can I see Parent story status in and sub task status in one query

Question

I have written a query through which I can see all the sub-tasks in a sprint also I can see parent story title with parent story ticket#. But it does not show me the parent story status and parent story assignment. If I could see these two information also then it could make my life much easier.

Query is : issuetype in subTaskIssueTypes() AND project = POB AND summary ~ "Execute Test Case" AND text ~ "test case" AND Sprint = 314 ORDER BY updated DESC, status DESC, assignee ASC, created DESC

Prashant Sultania · Answer

Hello @Naresh Agrawal

In Jira, there isn't any such feature.

I think you are selecting the wrong column, in Jira basically there are 3 sections (My Default, Filter and System)

I cannot see system option in your screenshot. Basically, you are trying to select the filter in the column section, so it is wrong.

In Jira, there isn't any such column name "Parent Title" or "Parent Story Title" please find the screenshot below.

You can fetch all the all story issue type, sub-task issue type, epic issue type from the JQL itself
OR
You can fetch all the Story issue type and select sub-task in the column it will show you the links of the sub-task along with the number.

---------------------------------------------------

I found something and hope this will help you to understand. JIRA does not have the feature the one you are looking for. There are lots of users submitted the enhancement request to Atlassian, please find the url

https://jira.atlassian.com/browse/JRASERVER-16589

Thanks

Note: Upvote or like the answer if it resolves your query.

Naresh Agrawal_odi8ks · Answer

Thanks for the answer but this is not what I am looking for. I already have a report which give me the required information. But only problem is it does not allow me add column for Parent Story Status and Parent Story Assignee. It only has columns for Parent story Title.

I am also putting screenshot if it helps understand my concern.

Prashant Sultania · Answer

Hello @Naresh Agrawal

Below JQL will give you the list of all the story and sub-task which are not closed and do have "Execute Test Case" summary in it and assigned to the sprint.

project = project-key and (issuetype in subTaskIssueTypes() or issuetype = story) and status != done and summary !~ "Execute Test Case" and sprint = sprint_id

You can configure the columns in the list view, let me know if it works for you or not? Otherwise, I will fix it.

Thanks