Searching question

[charlie-ablett]

I have a model with a one-to-many association. It's indexed on [:start], ie
field :start, value: ->(thing) { thing.bars.map(&:start) }

Foo has_many Bars

Bar belongs_to Foo

Each bar has a field called start which is a DateTime. I want to get any foo objects with at least one bar that occurs in the future. So that should not include any foos with no bars or bars with only past dates.

Using the Chewy syntax, I'd like to query ElasticSearch to retrieve all foo objects with at least one bar where start > Time.zone.now.

I've tried a few ways but it's not obvious how to do that. (not sure if this an "issue" but a usage question!)

[charlie-ablett]

I've tried

scope.filter(range: {start: {gte: Time.zone.now }} )

and

scope.filter(range: {start: {gte: Time.zone.now }} ).filter_mode('1')

with no joy. Seems to only return foos with any bars, even if they are in the past...

[pyromaniac]

Show me index mapping definition

[charlie-ablett]

edited above

[charlie-ablett]

Ah, I was missing "type: date" from the index.