How to find issues for a user that are present in group custom field in JIRA sql


15 answers

The custom field is of type Group Picker or a Multi User Picker?

That customfield is group Picker

Hmm, I don't think that this is possible. But maybe someone knows it better.

Could you please help it's urgent

Do you know the groups the particular user is in, then use

YourCFGroupPicker in (GroupA, GroupB,...)

That would be my only idea.

assignee in membersOf("groupname")

Actually we added  groups to a custom-field. so we want to use the customfield not group name. Is that possible?

I doubt that you can use something like

assignee in membersOf("<YourGroupCustomField>")

I am using like currentUser() in memeberOf("group field name") but that is not working.

Can you tell us what your requirements are (without how you are trying to achieve it), maybe we can help. The JQL you want will not work.

We added a group to custom field for some issues and then we are trying to search issues for a particular user, the user is present in the group that added to the custom field but we are unable to find issues with the function currentUser().

currentuser() will only work for user picker fields like

assignee = currentuser()

I still don't understand what your requirements are! What are you trying to achieve (and step back from your current solution)?

ok.. So for group picker field how we will use currentUser() function or tell me how the users of that group which is present in group custom field can see the issues

currentuser() will not work on group picker.

If the user knows in which groups he is (like GroupA and GroupB) use

YourCFGroupPicker in (GroupA, GroupB)

I can propose two work arouds:

  1. To use this SQL:

    	, customfieldvalue.*
    	, cwd_group.*
    	, cwd_user.display_name
    	join customfieldvalue	
    		join cwd_group	
    			join cwd_membership 
    				join cwd_user on	cwd_membership.child_id = cwd_user.ID
    			on cwd_group.ID = cwd_membership.parent_id
    		on customfieldvalue.STRINGVALUE = cwd_group.group_name
    	on	customfield.ID = customfieldvalue.CUSTOMFIELD
    	customfield.cfname = 'группы'		--here is custom field name
    	and cwd_user.user_name = 'vzverev'	--
  2. To create a Script custom field provided Script Runner plugin.


Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

667 views 4 15
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot