How to "translate" the "where" clause from sql query to elasticsearch filter

Elastic Stack Elasticsearch
1

Hello! I'm implementing the filter for the internet shop using elastic
search. I have an EAV model in my RDBMS.

I have a WHERE clause in my SQL query, which have to be translated into the
elasticsearch bool filter.It works just fine in my rdbms.

here's it is:

WHERE (option = "weight" AND value = "50kg")OR (option = "weight" AND value = "500kg")AND (option = "magic" AND value = "no")

I have written the AND filters for inner ANDs of query, but now I need to
put them to the bool filter.

Tried to: (using elastica php library)

$boolFilter = new \Elastica\Filter\Bool();$boolFilter->addShould($innerFilterAnd1);$boolFilter->addShould($innerFilterAnd2);$boolFilter->addMust($innerFilterAnd3);

returns nothing.

Please, help!

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/fb5db090-e087-4481-8d6d-3d1783543d85%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.