How to filter nested documents in elasticsearch? -

-

i have documents looks 

  {     "_id": "56161cb3cbdad2e3b437fdc3",     "_type": "comunity",     "name": "public",     "data": [       {         "title": "sonder",         "creationdate": "2015-08-22t03:43:28 -03:00",         "quantity": 0       },       {         "title": "vule",         "creationdate": "2014-05-17t12:35:01 -03:00",         "quantity": 0       },       {         "title": "omer",         "creationdate": "2015-01-31t04:54:19 -02:00",         "quantity": 3       },       {         "title": "sonder",         "creationdate": "2014-05-22t05:09:36 -03:00",         "quantity": 3       }     ]   }

the mapping: 

      comunitydocument": {         "_source": {           "includes": [             "meta.*"           ]         },         "properties": {           "doc": {             "dynamic": "false",             "properties": {               "data": {                 "type": "nested",                 "include_in_parent": true,                 "properties": {                   "title": {                     "type": "string"                   },                                        "creationdate": {                     "type": "date",                     "format": "dateoptionaltime"                   },                   "quantity": {                     "type": "integer"                   }                 }               },               "name": {                 "type": "string",                 "index": "not_analyzed"               }             }           },           "meta": {             "include_in_all": false,             "properties": {               "expiration": {                 "type": "long",                 "include_in_all": false               },               "flags": {                 "type": "long",                 "include_in_all": false               },               "id": {                 "type": "string",                 "include_in_all": false               },               "rev": {                 "type": "string",                 "include_in_all": false               }             }           }         }       }

and query 

{   "size": 0,   "aggs": {     "filteragg": {       "filter": {         "nested": {           "path": "comunitydocument.doc.data",           "filter": {             "terms": {               "comunitydocument.doc.data.quantity": [                 0               ]             }           }         }       }     }   } }

as result have count of "data" documents quantity equal 0 don't it. strange thing nested aggregations works not nested filters.

if comunitydocument type, correct query should be

{   "size": 0,   "aggs": {     "filteragg": {       "filter": {         "nested": {           "path": "doc.data",           "filter": {             "terms": {               "doc.data.quantity": [                 0               ]             }           }         }       }     }   } }

Comments

Post a Comment

Popular posts from this blog

php - Invalid Cofiguration - yii\base\InvalidConfigException - Yii2 -

-
Image
i've installed yii2-user module/dektrium yii2-app-basic application command composer require "dektrium/yii2-user:0.9.*@dev" config/console.php return [ . . 'modules' => [ 'gii' => 'yii\gii\module', 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] config/web.php 'components' => [ . . /* 'user' => [ 'identityclass' => 'app\models\user', 'enableautologin' => true, ], */ 'modules' => [ 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] after that, run command $ php yii migrate/up --migrationpath=@vendor/dektrium/yii2-user/migrations updating database schema . but, when run http://localhost/mylawsuit/yii/web/index.php?r=u
Read more

How to show in django cms breadcrumbs full path? -

-
need advice - how show in breadcrumbs whole path article or page? i've got code: {% ance in ancestors %} <li> {% if not forloop.last %} <a href="{{ ance.get_absolute_url }}">{{ ance.get_menu_title }}</a> {% else %} <span class="active">{{ ance.get_menu_title }}</span> {% endif %} </li> {% endfor %} but shows "home" , current page. how modify show whole path in breadcrumbs? i've found in file menu_tags.py code calls ancestors. @ least there class showbreadcrumbs: class showbreadcrumb(inclusiontag): """ shows breadcrumb node has same url current request - start level: after level should breadcrumb start? 0=home - template: template used render breadcrumb """ name = 'show_breadcrumb' template = 'menu/dummy.html' options = options( argument('start_level', default=0, require
Read more

ruby on rails - npm error: tunneling socket could not be established, cause=connect ETIMEDOUT -

-
i have app uses rails framework , implements angularjs part of front end. i have pushed heroku , have heroku toolbelt installed, when try migrate db using "heroku run rake db:migrate" receive following error(s): installing core plugins heroku-cli-addons, heroku-apps, heroku-fork, heroku-git, heroku-local, heroku-run, heroku-status... error installing package. try running again gode_debug=info see more output. ! `run` not heroku command. ! perhaps meant `-h`, `2fa`, `auth`, `join`, `open`, `orgs`, `pg`, `ps` or `rake`. ! see `heroku help` list of available commands. i run command "gode_debug=info heroku run rake db:migrate" , receive error: npm err! darwin 14.5.0 npm err! argv "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/bin/node" "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/lib/node_modules/npm/cli.js" "install" "heroku-cli-addons" "heroku-apps" "heroku-fork
Read more