Simple query string does not work

Dan1 · September 10, 2014, 7:24pm

Hi Guys,

I have a simple query which is not working. I am using the same query on
another server with the same mapping; where it does work.
Everything else is working like a charm.

I am talking about the following query.
The problem is to be found when I using the query > field > tags query.
When I do not use this part, everything works fine.

Array
(
[from] => 0
[size] => 100000
[query] => Array
(
* [field] => Array
(
[tags] => blaat
)
*
)

[filter] => Array
    (
        [and] => Array
            (
                [0] => Array
                    (
                        [term] => Array
                            (
                                [representative] => 1
                            )

                    )

                [1] => Array
                    (
                        [term] => Array
                            (
                                [is_gift] => 0
                            )

                    )

                [2] => Array
                    (
                        [term] => Array
                            (
                                [active] => 1
                            )

                    )

                [3] => Array
                    (
                        [terms] => Array
                            (
                                [website_ids] => Array
                                    (
                                        [0] => 1
                                    )

                                [execution] => and
                            )

                    )

            )

    )

)

The mapping is as follows:

"product" : {
"properties" : {
"action" : {
"type" : "string"
},
"active" : {
"type" : "string"
},
"brand_ids" : {
"type" : "string"
},* "tags" : {
"type" : "string"
},*
.....

When I index an item I am using the following part:

Array
(
[2359] => Array
(
....
* [tags] => blaat, another blaat, etc*
....

Maby an installation confuguring issue?

Does anyone have a clue?

Thanks!

--
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/a18a812b-3d73-47c6-b7d3-53b969c71d85%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Dan1 · September 11, 2014, 12:20pm

Nobody?

Op woensdag 10 september 2014 21:24:19 UTC+2 schreef Dan:

Hi Guys,

I have a simple query which is not working. I am using the same query on
another server with the same mapping; where it does work.
Everything else is working like a charm.

I am talking about the following query.
The problem is to be found when I using the query > field > tags query.
When I do not use this part, everything works fine.

Array
(
[from] => 0
[size] => 100000
[query] => Array
(
* [field] => Array
(
[tags] => blaat
)
*
)
[filter] => Array
    (
        [and] => Array
            (
                [0] => Array
                    (
                        [term] => Array
                            (
                                [representative] => 1
                            )

                    )

                [1] => Array
                    (
                        [term] => Array
                            (
                                [is_gift] => 0
                            )

                    )

                [2] => Array
                    (
                        [term] => Array
                            (
                                [active] => 1
                            )

                    )

                [3] => Array
                    (
                        [terms] => Array
                            (
                                [website_ids] => Array
                                    (
                                        [0] => 1
                                    )

                                [execution] => and
                            )

                    )

            )

    )
)

The mapping is as follows:

"product" : {
"properties" : {
"action" : {
"type" : "string"
},
"active" : {
"type" : "string"
},
"brand_ids" : {
"type" : "string"
},* "tags" : {
"type" : "string"
},*
.....

When I index an item I am using the following part:

Array
(
[2359] => Array
(
....
* [tags] => blaat, another blaat, etc*
....

Maby an installation confuguring issue?

Does anyone have a clue?

Thanks!

--
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/574351f6-a7ea-4b60-8dd4-3a5dea2f4d3b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

vineeth_mohan_2 · September 11, 2014, 1:07pm

Hello Dan ,

Can you paste the above as JSON.
I am not exactly able to make out what is the query.

Thanks
Vineeth

On Thu, Sep 11, 2014 at 5:50 PM, Dan danny@adena.nl wrote:

Nobody?

Op woensdag 10 september 2014 21:24:19 UTC+2 schreef Dan:
Hi Guys,

I have a simple query which is not working. I am using the same query on
another server with the same mapping; where it does work.
Everything else is working like a charm.

I am talking about the following query.
The problem is to be found when I using the query > field > tags query.
When I do not use this part, everything works fine.

Array
(
[from] => 0
[size] => 100000
[query] => Array
(
* [field] => Array
(
[tags] => blaat
)
*
)
[filter] => Array
    (
        [and] => Array
            (
                [0] => Array
                    (
                        [term] => Array
                            (
                                [representative] => 1
                            )

                    )

                [1] => Array
                    (
                        [term] => Array
                            (
                                [is_gift] => 0
                            )

                    )

                [2] => Array
                    (
                        [term] => Array
                            (
                                [active] => 1
                            )

                    )

                [3] => Array
                    (
                        [terms] => Array
                            (
                                [website_ids] => Array
                                    (
                                        [0] => 1
                                    )

                                [execution] => and
                            )

                    )

            )

    )
)

The mapping is as follows:

"product" : {
"properties" : {
"action" : {
"type" : "string"
},
"active" : {
"type" : "string"
},
"brand_ids" : {
"type" : "string"
},* "tags" : {
"type" : "string"
},*
.....

When I index an item I am using the following part:

Array
(
[2359] => Array
(
....
* [tags] => blaat, another blaat, etc*
....

Maby an installation confuguring issue?

Does anyone have a clue?

Thanks!

--
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/574351f6-a7ea-4b60-8dd4-3a5dea2f4d3b%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/574351f6-a7ea-4b60-8dd4-3a5dea2f4d3b%40googlegroups.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/CAGdPd5%3DLDzK%2BDQJY-VTsfqq6_64yr%2Bm1y5oC915Hus%2BOONA4bw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Dan1 · September 11, 2014, 4:12pm

Hi Vineeth,

Thanks for your reply.

{"from":0,"size":100000,"query":{"field":{"tags":"blaat"}},"filter":{"and":[{"term":{"representative":1}},{"term":{"is_gift":0}},{"term":{"active":1}},{"terms":{"website_ids":[1],"execution":"and"}}]}}

Is this enough?

Thanks!

Op donderdag 11 september 2014 15:08:05 UTC+2 schreef vineeth mohan:

Hello Dan ,

Can you paste the above as JSON.
I am not exactly able to make out what is the query.

Thanks
Vineeth

On Thu, Sep 11, 2014 at 5:50 PM, Dan <da...@adena.nl <javascript:>> wrote:
Nobody?

Op woensdag 10 september 2014 21:24:19 UTC+2 schreef Dan:
Hi Guys,

I have a simple query which is not working. I am using the same query on
another server with the same mapping; where it does work.
Everything else is working like a charm.

I am talking about the following query.
The problem is to be found when I using the query > field > tags query.
When I do not use this part, everything works fine.

Array
(
[from] => 0
[size] => 100000
[query] => Array
(
* [field] => Array
(
[tags] => blaat
)
*
)
[filter] => Array
    (
        [and] => Array
            (
                [0] => Array
                    (
                        [term] => Array
                            (
                                [representative] => 1
                            )

                    )

                [1] => Array
                    (
                        [term] => Array
                            (
                                [is_gift] => 0
                            )

                    )

                [2] => Array
                    (
                        [term] => Array
                            (
                                [active] => 1
                            )

                    )

                [3] => Array
                    (
                        [terms] => Array
                            (
                                [website_ids] => Array
                                    (
                                        [0] => 1
                                    )

                                [execution] => and
                            )

                    )

            )

    )
)

The mapping is as follows:

"product" : {
"properties" : {
"action" : {
"type" : "string"
},
"active" : {
"type" : "string"
},
"brand_ids" : {
"type" : "string"
},* "tags" : {
"type" : "string"
},*
.....

When I index an item I am using the following part:

Array
(
[2359] => Array
(
....
* [tags] => blaat, another blaat, etc*
....

Maby an installation confuguring issue?

Does anyone have a clue?

Thanks!

--
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 elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/574351f6-a7ea-4b60-8dd4-3a5dea2f4d3b%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/574351f6-a7ea-4b60-8dd4-3a5dea2f4d3b%40googlegroups.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/94e06349-b707-4b79-acd6-51ea41358a24%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

vineeth_mohan_2 · September 11, 2014, 4:23pm

Hello Dan ,

The format of the entire query is wrong.
You need to at-least specify the type of query that you are using.
In this case , wild card query would be the best fit.

Thanks
Vineeth

On Thu, Sep 11, 2014 at 9:42 PM, Dan danny@adena.nl wrote:

Hi Vineeth,

Thanks for your reply.

{"from":0,"size":100000,"query":{"field":{"tags":"blaat"}},"filter":{"and":[{"term":{"representative":1}},{"term":{"is_gift":0}},{"term":{"active":1}},{"terms":{"website_ids":[1],"execution":"and"}}]}}

Is this enough?

Thanks!

Op donderdag 11 september 2014 15:08:05 UTC+2 schreef vineeth mohan:
Hello Dan ,

Can you paste the above as JSON.
I am not exactly able to make out what is the query.

Thanks
Vineeth

On Thu, Sep 11, 2014 at 5:50 PM, Dan da...@adena.nl wrote:
Nobody?

Op woensdag 10 september 2014 21:24:19 UTC+2 schreef Dan:
Hi Guys,

I have a simple query which is not working. I am using the same query
on another server with the same mapping; where it does work.
Everything else is working like a charm.

I am talking about the following query.
The problem is to be found when I using the query > field > tags query.
When I do not use this part, everything works fine.

Array
(
[from] => 0
[size] => 100000
[query] => Array
(
* [field] => Array
(
[tags] => blaat
)
*
)
[filter] => Array
    (
        [and] => Array
            (
                [0] => Array
                    (
                        [term] => Array
                            (
                                [representative] => 1
                            )

                    )

                [1] => Array
                    (
                        [term] => Array
                            (
                                [is_gift] => 0
                            )

                    )

                [2] => Array
                    (
                        [term] => Array
                            (
                                [active] => 1
                            )

                    )

                [3] => Array
                    (
                        [terms] => Array
                            (
                                [website_ids] => Array
                                    (
                                        [0] => 1
                                    )

                                [execution] => and
                            )

                    )

            )

    )
)

The mapping is as follows:

"product" : {
"properties" : {
"action" : {
"type" : "string"
},
"active" : {
"type" : "string"
},
"brand_ids" : {
"type" : "string"
},* "tags" : {
"type" : "string"
},*
.....

When I index an item I am using the following part:

Array
(
[2359] => Array
(
....
* [tags] => blaat, another blaat, etc*
....

Maby an installation confuguring issue?

Does anyone have a clue?

Thanks!

--
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 elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/574351f6-a7ea-4b60-8dd4-3a5dea2f4d3b%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/574351f6-a7ea-4b60-8dd4-3a5dea2f4d3b%40googlegroups.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/94e06349-b707-4b79-acd6-51ea41358a24%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/94e06349-b707-4b79-acd6-51ea41358a24%40googlegroups.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/CAGdPd5n3-vN%3D1OcRLQ0akx-hkbF8Ynga8Qmhh%2BAcXdHf5LyA7g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Dan1 · September 12, 2014, 5:57am

Thanks!! Thats it.

Op donderdag 11 september 2014 18:23:31 UTC+2 schreef vineeth mohan:

Hello Dan ,

The format of the entire query is wrong.
You need to at-least specify the type of query that you are using.
In this case , wild card query would be the best fit.

Thanks
Vineeth

On Thu, Sep 11, 2014 at 9:42 PM, Dan <da...@adena.nl <javascript:>> wrote:
Hi Vineeth,

Thanks for your reply.

{"from":0,"size":100000,"query":{"field":{"tags":"blaat"}},"filter":{"and":[{"term":{"representative":1}},{"term":{"is_gift":0}},{"term":{"active":1}},{"terms":{"website_ids":[1],"execution":"and"}}]}}

Is this enough?

Thanks!

Op donderdag 11 september 2014 15:08:05 UTC+2 schreef vineeth mohan:
Hello Dan ,

Can you paste the above as JSON.
I am not exactly able to make out what is the query.

Thanks
Vineeth

On Thu, Sep 11, 2014 at 5:50 PM, Dan da...@adena.nl wrote:
Nobody?

Op woensdag 10 september 2014 21:24:19 UTC+2 schreef Dan:
Hi Guys,

I have a simple query which is not working. I am using the same query
on another server with the same mapping; where it does work.
Everything else is working like a charm.

I am talking about the following query.
The problem is to be found when I using the query > field > tags
query.
When I do not use this part, everything works fine.

Array
(
[from] => 0
[size] => 100000
[query] => Array
(
* [field] => Array
(
[tags] => blaat
)
*
)
[filter] => Array
    (
        [and] => Array
            (
                [0] => Array
                    (
                        [term] => Array
                            (
                                [representative] => 1
                            )

                    )

                [1] => Array
                    (
                        [term] => Array
                            (
                                [is_gift] => 0
                            )

                    )

                [2] => Array
                    (
                        [term] => Array
                            (
                                [active] => 1
                            )

                    )

                [3] => Array
                    (
                        [terms] => Array
                            (
                                [website_ids] => Array
                                    (
                                        [0] => 1
                                    )

                                [execution] => and
                            )

                    )

            )

    )
)

The mapping is as follows:

"product" : {
"properties" : {
"action" : {
"type" : "string"
},
"active" : {
"type" : "string"
},
"brand_ids" : {
"type" : "string"
},* "tags" : {
"type" : "string"
},*
.....

When I index an item I am using the following part:

Array
(
[2359] => Array
(
....
* [tags] => blaat, another blaat, etc*
....

Maby an installation confuguring issue?

Does anyone have a clue?

Thanks!

--
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 elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/574351f6-a7ea-4b60-8dd4-3a5dea2f4d3b%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/574351f6-a7ea-4b60-8dd4-3a5dea2f4d3b%40googlegroups.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 elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/94e06349-b707-4b79-acd6-51ea41358a24%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/94e06349-b707-4b79-acd6-51ea41358a24%40googlegroups.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/291235af-f1fd-4e0e-a199-21bc7563eae4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.