Using AND, OR in compound

Robert_Karlepalm · 2025-04-01T12:28:40.098Z

Is there a way to get this expression as an Atlas search query?

where('brand').is('ford')and('model').is('f150')
or('brand').is('ferrari')

When I use compound the query acts like this:
x AND y AND z....

The desired result should show Ford f150 and Ferrari’s of any series but it only show Ford f150’s.

The documents looks like this

{
  brand: String,
  series: String,
}

Erik_Hatcher · 2025-04-01T12:51:40.115Z

Does this Playground represent roughly the data and logic you are interested in? Code Sandbox

hope this helps!

system · 2025-04-06T12:51:41.045Z

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.