unable to execute projectsLeadByUser() in JQL

[Janice Castro]

Trying to execute the advanced function where I specify a specific project lead (not myself)

When I use full name in quotes or email in quotes, the JQL executes but says no user exists for the email or name.

On our instance, the username always resolves to a GUID value but using this in the JQL returns the error:

A value provided by the function 'projectsLeadByUser' is invalid for the field 'project'.

project in projectsLeadByUser("557058:569b17ea-c4e4-40ab-9509-7cba72a47a79")

what am I missing?

[Janice Castro · Accepted solution]

I reported the issue to Atlassian support. It turns out that this is a known issue with users who are Project Leads on an Archived project.

https://jira.atlassian.com/browse/JRACLOUD-78152

As to why the UID looks weird, I have no idea.

[Sam Bartolome]

Hi @Janice Castro ,

Welcome to the Atlassian Community,

The GUID doesn't seem to match the pattern of my users as in my instance there is no colon, neither dashes, only hexadecimal 

[Janice Castro]

I don't know what to tell you. When I try other fields in the JQL it comes up like that and executes

and reporter = 557058:569b17ea-c4e4-40ab-9509-7cba72a47a79

when i type in the name and select the user from the auto drop-down, it automatically converts it to that format. even when I look up the user under People, the url reflects the same

jira/people/557058:569b17ea-c4e4-40ab-9509-7cba72a47a79

[Sam Bartolome]

The user management should show something like 

users/5bc0988553dc9c5087ee000d

when you click on a user's account and then use the last part.

Maybe it is the type of user provisioning which then differs

[Janice Castro]

I checked user management and it shows the same thing:

/users/557058:569b17ea-c4e4-40ab-9509-7cba72a47a79

still, even if it didn't, not everyone is a site manager so needing to look up a user's account via user management is not a solution