nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

All comments

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.

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...

Christian Selbr

I had a problem very similar to this once.

I resolved it with a re-index.

Ricardo Araya

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

Tobias Vollmer_ubz45l

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql