Select field from relation

Questions and Answers
1

Hello, how i can select field from relations with this query?

const fixturacion = await strapi.db.query(‘api::notification.notification’).findOne({
where: { id : notificationId},
select : [ ],
populate: [‘fixtures’, ‘fixtures.home’, ‘fixtures.guest’],
})

Fields to select: notification.title, notification.date , home.avatar, home.name, guest. guest.avatar

2

await strapi
.query(‘api::notification.notification’)
.findOne({
where: { id : notificationId},
select: [‘title’,‘date’]
populate: {
home: {
select: [‘avatar’,‘name’],
},
guest:{
select: [‘avatar’]
},
});

try this one