I am using this query: $params = ['index' => '201706','type' => 'facebook', 'body' => ['query' => ['bool' => ['must' => ['filter' => ['range' => ['created_at' => ['gte' => '2017-06-25 01:00:00','lte' => '2017-09-30 08:00:00'] ]] ] ]]]]; Please correct this. Thanks Akhil

I see. Remove the must part I think. Like $params = [‘index’ => ‘201706’,‘type’ => ‘facebook’, ‘body’ => [‘query’ => [‘bool’ => [‘filter’ => [‘range’ => [‘created_at’ => [‘gte’ => ‘2017-06-25 01:00:00’,‘lte’ => ‘2017-09-30 08:00:00’] ]] ] ]]];

I need an elasticsearch php client query for range filter

Elastic Stack Elasticsearch

dadoonet (David Pilato) August 11, 2017, 10:39am 2

And? What's wrong? Date format issue I guess?

2017-06-25 01:00:00 should may be something like 2017-06-25T01:00:00.

But it would be better if you can test it first with Kibana Dev Console and then if it works, try to fix the PHP problem itself.
If it does not work, share the Kibana script.

Topic		Replies	Views
Elasticsearch php client range and search Elasticsearch	3	3484	September 18, 2017
I need an elasticsearch php client query for range and search filter Elasticsearch	4	1296	September 11, 2017
Elasticsearch php client search and range query Elasticsearch	3	1112	September 11, 2017
Using filters in ElasticSearch - PHP Elasticsearch	3	2432	July 6, 2017
Problem with query date elastichsearch with php Elasticsearch	1	364	November 23, 2020

I need an elasticsearch php client query for range filter

Related topics