Linked object or nested aql

[rupen_deshpande]

I have 3 objects in the same object schema, Supplier, Services and Contracts

Supplier has list of all suppliers, and attributes are, 

Supplier name (text)	Status (dropdown)
ABC company	Active
XYZ Company	Active

Services object has the list of services required like plumbing, building, painting, etc. and also has an attribute called Supplier that links back to the Supplier object.

Services (text)	Supplier (object, Reference)
Plumbing	ABC Company
Painting	ABC Company
Landscape	XYZ Company
Carpentry	XYZ Company

Contracts object has the various contracts active with the supplier. When a new object is to be created in Contracts.

Contract Name (text)	Linked Supplier (object, Reference)	Linked Services (object, Reference)
Village site	ABC Company	need to filter only those Services provided by ABC Company
Urban site	ABC Company	need to filter only those Services provided by ABC Company

in other words,

Linked Services [dropdown] = Services where Supplier = Linked Supplier 

with AQL 

object having outR(objectType = "Services", refType IN ("Link"))

I am simply getting the complete list of service irrespective of who the supplier is as long as there was a supplier added in that object.

Basically, it returns, Plumbing, Painting, Landscape, Carpentry

I want to have the AQL filter that only list the services provided by the Supplier entered in the reference object. In this case i am expecting Plumbing, Painting only

[Marc - Devoteam]

Hi @rupen_deshpande 

You are just referring to the assets schema and it's object types. You can't filter based on AQL for an attribute.

Object references links to another object type in the schema it will provide all the objects of that type, you can't filter this.

This is not a function of assets, assets is a database