Shulou(Shulou.com)06/03 Report--

First, show the data structure as follows:

{"itemId": "132417862061", "site": "US", "sellerId": "aaaaa", "increamentId": "3753595", "ebayTrackList": [{"numCount": 0, "pageView": 1, "userView": 1, "amountPaid": 0, "conversionRate": 0 "date": "2017-12-15"}, {"numCount": 0, "pageView": 1, "userView": 1, "amountPaid": 0, "conversionRate": 0, "date": "2017-12-29"} {"numCount": 0, "pageView": 1, "userView": 1, "amountPaid": 0, "conversionRate": 0, "date": "2018-02-03"}, {"numCount": 0 "pageView": 1, "userView": 1, "amountPaid": 0, "conversionRate": 0, "date": "2018-03-12"}, {"numCount": 0, "pageView": 1, "userView": 1 "amountPaid": 0, "conversionRate": 0, "date": "2018-03-20"}, {"numCount": 0, "pageView": 1, "userView": 1, "amountPaid": 0, "conversionRate": 0 "date": "2018-03-24"}, {"numCount": 0, "pageView": 2, "userView": 1, "amountPaid": 0, "conversionRate": 0, "date": "2018-04-01"} {"numCount": 0, "pageView": 1, "userView": 1, "amountPaid": 0, "conversionRate": 0, "date": "2018-04-02"}], "publisher": "2714", "title": "MOTOSPEED LED Backlight 87 keys Bluetooth Mechanical Keyboard Red Switches T1W8" "sku": ["C5060"], "img": "https://cache.yisu.com/upload/information/20200310/72/153898.jpg?set_id=8800005007","price": 55.05," status ": 1," currency ":" USD "," createTime ":" 1512074612 "," updateTime ":" 1522694170 "," mark ": null," fromCountry ":" Shen Zhen "," oldSku ": null}

The current requirement is that if I want to know the sum of the pageView of 2018-04-02 No. 2018-04-03, I obviously need the ebayTrackList.date filter sum ebayTrackList.pageView field.

The statement is as follows

{"query": {"bool": {"must": [{"term": {"itemId": "132417862061"}} {"nested": {"path": "ebayTrackList" "query": {"bool": {"must": [ {"terms": {"ebayTrackList.date": ["2018-04-03" "2018-04-02"]}]}} }}]}} "aggs": {"numTotalCount": {"nested": {"path": "ebayTrackList"} "aggs": {"sd_value": {"filter": {"terms": {"ebayTrackList.date": ["2018-04-03", "2018-04-02"]}} "aggs": {"sum_count": {"sum": {"field": "ebayTrackList.pageView"} }}}

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.