mozilla / ActiveData

Provide high speed filtering and aggregation over data
Mozilla Public License 2.0
31 stars 20 forks source link

Deep query does not filter properly #152

Closed klahnakoski closed 5 years ago

klahnakoski commented 5 years ago
{
    "from":"task.tags",
    "groupby":{"name":"name","value":"task.tags.value"},
    "where":[
        {"eq":{"name":"description"}},
        {"regex":{"task.tags.value":".*Mozilla-LDAP\\|.*"}},
        {"gte":{"action.start_time":{"date":"today-month"}}},
        {"eq":{"treeherder.symbol":"rt"}}
    ]
}

results in a filter with

            "filter":{"bool":{"filter":[
                {"bool":{"must_not":{"match_all":{}}}},
                {"range":{"action.start_time.~n~":{"gte":1562371200}}},
                {"term":{"treeherder.symbol.~s~":"rt"}}
            ]}}

specifically,

{"bool":{"must_not":{"match_all":{}}}},
klahnakoski commented 5 years ago

query was bad. added warning : https://github.com/mozilla/ActiveData/commit/94c071dc11e55b9ae53bcd744253752c0e65bdb5