Complex nested query

11157 · September 11, 2014, 3:23am

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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/A98354E4-9C9F-43B2-9310-6355DE3D6F85%40gmail.com.
For more options, visit https://groups.google.com/d/optout.

vineeth_mohan_2 · September 11, 2014, 4:04am

Hello ,

First you need to declare field details as nested. -

Then do a bool query with the date range constrain and range constrain

Thanks
Vineeth

On Thu, Sep 11, 2014 at 8:53 AM, 闫旭 yancey1989@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+unsubscribe@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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAGdPd5kfRarPNNBctvYfHsk52tjD2rxv18aQGqq3Hz0i_2ZxVQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

11157 · September 11, 2014, 5:24am

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.vineethmohan@gmail.com 写道：

Hello ,

First you need to declare field details as nested. - Elasticsearch Platform — Find real-time answers at scale | Elastic

Then do a bool query with the date range constrain and range constrain

Thanks
Vineeth

On Thu, Sep 11, 2014 at 8:53 AM, 闫旭 yancey1989@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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/A98354E4-9C9F-43B2-9310-6355DE3D6F85%40gmail.com.
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAGdPd5kfRarPNNBctvYfHsk52tjD2rxv18aQGqq3Hz0i_2ZxVQ%40mail.gmail.com.
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/BAA9C6D6-8060-4F4E-B2F0-7764EAD2BCDB%40gmail.com.
For more options, visit https://groups.google.com/d/optout.

11157 · September 11, 2014, 11:34am

Anyone can help this?

Thanks && Best Regard!

在 2014年9月11日，13:24，闫旭 yancey1989@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.vineethmohan@gmail.com 写道：

Hello ,

First you need to declare field details as nested. - Elasticsearch Platform — Find real-time answers at scale | Elastic

Then do a bool query with the date range constrain and range constrain

Thanks
Vineeth

On Thu, Sep 11, 2014 at 8:53 AM, 闫旭 yancey1989@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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/A98354E4-9C9F-43B2-9310-6355DE3D6F85%40gmail.com.
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAGdPd5kfRarPNNBctvYfHsk52tjD2rxv18aQGqq3Hz0i_2ZxVQ%40mail.gmail.com.
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/F5848899-E506-470B-AA05-E6A2B1965986%40gmail.com.
For more options, visit https://groups.google.com/d/optout.

vineeth_mohan_2 · September 11, 2014, 4:12pm

Hello ,

I don't feel you can do this in a single call.
What i have in mind would be

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.
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, 闫旭 yancey1989@gmail.com wrote:

Anyone can help this?

Thanks && Best Regard!

在 2014年9月11日，13:24，闫旭 yancey1989@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.vineethmohan@gmail.com 写道：

Hello ,

First you need to declare field details as nested. -
Elasticsearch Platform — Find real-time answers at scale | Elastic

Then do a bool query with the date range constrain and range constrain

Thanks
Vineeth

On Thu, Sep 11, 2014 at 8:53 AM, 闫旭 yancey1989@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+unsubscribe@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+unsubscribe@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+unsubscribe@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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAGdPd5mH%2BSrgrkomvNh9-a-A5gDTjeXCO6DE8uWp32ruNbGPFA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

11157 · September 11, 2014, 5:18pm

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.vineethmohan@gmail.com 写道：

Hello ,

I don't feel you can do this in a single call.
What i have in mind would be

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.
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, 闫旭 yancey1989@gmail.com wrote:
Anyone can help this?

Thanks && Best Regard!

在 2014年9月11日，13:24，闫旭 yancey1989@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.vineethmohan@gmail.com 写道：

Hello ,

First you need to declare field details as nested. - Elasticsearch Platform — Find real-time answers at scale | Elastic

Then do a bool query with the date range constrain and range constrain

Thanks
Vineeth

On Thu, Sep 11, 2014 at 8:53 AM, 闫旭 yancey1989@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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/A98354E4-9C9F-43B2-9310-6355DE3D6F85%40gmail.com.
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAGdPd5kfRarPNNBctvYfHsk52tjD2rxv18aQGqq3Hz0i_2ZxVQ%40mail.gmail.com.
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/F5848899-E506-470B-AA05-E6A2B1965986%40gmail.com.

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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAGdPd5mH%2BSrgrkomvNh9-a-A5gDTjeXCO6DE8uWp32ruNbGPFA%40mail.gmail.com.
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CA49FB1A-E87E-4CB0-A5CF-355EF9C0147F%40gmail.com.
For more options, visit https://groups.google.com/d/optout.

11157 · September 12, 2014, 2:47am

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 yancey1989@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.vineethmohan@gmail.com 写道：

Hello ,

I don't feel you can do this in a single call.
What i have in mind would be

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.
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, 闫旭 yancey1989@gmail.com wrote:
Anyone can help this?

Thanks && Best Regard!

在 2014年9月11日，13:24，闫旭 yancey1989@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.vineethmohan@gmail.com 写道：

Hello ,

First you need to declare field details as nested. - Elasticsearch Platform — Find real-time answers at scale | Elastic

Then do a bool query with the date range constrain and range constrain

Thanks
Vineeth

On Thu, Sep 11, 2014 at 8:53 AM, 闫旭 yancey1989@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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/A98354E4-9C9F-43B2-9310-6355DE3D6F85%40gmail.com.
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAGdPd5kfRarPNNBctvYfHsk52tjD2rxv18aQGqq3Hz0i_2ZxVQ%40mail.gmail.com.
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/F5848899-E506-470B-AA05-E6A2B1965986%40gmail.com.

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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAGdPd5mH%2BSrgrkomvNh9-a-A5gDTjeXCO6DE8uWp32ruNbGPFA%40mail.gmail.com.
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/98C8607A-47D3-4DCA-A74B-901E5F6152E1%40gmail.com.
For more options, visit https://groups.google.com/d/optout.

vineeth_mohan_2 · September 12, 2014, 2:56am

Hello Yancey ,

Date aggregation -
Elasticsearch Platform — Find real-time answers at scale | Elastic
Sum aggregation -
Elasticsearch Platform — Find real-time answers at scale | Elastic
Nested aggregation -
Elasticsearch Platform — Find real-time answers at scale | Elastic

Thanks
Vineeth

On Fri, Sep 12, 2014 at 8:17 AM, yancey yancey1989@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 yancey1989@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.vineethmohan@gmail.com 写道：

Hello ,

I don't feel you can do this in a single call.
What i have in mind would be

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.

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, 闫旭 yancey1989@gmail.com wrote:

Anyone can help this?

Thanks && Best Regard!

在 2014年9月11日，13:24，闫旭 yancey1989@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.vineethmohan@gmail.com 写道：

Hello ,

First you need to declare field details as nested. -
Elasticsearch Platform — Find real-time answers at scale | Elastic

Then do a bool query with the date range constrain and range constrain

Thanks
Vineeth

On Thu, Sep 11, 2014 at 8:53 AM, 闫旭 yancey1989@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+unsubscribe@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+unsubscribe@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+unsubscribe@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+unsubscribe@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+unsubscribe@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+unsubscribe@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.

Topic		Replies	Views
Complex queries inside nested fields Elasticsearch	1	235	February 16, 2023
Sum nested values while applying match conditions Elasticsearch	3	5109	December 15, 2017
Query/Filter on Complex Object, Multiple Values Elasticsearch	2	508	July 5, 2017
Filtering nested documents Elasticsearch	5	562	January 8, 2018
Query on nested array fields Elasticsearch	2	381	March 3, 2020

Complex nested query

Related topics