Anonymous

My feedback

  1. 637 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    8 comments  ·  Azure Search  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
    Anonymous commented  · 

    Don't know if elastic does this but I want to be able to do window aggregations ie row_number() over (partition by productId order by updateDate desc) and then select using a filter on the date and where the row_number function = 1 so that I can index a history of records but at any time select the ones that are relevant at a certain date
    e.g.
    productId, status, updateDate
    Prod1, 3, '2011-01-01'
    Prod1, 4, '2011-04-01'
    Prod2, 2, '2010-10-01'
    Prod2, 1, '2013-02-01'

    in my index
    so if I wanted to get products at 2011-02-01 I would see Prod1 with status 3 and Prod2 with status 2. If I wanted to get products at 2011-06-01 I would see Prod1 with status 4 and Prod2 with status 2 etc
    Is this possible even in elastic?

  2. 544 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Azure Search » Query - Search  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  3. 588 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  11 comments  ·  Azure Search » Indexing  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  4. 745 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    10 comments  ·  Azure Search » Indexing  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 
  5. 187 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Azure Search » Indexing  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 

Feedback and Knowledge Base