Hyperledger How to retrieve properties of relationship through query

Question

I want to create a query which returns all the Requests (asset) in which the Container's (asset) owner's id is equal to the parameter.

Model file (owner of a container is a Company participant, identified by id):

namespace org.acme.shipping.assets
import org.acme.shipping.participants.*

asset Container identified by number {
  o String number
  o ContainerType type
  o String content
  o ContainerStatus status default = "FREE"
  --> Company owner
}

enum ContainerType {
  o DRY
  o REEFER
}

enum ContainerStatus {
  o LOCKED
  o FREE
}

asset Request identified by id {
  o String id
  --> Container container
}

Query file

query getRequestsByCompany {
  description: "Get requests by company"
  statement:
      SELECT org.acme.shipping.assets.Request
          WHERE (container.owner.id == _$company_id)
}

How do i do this?

Answer 1

I dont think its possible using query. You can do it using loopback filters:

{"where":{"shipmentId":1000}, "include":"resolve"}