I got this question from danmir123 on my YouTube video: https://www.youtube.com/watch?v=tXtLGocPpDs&lc=UgzR_QWLYRJG2zL9X1J4AaABAg

I have a somewhat complex question. I would like to add the asset field to my portal. External customers are all mapped within organizations, which in turn are mapped to assets. Is there a way to use AQL filters to show customers only values related to the assets belonging to their organizations? For example: I have Nintendo, Sony, and Apple. I have these three different objects in my assets. Would a Nintendo customer only see the children within Nintendo, such as “console type”?

Technically, this should be possible using something like this:

objectType = "Asset" AND "Organization" IN (objectType = "Organization" AND Name IN (${customer.organizations})

This should fetch the users' Organizations and match them against the Assets objects that match. If a user belongs to more than one organization, then they would see all assets for all organizations.

I have not tested it, but it should work :)

Hello jimi! i am Daniele, i asked you the question! :-)
In order to better understand, I created a simpler use case since my goal is to understand if I can use the “organization” parameter taken from the system when the customer connects to the portal.

Use case: show me the objects of the “organization” object type that have the name of the customer's organization.

Example. Organization = Nintendo, ---> customer in Nintendo.

ObjectType = Organization

Object Name = Nintendo

Let's assume 1 org for each customer

objectType = “Organization” AND Name = ${customer.Organizations.first.name}

This returns an error; I think it doesn't like ${customer.Organizations.first.name}.

Filter scope (AQL) ---> AQL syntax error, please enter a valid query

I did some test in the AQL.

Welcome @Daniele Mirabella :)

Let us first start with what you are trying to fetch.

If I understand correctly, you want to show Assets, not the organizations, correct?

The steps would be to show all Assets based on the user, and then we want to filter to show only the assets that correspond to the organizations the users belong to.

• Object Schema - This is in your example, Organizations

• Objecttype = "Assets" - This fetches the data from your Assets, as I assume these are the items you want to show?

• AND "Organization" IN (objectType = "Organization" AND Name IN (${customer.organizations}) - This requires you to have an attribute in Assets called Organization that maps to the Organization Objecttype. In that attribute, we look for objects that match the organizations the user belongs to in the variable (${customer.organizations}).

Let me know if that helps. I'll see if I can set this up and verify it for you, as sometimes the queries are not as logical as I think :)

Hi Jimi, I tried to follow the step-by-step configuration identical to the use case, but I'm still having trouble validating the AQL. I think ${customer.blablabl} is causing the problem. I glanced at the documentation and it seems that it's not supported as a smart value in the cloud. I'll run some more tests today, but it may be that this use case can't be satisfied. Could you kindly confirm this for me?

Here documentation ( Filter using a system field: customer is not in the table): https://support.atlassian.com/assets/docs/configure-the-assets-object-field/

18 minutes ago, Daniele Mirabella said:

Hi Jimi, I tried to follow the step-by-step configuration identical to the use case, but I'm still having trouble validating the AQL. I think ${customer.blablabl} is causing the problem. I glanced at the documentation and it seems that it's not supported as a smart value in the cloud. I'll run some more tests today, but it may be that this use case can't be satisfied. Could you kindly confirm this for me?

Here documentation ( Filter using a system field: customer is not in the table): https://support.atlassian.com/assets/docs/configure-the-assets-object-field/

You are right, the customer object is only available in an automation :)
I probably should not give you unverified AQL when I am sick, so let me set this up and verify so I don't waste more of your time.

It should probably use something like issue.organizations.name, but if we use something like

objectType = "Asset" AND Organization IN (
    objectType = "Organization" AND Name IN ({{#issue.organizations}}{{name}},{{/issue.organizations}})
)

...then it will give us an array, which we need to break down so we can make multiple matches...
I'll set this up in my Assets and get back to you as soon as my head clears a bit with something that works :)

This isn't as straightforward as it is in DC because we can't use a custom field in AQL as a reference, and we can't use the organization's value (which is a custom field), so I do not think this can be done without having your customers in Assets.

If you have your customers in assets, then you can use the reporter's email and show their assets as I show in this video:

I take it having your customers in Assets is not really an option?