"Not" filter is not working on a query

[Serdar Sakin]

Hi guys,

We need help with "Not" filter on Druid. Somehow, "Not" filter is not
working when it is used with other filters. The same query is working when
we remove the "Not" filter. You can see the query we make below:

{
   "aggregations":[
      {
         "type":"longSum",
         "fieldName":"requests",
         "name":"requests"
      },
      {
         "type":"longSum",
         "fieldName":"impressions",
         "name":"impressions"
      }
   ],
   "granularity":"all",
   "intervals":[
      "2018-11-29T00:00:00+00:00/2018-11-30T00:00:00+00:00"
   ],
   "dimensions":[
      "ssp"
   ],
   "having":{
      "type":"greaterThan",
      "aggregation":"impressions",
      "value":0
   },
   "dataSource":"adx_reports",
   "queryType":"groupBy",
   "filter":{
      "type":"and",
      "fields":[
         {
            "type":"or",
            "fields":[
               {
                  "dimension":"traffic_channel",
                  "type":"selector",
                  "value":"RTB_BANNER"
               }
            ]
         },
         {
            "type":"not",
            "fields":[
               {
                  "dimension":"device",
                  "type":"selector",
                  "value":"Computer"
               }
            ]
         },
         {
            "type":"or",
            "fields":[
               {
                  "dimension":"inventory_type",
                  "type":"selector",
                  "value":"SITE"
               }
            ]
         }
      ]
   }
}

Thanks,
Serdar

*Serdar Sakin, PMP* | *Project Manager*

 [image: logo.png] <http://reklamstore.com/>

A: Yeşilce Mh. Diken Sk. No:4 K:4, 4. Levent / İstanbul
T: +90 212 284 4449 <+90%20212%20284%204449> Ext: 682
M: +90 532 133 0741 <+90%20532%20133%200741>
E: ser...@reklamstore.com
Skype: serdar-rs
W: reklamstore.com