Wishlist

When a shopper saves a vehicle, Vyro adds a row to wish_list. It’s a useful buying signal: who is interested in which car.

Note

Who can read: team members (owner, manager, support, reporting) of the vehicle’s showroom, and customers (their own list).

Get one

query WishlistItem($id: uuid!) {
  wish_list_by_pk(id: $id) {
    id
    created_at
    user {
      full_name
      email
    }
    stocked_vehicle {
      id
      make
      model
      code
    }
  }
}

List

Saved vehicles for one showroom, newest first:

query Wishlist($showroomId: uuid!) {
  wish_list(
    where: {
      stocked_vehicle: { showroom_stocked_vehicles: { showroom_id: { _eq: $showroomId } } }
    }
    order_by: [{ created_at: desc }, { id: asc }]
    limit: 50
  ) {
    created_at
    user {
      full_name
      email
    }
    stocked_vehicle {
      make
      model
      stock_id
    }
  }
}

The most-saved vehicles:

query MostSaved($showroomId: uuid!) {
  stocked_vehicles(
    where: {
      showroom_stocked_vehicles: { showroom_id: { _eq: $showroomId } }
      wish_lists: {}
    }
    order_by: { wish_lists_aggregate: { count: desc } }
    limit: 10
  ) {
    make
    model
    stock_id
    wish_lists_aggregate {
      aggregate {
        count
      }
    }
  }
}

The table is wish_list. From a vehicle or a customer, the relationship is wish_lists.