Parent Status is not showing info in filter

[Naresh Agrawal]

Hi

In my query report I have added columns for "Parent" in my query and it perfectly shows  correctly in the report. But I want to also see Parent Status but I dont see any option for that. Can you please help?

[Naresh Agrawal · Accepted solution]

Following up if you could respond to my previous question.

[Naresh Agrawal]

Finally I was able to get it done. Thanks for your help!

[Petter Gonçalves]

Hello @Naresh Agrawal

Thank you for reaching out.

Indeed, there's no option to add parent fields in the JQL column. In fact, the JQL columns display only fields that are displayed in the own issue view or returned by the REST API, so the parent status is not present in none of those views.

If you need that information for report purposes, you can either:

1 - Add the parent status as a custom field to your sub-task issue, optionally using the bulk operation feature

2 - Export the parent issues and sub-tasks to CSV separately, then copy and paste the parent column in the CSV file of the sub-tasks

Let us know if you have any questions.

[Naresh Agrawal]

Thanks for responding. I have two questions. Can you please clarify?

1. I think I need to be an admin to add thie custom field?

2. When we add Parent status custom field in Subtask issue, then will this field automatically populate parent status or we need to fill the value manually?

[Petter Gonçalves]

Hello @Naresh Agrawal

You are welcome! Here are the answers to your new questions:

1 - I think I need to be an admin to add this custom field?

Yes, you must be a site-admin to create custom fields. The steps to create and manage custom fields can be found in the documentation below:

- Jira Cloud Custom fields 

2 - When we add Parent status custom field in Subtask issue, then will this field automatically populate parent status or we need to fill the value manually?

Basically, you have two options to properly add the parent status to your custom field:

1 - Manually add the value to the custom field in your sub-tasks

2 - Use an Automation rule (Under project settings > Project automation) to automatically copy the parent status to your sub-task custom field. This would be the rule:

The rule background would be:

- WHEN a standard issue is transitioned

- IF it has sub-tasks

- THEN copy the parent status to the sub-task custom field

P.S: Make sure to add a global automation rule if you have sub-tasks from multiple projects linked to the same Epic.

Let us know if this information helps.

[Naresh Agrawal]

Thanks for response Petter. We have added the custom field but while putting the automation rule on it. 

I tried getting it done through our IT admin but since we (I and admin team) have never used this feature so admin team was not comfortable doing this change as they were scared if anything goes wrong and impact all projects. Do you see risk in doing this?

Also do you have any video which I can look through these step by steps. Or can you please give step by step screenshots so we will be more comfortable while doing this change. Thanks in advance.