[COMPASS-2919] pipeline builder doesn't support ISODate Created: 04/Jun/18  Updated: 29/Oct/23  Resolved: 07/Jun/18

Status: Closed
Project: Compass
Component/s: Aggregation pipeline, Compass
Affects Version/s: None
Fix Version/s: 1.14.0, 1.15.0

Type: Bug Priority: Major - P3
Reporter: Amit Jain Assignee: Alena Khineika
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Compass 1.14.0-beta.2 in Windows 10.


Sprint: Sprint Xzibit

 Description   

This affects 1.14.0-beta.2, which is not listed in the dropdown.

If we're searching the m101 cluster in 100YWeatherSmall.data for

{
  ts: ISODate("1984-01-01T00:00:00Z")
}

that will return 584 documents. But if we try to use the same query in a $match stage in the Aggregation pipeline builder, the builder won't let us preview the data because

> Expected "[" or AggregationStage but "{" found.

Both query & aggregation work in the mongo shell.

There don't appear to be any relevant messages in the browser console. Please let us know if you need any more information to debug this.


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