I have a WHERE clause in my SQL query, which have to be translated into the elasticsearch bool filter.
here's the where clause: 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: $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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/5291b465-50d1-42da-a8a0-45ee154c1838%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
