"with" and opposite relationship

Hi guys!

Loving Manifest at the moment. After reading the documentation, it's clear that all relationships are bi-directional. However, I'm having trouble querying them.

This is my example:

  Table:
    properties:
      - { name: name, type: string }
      - { name: seats, type: number }
      - { name: closedAt, type: timestamp }
    validation:
      name: { required: true }
      seats: { required: true }

  Tab:
    belongsTo:
      - { name: table, entity: Table }
      - { name: createdBy, entity: Staff }

  Table:
    properties:
      - { name: name, type: string }
      - { name: seats, type: number }
      - { name: closedAt, type: timestamp }
    validation:
      name: { required: true }
      seats: { required: true }

  Tab:
    belongsTo:
      - { name: table, entity: Table }
      - { name: createdBy, entity: Staff }

    client
      .from("tables")
      .where("closedAt = null")
      .with(["tabs", "tabs.id"])
      .find<Table>()

    client
      .from("tables")
      .where("closedAt = null")
      .with(["tabs", "tabs.id"])
      .find<Table>()

However, this doesn't seem to be returning anything.
Given that I want to query the opposite relationship. How can I name the other side of that relationship?
I've tried "Tab", "Tabs", "tab" and "tabs" with no luck.

Is it possible to query in this direction? I'm hoping so!

Manifest•11mo ago•

2 replies

inlustra

"with" and opposite relationship

Hi guys!

Loving Manifest at the moment. After reading the documentation, it's clear that all relationships are bi-directional. However, I'm having trouble querying them.

This is my example:

  Table:
    properties:
      - { name: name, type: string }
      - { name: seats, type: number }
      - { name: closedAt, type: timestamp }
    validation:
      name: { required: true }
      seats: { required: true }

  Tab:
    belongsTo:
      - { name: table, entity: Table }
      - { name: createdBy, entity: Staff }

  Table:
    properties:
      - { name: name, type: string }
      - { name: seats, type: number }
      - { name: closedAt, type: timestamp }
    validation:
      name: { required: true }
      seats: { required: true }

  Tab:
    belongsTo:
      - { name: table, entity: Table }
      - { name: createdBy, entity: Staff }

    client
      .from("tables")
      .where("closedAt = null")
      .with(["tabs", "tabs.id"])
      .find<Table>()

    client
      .from("tables")
      .where("closedAt = null")
      .with(["tabs", "tabs.id"])
      .find<Table>()

"with" and opposite relationship

Similar Threads

"with" and opposite relationship

Similar Threads

Similar Threads

Similar Threads