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

[Bastien Delourmel]

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 working

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

Anyone has an idea?

Thanks for your help,

[Bastien Delourmel · Accepted solution]

Resolved it, I had to use "objectId ="

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