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().
I can propose two work arouds:
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' --
To create a Script custom field provided Script Runner plugin.
Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...
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!
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