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

JQL search for current user = asset object attribute

Peter Strömberg_lparx4

Hi,

We have most our Jira issues connected to delivery projects, being asset objects. The name of the object is "Project", and they sit in an object schema named named "IAMP - Projects and installed base".

The project object has several attributes, like "Project Manager".

Now I want to have a JQL that gives me, ALL jira issues connected to the Project objects where the project manager = current user.

That is, assume I am project manager for 10 delivery projects, and they are connected to 1000 Jira issues (various jira projects). These delivery projects are normally connected with asset custom field named "Project number".

Now I want the JQL to query all those 1000 issues, for the projects which I am managing.
How to write this? I tried with issues in assetAttributeValue. Did not work.

Any help would be highly appreciated. Thanks.

Best regards

Peter

issue in assetAttributeValue("Project", "Project manager", currentUser())

Accepted answers

Peter Strömberg_lparx4

Thanks Lisa,

Perhaps getting closer, but still generating error.

I enclose some pictures showing the object, attribute, and search result.

All comments

Lisa Forstberg_o85gu4

Hej @Peter Strömberg ,

Is the attribute called "project manager" a jira user type attribute?

My server skills are a bit dusty right now but what does this give you

Project in attributeValue("Project Manager","=","currentUser()")

more documentation here

Best regards

Lisa

Peter Strömberg_lparx4

Thanks Lisa,

Perhaps getting closer, but still generating error.

I enclose some pictures showing the object, attribute, and search result.

Lisa Forstberg_o85gu4

Oh I think I made a couple of mistake here.

1) attributeValue is deprecated, we should use aqlFunction instead

2) If we run

Project in attributeValue("Project Manager","=","currentUser()")

then Jira will look for the the Jira Project, not the field called project.

You have a asset custom field called "project" right? that is applied to each issue connecting them to the project object. If you find the custom field id for that field you should replace it with 12345 in this example:

cf[12345] in aqlfunction('"Project Manager"= currentUser()')

Lisa Forstberg_o85gu4

By the way - I am consulting this documentation: https://confluence.atlassian.com/servicemanagementserver/assets-jql-functions-1087513360.html

Lisa Forstberg_o85gu4

I have ran this JQL on my Cloud and it works

"Customfieldname" in aqlFunction('"SME" = currentUser()')

Lisa Forstberg_o85gu4

Ignore this peeps! Check the thread above instead :-P

Welcome!

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

Quick Links

Find more posts tagged with

jql

jira-data-center

data-center

currentuser

asset-object