Linked object or nested aql

Question

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 companyActive XYZ CompanyActive

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)PlumbingABC CompanyPaintingABC CompanyLandscapeXYZ CompanyCarpentryXYZ 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 Companyneed to filter only those Services provided by ABC Company Urban siteABC Companyneed 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

rupen.deshpande · Answer

thanks @Marc -Devoteam- , yes, I kind of knew before I posted the question, that what we are trying to do something unconventional.

Marc -Devoteam- · Answer

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