Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,459,138
Community Members
 
Community Events
176
Community Groups

Filter Insight object type attributes using an indirection

Hello,

In Insight I try to filter an attribute of an object type using the relationship of another object type. Let me explain, I have the following configuration:

Schema1

"RAM" Object type

Attributes:

  • Value (Integer)

"Computer" Object type

Attributes:

  • Model (Object -> Computer model)
  • Amount of RAM (Object -> RAM)


Schema2

"Computer model" Object type

Attributes:

  • Max RAM (Object -> RAM)

 

Objects

RAM

  • Object1
    • Name = 8 gigabytes
    • Value = 8
  • Object2
    • Name = 16 gigabytes
    • Value = 16
  • Object3
    • Name = 32 gigabytes
    • Value = 32

Computer Model

  • Object1
    • Name = Lenovo XX
    • Max RAM = 16

I would like that when I create a new object for the Computer object type (and that the Lenovo XX model is chosen) that the choices offered in the Amount of RAM attribute be limited to 8 and 16 gigabytes and that the 32 gigabytes choice be not shown.

I tried to put a filter on the Amount of RAM attribute of the Computer object type but I do not find the IQL making reference to the Computer model/Max RAM.

???? = ${Model} and Value < "Computer model.Max"

Any idea?

 

Note: I have well read and watched :

1 answer

1 accepted

1 vote
Answer accepted

If this was possible, I think the Filter IQL would look something like this

Value <= ${Model."Max RAM".Value}
^ ^ ^ ^
| | | └--- Value attribute of RAM Object
| | └----Attribute on Computer Model object type that points to RAM object
| └--Placeholder: Attribute label for Computer object type
└--- Attribute of the RAM objectType

But I don't think it's possible to drill down from within into placeholders.
I believe the ${Model} can only return the object label.

So the only way to make this work is to change you Compter Model object type to let you select all the possible RAM option rather than just the Max.

Something like "Allowed RAMs" attribute with "unlimited" cardinality

Then in the Computer object Ram attribute, you would apply this filter:

object HAVING inboundReferences(ObjectType = "Computer Model" and Label = ${Model})

This returns all the RAM objects that have an inbound link from Computer Model that match Model you've just selected

Thank you for your answer and the new approach ! 

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events