The doucment is returned even if it does not meet the criteria

[RainTown (Kevin Maguire)]

See similar thread, where the actual query in that thread is generated by a call to /sql/translate - @vinitp I would be curious if same is true here?

Opening multiple threads on effectively the same topic is, er, a little irritating.

Must_not does not work in the nested array

I have an application that generates Elasticsearch SQL dynamically based on the client's search criteria. The application then use the "/sql/translate" API to translate to the DSL query which it executes. The sample of the SQL looks like this: "select * from hearing_alias where hcAccountabilityOfficeCode = '550' AND hearingActionDetails.haaActionTypeCode = 'SU' AND hearingActionDetails.haaActionCatCode = 'A' AND hcStatusCode <> 'STS54' AND hearingActionDetails.haaPartyRespRcvdOn is null AND…