Skip to content

GitLab

Last edited by Andrea Pavlovic
Page history

Queries

Query #1 List Company Members?

https://garage.abocar.at/data/assignment/core_customer/query

   {
    "attrs": {
        "order_by": {
            "-desc": "me.id"
        },
        "prefetch": [
            "assigned_client",
            {
                "binding_instance_of_customer": "owning_client"
            }
        ]
    },
    "conds": {
        "binding_instance_of_customer.id": "154"
    },
    "page": 1,
    "page_size": 10
}

I assume, you're trying to list all clients of a company?

"binding_instance_of_customer" is the company itself, so you don't need to fetch that unless you want the company details. "owning_client" should be empty though, as a company does not have a login.

So, "assigned_client" is all you need.

Assuming a company with core.customer.id=5. First, fetch the core.customer.ids of the associated clients:

#/data/assignment/core_customer/query
{
  "conds": {
        "binding_instance_of_customer": 5,
        "assigned_client" : {"!=":5}
    },
  "attrs" : {
    "prefetch" : ["assigned_client"]
  }
}

Should you need any data of those clients from core.customer, you will have to use a seperate query with the ids returned in the previous one:

#/data/core/customer/query
{
  "conds": {
    "me.id" : {"-in": [142]},
    "me.is_client" : true
  }
}

Or use the single query documented here: https://git.ironapi.com/cct/abocar/-/wikis/Customers#list-company-clients