JQL search for current user = asset object attribute

[Peter Strömberg]

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())

[Peter Strömberg · Accepted solution]

Thanks Lisa, 

Perhaps getting closer, but still generating error. 

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

[Lisa Forstberg]

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]

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

[Lisa Forstberg]

I have ran this JQL on my Cloud and it works

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

[Peter Strömberg]

Thanks a lot Lisa!

It finally worked!! :)

I used this search string: cf[10783] in aqlFunction('"Project Manager" = currentUser()')

See screenshot.

This opens for a lot of new possibilities in building Structures, dashboards and searching issues. Issue resolved. 

[Peter Strömberg]

[Lisa Forstberg]

Jättebra att det funkar i DC också. 

[Lisa Forstberg]

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

[Lisa Forstberg]

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