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 !
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 !!
I also need this feature. I want to filter objects whose target attribute is null. Is this feature implemented now?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
feature is still not delivered. https://jira.atlassian.com/browse/JSDSERVER-7895
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.