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; } } }

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?

Accepted answers

Janice Castro

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.

All comments

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