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 Sign up to answer
Community showcase
Posted Oct 09, 2018 in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

373 views 6 0
Join discussion

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