Simple and query

Elastic Stack Elasticsearch
1

Hi togehter,

i just try to make a simple query which gets the data from two fields with
an "AND" conjunction.

Looks like

"query":{
"filtered" : {
"query":[{

                "field":{
                            "Status":"defining"    
                },
                "field":{
                    "Project":"123"
            }
                }
            ]
        }

    }

But it just set the last field as parameter.

I also tried it with one field and a filter but it never had a working
syntax.
Does anybody have a hint for me?!

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.
For more options, visit https://groups.google.com/groups/opt_out.

2

Maybe you could post the server log?

Anyway, I believe you should use a boolean query:

"query":{
"bool" : {
must: [

                "field":{
                            "Status":"defining"
                },
                "field":{
                    "Project":"123"
            }

            ]
        }

    }

give or take some {'s or }'s

Jaap Taal

[ Q42 BV | tel 070 44523 42 | direct 070 44523 65 | http://q42.nl |
Waldorpstraat 17F, Den Haag | Vijzelstraat 72 unit 4.23, Amsterdam | KvK
30164662 ]

On Tue, Mar 26, 2013 at 11:15 AM, Jens Christian Groh groh@dtis.eu wrote:

Hi togehter,

i just try to make a simple query which gets the data from two fields with
an "AND" conjunction.

Looks like

"query":{
"filtered" : {
"query":[{

                "field":{
                            "Status":"defining"
                },
                "field":{
                    "Project":"123"
            }
                }
            ]
        }

    }

But it just set the last field as parameter.

I also tried it with one field and a filter but it never had a working
syntax.
Does anybody have a hint for me?!

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.
For more options, visit https://groups.google.com/groups/opt_out.

--
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.
For more options, visit https://groups.google.com/groups/opt_out.

3

Tanks for your answer,

I took the ".untouched" option and set filter to "term".
Now it is working.

Am Dienstag, 26. März 2013 11:15:09 UTC+1 schrieb Jens Christian Groh:

Hi togehter,

i just try to make a simple query which gets the data from two fields with
an "AND" conjunction.

Looks like

"query":{
"filtered" : {
"query":[{

                "field":{
                            "Status":"defining"    
                },
                "field":{
                    "Project":"123"
            }
                }
            ]
        }

    }

But it just set the last field as parameter.

I also tried it with one field and a filter but it never had a working
syntax.
Does anybody have a hint for me?!

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.
For more options, visit https://groups.google.com/groups/opt_out.