You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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 !!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.