Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-4967

Create view from Aggregation contains no data

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Declined
    • Icon: Major - P3 Major - P3
    • No version
    • 1.28.1
    • Compass
    • 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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            irene.xie@hhs.texas.gov Irene Xie
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: