Hey,
Is the following query possible with elastic search:
I have two types: company and category
- Company is a type containing fields like name, phone, keywords, location…
and also a special field called category-id which contains an id (number)
company {
name:truvo,
phone:(0032)123.32.42
keywords: yellow pages, white pages
…
category-id: 1234
}
- Category is a type containing an id (the category id mentioned above) and
a set of names for that category
category {
category-id:1234
names: software, applications
}
Now I want to do a query: give me all companies where the category is
software and it should return the list of companies in this category (so it
would include Truvo). ~ a join in sql
Of course I can merge the two types before indexing, but keeping it in two
separate types provides me the flexibility to update the listings (for
example adding a synonym computer programs to the category 1234) without the
need to reindex the companies.
I could of course do this also by doing two queries (the first one to
retrieve the categories, because it could be more than one category) and
then doing a second query using the result of the first query, but I would
like (id possible) to do this in one query.
Any suggestions?
thanks,
Bert
--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Using-result-of-one-query-in-another-query-tp3886873p3886873.html
Sent from the ElasticSearch Users mailing list archive at Nabble.com.