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 !!