According to this documentation of compound queires I can make queries like this
query(
collection(db, 'users', user.value.id, 'leaderboard'),
and(
where('series.seriesStartDate', '<=', new Date()),
where('score', '>', 0),
),
limit(5)
)
I have already made the index
and tested the query that it is working on a dashboard
But when I make the query in my application it is not working and I am getting the error
FirebaseError: Invalid query. All where filters with an inequality (<, <=, !=, not-in, >, or >=) must be on the same field. But you have inequality filters on 'series.seriesStartDate' and 'score'
What am I doing wrong