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 - looking for issues based an attribute of connected Asset object

Simon Sahli

Hi Community,

question related to JQL issue search in combination with an Asset object and their attributes. I am wondering if the following use-case is possible to do with JQL in the JSM cloud.

Our issues are always connected to an "Customer" Asset object (Customer is visible as a field on the issue). This customer Asset object has the "Key Account Manager" as an attribute.
Now I would like to see all issues for a specific "Key account Manager" within an JQL.
I can find the key account manager field in JQL search, but when I set a valid name then no issues can be found.
If I look for the customer object in JQL then the correct issues are displayed.

So my question is, how can I look for issue related to an attribute of a connected Asset object?
Like is it somehow possible or do I need to find another solution.
Plan B could be do copy the asset attribute value into a Jira custom field (I know that this would work).

Thanks in advance!
Cheers,
Simon

Accepted answers

Uday Kiran Bhaviri_cp1r58

You can use AQLFunction in JQL to fetch the issues.

Example: here customField is Assets object custom field in Jira and Account Manager is the attribute of Customer object.

customField in aqlFunction("Customer.\"Account Manager\" = \"Mathias Edblom\"")

Refer to the below article

https://support.atlassian.com/jira-service-management-cloud/docs/assets-jql-functions/

All comments

Mathieu Truchot

Hi Simon,

This should be possible with the AQL JQL fonction

Uday Kiran Bhaviri_cp1r58

You can use AQLFunction in JQL to fetch the issues.

Example: here customField is Assets object custom field in Jira and Account Manager is the attribute of Customer object.

customField in aqlFunction("Customer.\"Account Manager\" = \"Mathias Edblom\"")

Refer to the below article

https://support.atlassian.com/jira-service-management-cloud/docs/assets-jql-functions/

Simon Sahli

I have seen this article and the example, but which value do I need to use for the "customField" for my situation?

I have tried some variants, but I never got any issues displayed...

Uday Kiran Bhaviri_cp1r58

Here custom field refers to the custom field which you must have created in Jira to show the assets values in issues view or edit or create screen

In your case I think you have mentioned as "Customer is visible as a field on the issue" so you need to use that field name.

Regards

Uday Kiran

Simon Sahli

Hi @Uday Kiran Bhaviri

I did that, but I still do not get any issues as a result of the query. There is no error displayed either, so I probably it just does not find any issues with constructing a query for this use case.
Perhaps you see in the following example what I am doing wrong or if it is perhaps not possible what I am trying to do.

So I have the following query where I want to display all the issues of customers with Gabriella as the Key account manager:
customer in aqlFunction("Customer.\"Key Account Manager\" = \"NameXYZ\"")

There are multiple customers for which Gabriella is the Key account manager and all these issues should be displayed. There are plenty of closed and open issues connected to this customer. Issues are always connected to the customer, but not directly to the Key account manager.
Customer example:

Do you see why the query displays nothing with this query?
Is there a better way of getting all the issues depended on a specific customer attribute?

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jql

jira-service-management-cloud

jira-service-management

assets

aql