swajp•17mo ago

get name by id

i am new to convex and i would love to get barber's name fro my schema and if i am mapping it i can access only to the barber _id

3 Replies

swajpOP•17mo ago

thats what i have for now

erquhart•17mo ago

Hey @swajp, welcome! You'll want to loop/map over your result and fetch each barbert to get the names.

const barberSubservices = await ctx.db
  .query('subServicesByBarber')
  .withIndex('barber_by_subservice', q =>
    q.eq('subservice', args.subservice)
  )
  .collect()
const barbers = await Promise.all(barbersSubservices.map(doc => {
  return ctx.db.get(doc.barberId)
})

const barberSubservices = await ctx.db
  .query('subServicesByBarber')
  .withIndex('barber_by_subservice', q =>
    q.eq('subservice', args.subservice)
  )
  .collect()
const barbers = await Promise.all(barbersSubservices.map(doc => {
  return ctx.db.get(doc.barberId)
})

swajpOP•17mo ago

Hi @erquhart thank you so much it works 😊

get name by id

Did you find this page helpful?