we have a schema:

stores:
{_id , name}
getways:
{_id, store_id }
txes:

store has many getways, and getway has many txes.

We need count of txes for specific store.

in sql:

select count
from txes
where getway_id in
( select _id
from getways
where store_id = xxxx)

How can I write it in mongo query?

I write this query in jaspersoft studio mongo query.

Thanks for your help