Query DSL Help

Elastic Stack Elasticsearch
1

Hi all, I'm a pretty experienced SQL programmer but totally new to Query DSL and having a little trouble wrapping my mind around the way things are structured. Could someone please show me how you would write the following as a filter?

select * from users where
name='test'
and status='active'
and (state='registered' or state='pending')

Thanks so much for your help!

2

That's exactly a question I'm very interested to get an answer on, too.

Any Ideas there?