Jira membersof jql issue

Paul Atkinson February 7, 2012

Hello,

Can anyone explain why my JQL query is not working. The query is as follows:

project = "cust.projA" AND assignee in membersOf("P5 Staff") AND status in(Open, "In Progress", Reopened, Resolved) ORDER BY key Desc

I get the following error when it is run:

A value provided by the function 'membersOf' is invalid for the field 'assignee'.

Can anyone shed light on this, The query works with other groups just not this group. I've looked at the group and all appears to be normal with the users, is there anything behind the scenes which could be causing the membersOf to cause an exception error?

The Jira version is 4.1

6 answers

2 votes
Tobias_Vollmer November 5, 2014

We had the same Issue.

A Member of the Group was disabled in the Delegated Authentication Directory.

We fixed the Issue with the removal of the User from the Group.

David Hornyik March 4, 2015

Hi, We had the same problem if I tried to use the membersof function with the WAS IN clause like: assignee was in membersof("groupname") After I deleted all the inactive users from the "groupname" group it started to work.

1 vote
David Hornyik March 4, 2015

Hi,

We had the same problem when I tried to use the membersof function with the WAS IN clause like:

assignee was in membersof("groupname")

After I deleted all the inactive users from the "groupname" group it started to work.

1 vote
Ricardo Araya May 14, 2014

JQL seems not to recognize the customs groups that we ve created...

1 vote
Christian Selbrede
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 3, 2012

I had a problem very similar to this once.

I resolved it with a re-index.

0 votes
Paul Atkinson February 8, 2012

Thanks for your post Jamie, I checked but we have all lower case.

I tried creating a new group with the same users and when I ran the jql with the new group I get results and no error. So it seems as though there is something going on that is maybe an issue with Jira itself getting messed up in the background.

Sadly using another group is not going to be a useful option, I really need the original to work correctly.

JamieA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 8, 2012

Yeah... possibly some database problem then...

0 votes
JamieA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 7, 2012

I had something that is possibly similar, but also possibly not. Are the members of that group all lower-case? I had users that had got created with some upper case letters, and I think a jql function gave me a similar error.

Suggest an answer

Log in or Sign up to answer