Hello Yancey ,
1. Date aggregation - http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-aggregations-bucket-datehistogram-aggregation.html#search-aggregations-bucket-datehistogram-aggregation 2. Sum aggregation - http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-aggregations-metrics-sum-aggregation.html 3. Nested aggregation - http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-aggregations-bucket-nested-aggregation.html Thanks Vineeth On Fri, Sep 12, 2014 at 8:17 AM, yancey <yancey1...@gmail.com> wrote: > Hi! > I can not find how to filter date based on aggregation result in > documents. btw, can i use function do this? > > Thanks && Best Regard! > > > > 在 2014年9月12日,1:18,yancey <yancey1...@gmail.com> 写道: > > Vineeth! > > Thanks for your reply! I’ll try your solution,hope this can solve my > problem. > > > Thanks && Best Regard! > > > > 在 2014年9月12日,0:12,vineeth mohan <vm.vineethmo...@gmail.com> 写道: > > Hello , > > I don't feel you can do this in a single call. > What i have in mind would be > > > 1. Run a two level aggregation query with date histogram aggregation > on first level with date and term aggregation on second with sum > aggregation on prize field on second level. You might need to use nested > aggregation also here. > 2. Once you get the results , choose the dates based on the criteria , > i.e. sum of prize more than 300. With the dates you are interested in , > fire the next query which has all interesting date ranges as range query. > > Thanks > Vineeth > > On Thu, Sep 11, 2014 at 5:04 PM, 闫旭 <yancey1...@gmail.com> wrote: > >> Anyone can help this? >> >> Thanks && Best Regard! >> >> 在 2014年9月11日,13:24,闫旭 <yancey1...@gmail.com> 写道: >> >> Thank you ! But nested bool query can not plus all price with the data >> range. how can i do this?? >> >> Thx again. >> >> Thanks && Best Regard! >> >> 在 2014年9月11日,12:04,vineeth mohan <vm.vineethmo...@gmail.com> 写道: >> >> Hello , >> >> >> First you need to declare field details as nested. - >> http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/mapping-nested-type.html#mapping-nested-type >> >> Then do a bool query with the date range constrain and range constrain >> >> Thanks >> Vineeth >> >> On Thu, Sep 11, 2014 at 8:53 AM, 闫旭 <yancey1...@gmail.com> wrote: >> >>> Dear All! >>> >>> I have a problem with a complex nested query >>> the docs like this: >>> _id:1 >>> { >>> "detail":[ >>> { >>> "date":"2014-09-01", >>> "price”:50 >>> }, >>> { >>> "date":"2014-09-02", >>> "price”:100 >>> }, >>> { >>> "date":"2014-09-03", >>> "price":100 >>> }, >>> { >>> "date":"2014-09-04", >>> "price":200 >>> } >>> ] >>> >>> } >>> _id:2 >>> { >>> "detail":[ >>> { >>> "date":"2014-09-01", >>> "price":100 >>> }, >>> { >>> "date":"2014-09-02", >>> "price":200 >>> }, >>> { >>> "date":"2014-09-03", >>> "price":300 >>> }, >>> { >>> "date":"2014-09-04", >>> "price":200 >>> } >>> ] >>> >>> } >>> I will filter the docs with “date in [2014-09-01, 2014-09-03] and >>> sum(price) > 300”. >>> I only find some way with “aggregation”, but it can only stat the sum of >>> all docs. >>> >>> How Can I solve the problem?? >>> >>> >>> Thanks && Best Regard! >>> >>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "elasticsearch" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to elasticsearch+unsubscr...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/elasticsearch/A98354E4-9C9F-43B2-9310-6355DE3D6F85%40gmail.com >>> <https://groups.google.com/d/msgid/elasticsearch/A98354E4-9C9F-43B2-9310-6355DE3D6F85%40gmail.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "elasticsearch" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to elasticsearch+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/elasticsearch/CAGdPd5kfRarPNNBctvYfHsk52tjD2rxv18aQGqq3Hz0i_2ZxVQ%40mail.gmail.com >> <https://groups.google.com/d/msgid/elasticsearch/CAGdPd5kfRarPNNBctvYfHsk52tjD2rxv18aQGqq3Hz0i_2ZxVQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> >> >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "elasticsearch" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to elasticsearch+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/elasticsearch/F5848899-E506-470B-AA05-E6A2B1965986%40gmail.com >> <https://groups.google.com/d/msgid/elasticsearch/F5848899-E506-470B-AA05-E6A2B1965986%40gmail.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to elasticsearch+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/CAGdPd5mH%2BSrgrkomvNh9-a-A5gDTjeXCO6DE8uWp32ruNbGPFA%40mail.gmail.com > <https://groups.google.com/d/msgid/elasticsearch/CAGdPd5mH%2BSrgrkomvNh9-a-A5gDTjeXCO6DE8uWp32ruNbGPFA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > > > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to elasticsearch+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/98C8607A-47D3-4DCA-A74B-901E5F6152E1%40gmail.com > <https://groups.google.com/d/msgid/elasticsearch/98C8607A-47D3-4DCA-A74B-901E5F6152E1%40gmail.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAGdPd5maa-ubX%3DgOuM_ghOe_AG2oywJo5kfYiM6rekXDY6UVhA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.