[COMPASS-4870] Add new values to ace autocompleter Created: 07/Jun/21  Updated: 27/Oct/21  Resolved: 10/Jun/21

Status: Closed
Project: Compass
Component/s: None
Affects Version/s: None
Fix Version/s: 1.27

Type: Task Priority: Major - P3
Reporter: Alena Khineika Assignee: Alena Khineika
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Problem/Incident
Epic Link: COMPASS-4391
Documentation Changes: Not Needed
Sprint: Iteration Edinburgh

 Description   

Add new expressions for date: https://docs.google.com/document/d/1mrnRdlXUgFMFIzGuO7c6Vkx9TurNkKjbqCXoSEOQO_A/edit#
https://docs.google.com/document/d/1zgvfbgD4ergTpA3BzOeWmHeGcDGC3ZBQUUrL95PuxYc/edit#heading=h.b1os3ai9s8t3

Add new window function stage and relevant accumulators:
https://docs.google.com/document/d/1IDbgaoEN9ttB9DNPk5mbRIT6S935QaL0HKlKGwOcSHE/edit#heading=h.gjhbqspr3hb9

The following keywords are related to the $setWindowFields stage: $count, $derivative, $integral, $covariancePop, $covarianceSamp, $expMovingAvg, $shift, $documentNumber, $rank, $denseRank

$count can be used in $group too.

Currently, we do not have the logic in place to show only relevant keywords for the stage. We check only for a supported version.


Generated at Wed Feb 07 22:37:41 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.