Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

×
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

AQL to search for object having inboundreference (objecttype / attribute)

Good morning, 

 

I am looking for an AQL that retrieve objects depending on its Inboundreferences.

 

I have those custom fields:

- Order Template Name (id: 10131) - which shows Template Name assets

- Template Product Name (id: 10133) - which shows Products assets

 

Products object have Inboundreferences to Order Templates object

 

What I want to see from my create screen are Products that are related to Template Product previously selected. 

First I tried my AQL on asset, making sure it is workingAQL on Asset.png

 

Then I tried by replacing "Fitness" by {$customfield_10131}, but doesn't work. Even tried with Key IN or Key = 

Asset custom field AQL.png

Anyone has an idea?

 

Thanks for your help,

1 answer

1 accepted

2 votes
Answer accepted

Resolved it, I had to use "objectId ="

->  object HAVING inboundReferences(objectid = ${customfield_10131})

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events