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)

0 votes
Vasiliy Zverev Community Champion Feb 23, 2016

I can propose two work arouds:

  1. To use this SQL:

    Select
    	customfield.cfname
    	, customfieldvalue.*
    	, cwd_group.*
    	, cwd_user.display_name
    from
    	customfield
    	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
    where
    	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
Asked Thursday in Jira Ops

I'm John Allspaw, Ask Me Anything about incident analysis and postmortems

I'm John Allspaw, co-founder of   Adaptive Capacity Labs, where we help teams use their incidents to learn and improve. We bring research-driven methods and approaches to drive effective inciden...

5,423 views 21 17
View question

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