Jira membersof jql issue

[Paul Atkinson]

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

[Tobias Vollmer]

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]

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.

[David Hornyik]

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.

[Ricardo Araya]

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

[Christian Selbrede]

I had a problem very similar to this once.

I resolved it with a re-index.

[Paul Atkinson]

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]

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

[JamieA]

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.