Find all Filtered by Nested in elasticsearch

Question

I want to make a query, looking all equal to "something" but other than that I can filter by fields: "idcategoria", "idinstitucion" and "idtipooa".

fos_elastica:
clients:
    default: { host: localhost, port: 9200 }
indexes:
    website:
        client: default
        types:
             ofertas:
                 mappings:
                     id: { boost: 3 }
                     nombreoa: { analyzer: snowball }
                     titulo: {boost: 3}
                     duracion: {boost: 3}
                     uniduracion: {boost: 3}
                     email: {boost: 3}
                     caracteristicas: { analyzer: snowball }
                     requisitos: ~
                     planestudio: ~
                     matricula: {boost: 3}
                     cuota: {boost: 3}
                     estado: {boost: 3}
                     dirigidoa: {boost: 3}
                     url: {boost: 3}
                     idareaestudio:
                        type: "nested"
                        properties:
                            nombre: { boost: 5 }
                     idcategoria:
                        type: "nested"
                        properties:
                            nombre: { boost: 5 }
                     idinstitucion:
                        type: "nested"
                        properties:
                            nombreinstitucion: { boost: 5 }      
                            nombresede: { boost: 5 }
                     idmodalidadoa:
                        type: "nested"
                        properties:
                            nombre: { boost: 5 }  
                     idniveloa:
                        type: "nested"
                        properties:
                            nombre: { boost: 5 } 
                     idtipooa:
                        type: "nested"
                        properties:
                            nombre: { boost: 5 }                   
                 persistence:
                    driver: orm
                    model: FrontEnd\AplicacionBundle\Entity\Oa
                    provider: ~
                    finder: ~
                    repository: FrontEnd\AplicacionBundle\Repository\OaRepository

I tried:

> { 
"query": {
    "filtered": {
          "query":  {  "text": { "_all":   "Aboga"}},
   "filter": {  "term": { "idtipooa.nombre": "Universitaria" }}
}
}}

But it has not worked. Please if anyone can help ... Thank you!

I'll guess this is elastic search. If it is so, you should mention that. — TheHippo
– TheHippo, Commented May 6, 2013 at 15:02
Sorry but I don't quite get what you want to achieve. What would you expect as a result? — javanna
– javanna, Commented May 6, 2013 at 17:56
I need is to find a word in all content, but filter by idtipooa. — Rebe
– Rebe, Commented May 7, 2013 at 15:33

imotov · Accepted Answer · 2013-05-06 19:51:07Z

1

idtipooa is a nested field, so in order to search it you need to wrap your term filter into nested filter.

answered May 6, 2013 at 19:51

imotov

30.2k3 gold badges93 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Rebe Over a year ago

I tried: { "filtered" : { "query" : { "match_all" : {} }, "filter" : { "nested" : { "path" : "idtipooa", "query" : { "bool" : { "must" : [ { "match" : {"idtipooa.nombre" : "Universitaria"} } ] } }, "_cache" : true } } } }It has not worked

imotov Over a year ago

That should work. Please, add a complete example with some sample data to your question.

Rebe Over a year ago

{"_index":"website","_type":"ofertas","_id":"3","_score":0.32260805, "_source" : {"id":3,"nombreoa":"Abogacia","titulo":"Abogado","duracion":"5","uniduracion":"As","email":"[email protected]","caracteristicas":"El abitraje\n","matricula":"2196","cuota":2196,"estado":"V","dirigidoa":null,"url":null,"idareaestudio":{"nombre":"Abogacia"},"idcategoria":{"nombre":"Abogada"},"idinstitucion":{"nombreinstitucion":"UDE - Universidad de la Empresa","nombresede":"Central"},"idmodalidadoa":{"nombre":"Presencial"},"idniveloa":{"nombre":"Grado"},"idtipooa":{"nombre":"Carrera Universitaria"}}

imotov Over a year ago

Rebe, I just tested it with your data and pieces of your mapping - it works. gist.github.com/imotov/737176fd5a0f60730db8 Make sure that mapping is applied correctly to your index.

Rebe Over a year ago

I expected the results to be zero, because I consult "Universitaria" and not "Carrera Universitaria"

|

Collectives™ on Stack Overflow

Find all Filtered by Nested in elasticsearch

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related