[V5] Need help about a builded query, it is a bug ?

[Reptiluka]

Hi !
I know the case may be weird, but it's my code :

const tourney_id = 4 //example
const user = auth.user

Team.query().whereHas('entry', (query) => {
                query.preload('tourney', (query) => {
                    query.where('id', '=', tourney_id)
                })
            }).whereHas('team_member', (query) => {
                query.where('user_id','=', user.id)
            })

If i add .toQuery() at the end, I got this :

select * from teams
where exists (select * from entrys where teams.id = entrys.equipe_id)
and exists (select * from team_members where user_id = ? and team.id = team_members.team_id)

My question is, where goes the line :
query.where('id', '=', tourney_id)
????
The line query.where('user_id','=', user.id) was correctly converted in the second .whereHas , but the first .whereHas , nothing appears in the query !

Thanks for your help ! 🙂

[Reptiluka]

I think I found my "little" bug ! Sorry again !

Team.query().whereHas('entry', (query) => {
                query.where('tourney_id', '=', tourney_id)
            }).whereHas('team_member', (query) => {
                query.where('user_id','=', user.id)
            })

I dont needed to access to the relationship, because I had already the key ... Oups 🙄 #LateNightCoding