In Elasticsearch I'd like to index items of multiple types. Examples are "blog
posts" and "deals". All types in the index should be sorted according to their
publish date, with a single exception: deals are valid in a certain time span.
The sorting of deals within the complete list should NOT be based on publish
time but on the "valid until" timestamp. So the question is, how can I sort on
the publish date of the blog post and the "valid until" date of the deals, in a
single query?
*Raw example data*
12/06: Blog post 8
11/06: Blog post 7
09/06: Blog post 6
09/06: Deal 2
06/06: Blog post 5
03/06: Blog post 4
29/05: Blog post 3
27/05: Blog post 2
26/05: Deal 1
26/05: Blog post 1
The deal #2 is available from 09/06 - 23/06, deal #1 was available from 26/05 -
09/06 and so on (every x weeks n new deals valid for a T period of time,
possible overlap).
*Expected result*
This should be the result of the search:
09/06: Deal 2 // Valid until 23/06, so this should be on top
12/06: Blog post 8
11/06: Blog post 7
09/06: Blog post 6
26/05: Deal 1 // It was valid until 09/06, so place this just before the
blog post from 09/06
06/06: Blog post 5
03/06: Blog post 4
29/05: Blog post 3
27/05: Blog post 2
26/05: Blog post 1
To make things more difficult, I have to consider these things as well:
1. Pagination should work no matter of the paging size (shouln't be a big issue
I guess)
2. More types could be added in the future (shouln't be a big issue as well)
3. Other types (say, events) could have a same system, where another time span
("promotional period") will be used
4. All items can be tagged / categorized and it should be able to filter on
these tags and use faceted search, all having the same sorting constraints
It's the first time I dive into ES, so I am not sure if it clear to it's just a
matter of RTFM, but please give me a nudge in the right direction :)
--
Jurian
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/56737978-9303-408d-b7a6-cd515b2e40f2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
