Details
-
Bug
-
Resolution: Declined
-
Major - P3
-
1.28.1
-
None
-
Microsoft Azure CosmosDB (Mongo API)
-
Not Needed
Description
Problem Statement/Rationale
I am using Azure CosmosDB (mongo API 3.6) as the backend database for my application. When I am using MongoDB Compass to create a view after building the aggregation pipeline, the view contains no data. The same test on my local mongo database doesn't have this issue so I am thinking it might be a bug when create the view from CosmosDB (mongo API 3.6).
Steps to Reproduce
Create a collection from CosmosDB (mongo API 3.6). Insert the data to this new collection with a datetime field. Then on the aggregation tab, build a stage with $match and have the datetime in a range , for example, using the following code {
'datetime': {
$lt: ISODate("2021-02-01T00:00:00.000Z"),
$gte: ISODate("2021-01-01T00:00:00.000Z")
}
}
Make sure you have the data after applying the aggregation. Then save this as a view. After saving the view, the view should contain the resultset. But when I used the same method on CosmosDB (Mongo API 3.6), I am not seeing any data from the view.
Expected Results
What do you expect to happen?
Actual Results
What do you observe is happening?
Additional Notes
Any additional information that may be useful to include.