How to query collection entries that have a Replicator block type?

[aaronbushnell]

I'm a bit stuck trying to query all entries that have a particular Replicator block type. Here's what I've tried:

Statamic\Facades\Entry::query()
        ->where('blocks->type', 'hero')
        ->get();

Which should yield at least one entry (a handful have a "Hero" block), but I'm getting no results. Am I possibly querying this incorrectly?

[ryanmitchell]

Currently you have to query by index... eg ->where('blocks->0->type', 'hero').

[aaronbushnell]

Thanks! Looks like I’ll have to find another solution because I can’t be certain about the index of the block I’m searching for. Appreciate the help though!

[duncanmcclean]

For future reference: once #7454 is merged, you'll be able to do the query without knowing the index. However, there's no ETA on that PR being merged.

[aaronbushnell]

Ah, thanks for calling that out, @duncanmcclean! I’ll keep watch of that one when it’s pulled in