Connection to other Custom field with assets DB

[Frederik Vodsgaard]

So I am struggeling a little with the custom fields connecting my assets DB to Jira tickets.
The DB setup example:
-Cars
--Wheel
---SerialNumber
---producer
---ect...

I have linked my first custom field with objectType IN ("Cars") in the filter scope. Then, I would like to have a custom field underneath where I can select the wheel, and a third custom field to change the serial number, etc. 
But the issue is that I cannot get my second field to have a dynamic relation to the other custom field.

I have tried the following "objectType = "Wheel" AND "Cars" = {{issue.fields.customfield_10097.key}}" where I am trying to filter wheels but only for the Car selected on the other custom field.
I have also tried to make inbound and outbound ref's for the wheel to use the following statement: objectType = "Wheel" AND inboundReferences() = {{issue.fields.customfield_10097.key}} - but that dosent work either

This is for changing elements from a jira ticket to automaticly change the DB so that i dont have to take notes in the ticket and in the DB

I hope i have provided enough information - and if anybody has a similar setup i would apreciate help with the next steps aswell

[Marc - Devoteam]

Hi @Frederik Vodsgaard 

I assume you have your Car as a referenced in object type wheel as an attribute.

So example:

Cars objects:

• Alfa Romeo
• Ford
• Audi

Wheel objects:

• 18" inch 
• 19" inch
• 20" inch

All Wheel object have aan attribute that is a reference to Cars

example:

Object Wheel 18" inch

• Name: 18" inch
• Car: Alfa Romeo

Custom Fields of asset type:

1. Car (customfield_10045) -> Filter scope: objecttype in ("Cars")
2. Wheel (customfield_10046) -> Filter scope: objectype in ("Wheel") Filter Work Item scope:  ("Car" = ${customfield_10045.label})

[Frederik Vodsgaard]

Thank you so much @Marc - Devoteam 
To understand this correctly, do i need an outbound reference on the Car to the Wheel and an outbound reference from the wheel to the car? So they both have an inbound and outbound ref? This is something that is confusing me, as I might get to change a wheel and would also like to just change it in one place (preferably in the Car).
Also, should I use the Filter scope or the Filter issue scope for the wheel?

[Marc - Devoteam]

Hi @Frederik Vodsgaard 

I would set an outbound reference on Wheel, so this shows as an inbound reference on Cars

It only needs to a single connection, no need to create references both ways.

To go deeper, set an outbound reference on Serial number to Wheel.

As I mentioned, On the custom field where you want to select the wheel, you need Filter scope and Filter issue scope, as the Filter issue scope looks at the Car chosen in the custom field where you select the car.