Pivot Columns are not returned with Adonis 5

[mohux]

I really spent hours trying to debug the issue, please help

I have an "orders" table and model
a "services" table and model

they have many to many relationship

i added this

when I run this code

the pivot_price is not returned, even though when I run the same generated select query in PSQL, and it works perfectly

Is there anything am doing wrong that is preventing the model from returning the pivot columns?

[mohux]

Though Database is working perfectly as well but am losing the advantage of Lucid if I rely too much on Database :(

[thetutlage]

How are you trying to access the values?

[mohux]

the pivot values?

I tried this and it returns undefined

and am trying to return it with the query

[mohux]

Just to clarify, saloon has services and orders, orders are related to services and a user who ordered something from saloon
just dummy select it wont be in production like this

but what is not working is getting pivot_price

[thetutlage]

Can you please atleast type your code inline here vs dumping screenshots?

And it will be nice you can share the complete code to avoid back and forth.

• in which variable you store the query results.
• how do you access the computed property from that variable?

[mohux]

I apologise i thought the screenshots are good, i will paste them now

I tried the simplest query like below

      const order = await Order.query()
        .where("saloon_id", params.id)
        .preload("services", (query) => query.pivotColumns(["price"]))
        .first();

      return order?.pivot_price;

the computed is inside order

 @manyToMany(() => Service, {
    pivotTable: "order_services",
    localKey: "id",
    relatedKey: "id",
    pivotForeignKey: "order_id",
    pivotRelatedForeignKey: "service_id",
    pivotColumns: ["price"],
  })
  public services: ManyToMany<typeof Service>;

  @computed()
  public get pivot_price() {
    return this.$extras.pivot_price;
  }

[mohux]

Ok now I feel dumb 😮 your question gave me the answer, the computed should've been inside services not inside order (since its the one that is getting inner joined with pivot table)

[thetutlage]

Nice and screenshots are not okay when viewing on mobile.

See the difference yourself

[mohux]

.< am truely sorry, and thanks for your fast replay I really appreciate it I was thinking way out of the box that i forgot about the basics