[Elasticsearch] Convert two nested fields with the same path under same bool.must condition

[jkabat]

I'm trying to convert following string input to ES query and is very possible that this is not supported yet, however you might have an idea how to use RS to get it done.

String input:

"(width: 500 ~ 600; height: 1800;)"

Fieldset definition:

$generator->registerField('height', 'attributes[].height');
$generator->registerField('width', 'attributes[].width');

Query snippet:

{"bool":{"must":[
    {"nested":{..}}, 
    {"nested":{..}}
]}}

Would be possible to create one nested condition with queries inside bool? Something like:

{"bool":{"must":[
    {"nested":{
      "path":"attributes",
      "query":{"bool": {"must": [
           {"range":{"attributes.width":{"gte":500,"lte":600}}},
           {"terms":{"attributes.height":["1800"]}}
      ]}}

Unfortunately documentation is incomplete but there may exist a way to do a conversion by custom field, value+query transformer or simply by change of mapping in fieldset definition.
Is there something I may have missed?

[dkarlovi]

As noted in the mails we exchanged:

About your question, your config looks correct and it should work just like you described since it's in the same group, referencing the same path. I'd say this is a bug and it's currently not possible to do with nested, but we do it for has_child queries.

If you check the tests for the has_child merge example, you can probably reproduce your example as one of those tests there in a PR. That would allow somebody (maybe even you!) to supply the implementation, which would be awesome for everybody.

[jkabat]

@dkarlovi has_child seems to be working but it is not an option for me at the moment. As soon as I have time I'll take a look on grouping of nested type.

[dkarlovi]

@jkabat I didn't mean you should change your query to has_child, I just meant the same principle done for has_child should be applied to nested. 👍