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

Bastien Delourmel _FMX_

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 _FMX_

Resolved it, I had to use "objectId ="

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