Help: how does the order of where() clauses affect queries?

[mgussekloo]

Hi,

These two variants give entirely different results: the first returns all published entries across collections, not filtering by languages. The second works as expected (show only languages that are published). Am I missing something here?

$entries = Entry::query()
->whereStatus('published')
->where('collection', 'languages')
->get();

$entries = Entry::query()
->where('collection', 'languages')
->whereStatus('published')
->get();

[jasonvarga]

whereStatus adds subqueries based on what collections are being queried. It needs to know what collections you want first.

Maybe we can make it throw an exception if you call it in the wrong order. Done in #12744

[mgussekloo]

Thanks! The exception helps, it would be even better if the order doesnt matter (to fit with the way Laravel does this). Consider this a feature request 😀

thanks!

[jasonvarga]

Definitely!