JQL to see all sub-tasks assigned to a Team (Team-A)

[border_water]

Hi,

I am looking for a JQL to see all sub-tasks assigned to a Team (Team-A).

[Avinash Bhagawati _Appfire_ · Accepted solution]

Hi @border_water ,

If Team is group in Jira the you can use below JQL. Replace jira-software-users with your group name.

issuetype = Sub-task AND assignee in membersOf("jira-software-users")

Thanks,

Avinash

[border_water]

Hi,

No here team is not a group.

Also, how do i create a group. I have Administrator access and still i cannot create a Group.

Thanks

[Avinash Bhagawati _Appfire_]

Hi @border_water ,

Please refer below screenshot on how to create group and document.

https://confluence.atlassian.com/adminjiraserver/view-create-or-delete-a-group-938847038.html

Thanks,

Avinash

[border_water]

Thank you Avinash.....

I am not sure why i do not see all those menus in your screenshot ?

[border_water]

[Avinash Bhagawati _Appfire_]

Hi @border_water 

It looks like you do not have jira administrator permissions for the instance. Please get in touch with your jira administrator for getting necessary access. 

Thanks 

Avinash

[border_water]

Can you check the below screenshot and it seems I am an Administrator.

[Avinash Bhagawati _Appfire_]

Hi @border_water 

Basically you're administrator to projects in Jira that means you can do the configuration with in your projects. From screenshot it is visible that you are project admin and not a jira admin. 

A jira admin is responsible for complete management of Jira instance like creating projects, creating users, creating groups, workflow creations, screens, custom fields etc. 

For group management, you need to have jira administrator permissions. 

Thanks,

Avinash 

[Avinash Bhagawati _Appfire_]

Also you need to part of Jira administrator group to perform jira administrator things. 

As your team to add yourself to jira administrator group for jira admin permissions. 

Thanks, 

Avinash 

[border_water]

Got it. Thank you.

How do I find out who is the Jira Administrator ?

Thanks

[Avinash Bhagawati _Appfire_]

Hi @border_water

Please check with team or person who provided you jira access and they will be able to help you.

Thanks

Avinash

[border_water]

ok. Thanks.

Also  i cannot see "addon" menu to add "text gadget". I think this is same issue as above (Jira administrator).

thanks

[Avinash Bhagawati _Appfire_]

Hi @border_water 

Yes, you need jira admin access for the add-ons also.

Thanks

Avinash 

[Evan Golden {VisualScript}]

You can use Scriptrunner for Jira.

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_subtasks

[border_water]

I have No idea how i can use Adaptavist ScriptRunner ?

[Evan Golden {VisualScript}]

It is a marketplace application.  You will need to talk with your administrator.

[border_water]

Hi @Avinash Bhagawati _Appfire_ ,

is there any other way to query if team is not a group ?

Thanks

[border_water]

@Evan Golden {VisualScript} 

Now I have ScriptRunner installed, how do I use this to query all the sub-tasks assigned to a team called "Team-A" ?

[Evan Golden {VisualScript}]

See the subtasksof search function:

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_subtasksof