Simple query with and $or, $gte and $lt used to work perfectly?
{ "$or" : [ { "$and" : [ { "homeTeam" : "Team1"} , { "awayTeam" : "Team2"}]} , { "$and" : [ { "homeTeam" : "Team2"} , { "awayTeam" : "Team1"}]}] , "startTime" : { "$gte" : { "$date" : "2017-01-01T00:00:00.536Z"} , "$lt" : { "$date" : "2017-07-14T23:59:59.536Z"}}}
If the date range part i skipped it works and if only the date range part is used only it also works?
Using mongojack 2.7 and mongodb 3.4.5