Filter data source by AQL in Assets

[Frederic Chartrand]

I have an obectType called "Product catalog" and child objectType called "Supported Laptops", Supported Desktops", etc ..

I also have another objectType called "Assets" with child objectType called "Laptops", "Desktops", etc. (those are for the "live assets" deployed).

On my "Laptop" objectType, I have an attribute called "Model" that refers to the "Supported Laptops" objectType.

I created my different objects in "Supported Laptops" (all the models supported)

Now I want to import assets from a CSV file. This file contains a lot of Assets, not all of them being Laptops.

So I try to filter my data source with an AQL.

In my mapping, I configured :

Name -> Name

SerialNumber -> Serial Number

Model -> Model | AQL -> Name=${Model}

But I can't find the correct AQL query to filter all the data in my CSV file. I want the AQL to perform this :

When you import an object, the "Model" attribute must be an object in the "Supported Laptops" objectType

I tried :

Model = "Supported Laptops"

Model IN ("Supported Laptops")

Model IN (objectType = "Supported Laptops")

Nothing works ...

Can someone help me find the AQL query that will solve my problem ??

Thanks !

[Frederic Chartrand · Accepted solution]

Well I'm gonna answer myself here. :D

I found out that you can't filter your data source on an attribute if this attribute is a referenced object ...

So to bypass this limitation, I had to copy the "Model" in my data source in another attribute called "Model Name" (this a simple text attribute) and then filter my data source using this attribute and listing ALL the supported models ...

"Model Name" IN (list all your models here without a typo ...)

This will be a nightmare to maintain but at least it's working.

But Atlassian ... If you're listening, please add the option to filter by objectType !!

[Yaoqi Huang]

I also need this feature. I want to filter objects whose target attribute is null. Is this feature implemented now?

[Steven F Behnke]

feature is still not delivered. https://jira.atlassian.com/browse/JSDSERVER-7895 

[Shubham Tiwari]

@Frederic Chartrand how did you achieve copying the "Model" to "Model Name". I have imported data from Azure and have a requirement to filter objects at source. The attribute I am trying to copy has multiple values and I'm trying to utilize the Automation but however it does not execute as intended.

Below is the automation flow: