How i can populate media files in my query

General
1

In this query:

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

fixtures.tournament have 2 fields: name and media.
In my result i have this fields

"id":3,
    "category":"Primera",
    "division":"C",
    "dateTime":"2023-08-17T00:30:00.000Z",
    "scoreHome":0,
    "scoreGuest":0,
    "tournament":{
        "id":10,
        "name":"Amistoso",
        "createdAt":"2023-08-29T12:26:58.390Z",
        "updatedAt":"2023-08-29T12:26:59.437Z",
        "publishedAt":"2023-08-29T12:26:59.433Z"},

but, i can’t see the media file url in my query result.
Thanks…

2

Add ,'fixtures.tournament.media' after ‘fixtures.tournament’ in populate array block.

The media works as a relation table with each collection so you have to mention it like the above.