[COMPASS-6339] 'Export query with filters' provides incorrect result size Created: 30/Nov/22  Updated: 29/Oct/23  Resolved: 27/Feb/23

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

Type: Bug Priority: Minor - P4
Reporter: Natasha Dilamani Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File image002.png     JPEG File ~WRD000.jpg    
Issue Links:
Duplicate
duplicates COMPASS-4537 Export Collection feature is ignoring... Closed
Documentation Changes: Not Needed

 Description   

Problem Statement/Rationale

When I am in a collection and want to export my filtered results, we have 2 options: Export query with filters or Export Full Collection. For example, Export query with filters — 374,300 results (Recommended). However, that number of results is incorrect - it is the size of the entire collection, not the size of the returned results from my filter. When I continue on and execute the export, as the data is exporting, the progress shows that the total number of documents to export as the total collection size, not the size of the filtered results that will actually be exported. For example, under the loading bar it says Export completed 374,300 / 374,300. But it should show the number of results returned by the filter, not the collection size. In the end, the correct number of documents gets exported, however the numbers that are being displayed is very misleading. **

Steps to Reproduce

You can try going into one of your collections, filtering the data, and then click on the Export Collection button. You will see the number of results returned for Export Query with Filters to be incorrect. Then proceed by clicking on Select Fields, then Select Output button, then browse for an output and click on Export. You will then see how under the green progress bar, the total number of documents to be exported is the total collection size, not the number of documents returned from the filter

Expected Results

I expect the total number of results returned for the Export query with filter options to be equal to the number of documents displaying after filtering. Same applies for the total number of documents under the export progress bar

Actual Results

The numbers being displayed are the total collection size, even though my filter returns a smaller number of documents



 Comments   
Comment by Natasha Dilamani [ 14/Dec/22 ]

Hi,

The update fixed the issue, thank you!

Natasha

From: Jessica Sigafoos (Jira) <jira@mongodb.org>
Sent: Wednesday, December 14, 2022 9:13 AM
To: Dilamani, Natasha <Natasha.Dilamani@mlp.com>
Subject: [EXTERNAL] [MongoDB-JIRA] Jessica Sigafoos mentioned you on COMPASS-6339 (Jira)

[Image removed by sender.]

[cid:image001.png@01D90FA2.DEABA610]

Jessica Sigafoos<https://jira.mongodb.org/secure/ViewProfile.jspa?name=jessica.sigafoos%40mongodb.com> mentioned you on [Bug] COMPASS-6339<https://jira.mongodb.org/browse/COMPASS-6339>

Re: 'Export query with filters' provides incorrect result size<https://jira.mongodb.org/browse/COMPASS-6339>

Natasha Dilamani<https://jira.mongodb.org/secure/ViewProfile.jspa?name=natasha.dilamani%40mlp.com> , are you still seeing this issue with the updated version of Compass? Thanks!

[Add Comment]<https://jira.mongodb.org/browse/COMPASS-6339#add-comment>

Add Comment<https://jira.mongodb.org/browse/COMPASS-6339#add-comment>

This message was sent from MongoDB's issue tracking system. To respond to this ticket, please login to jira.mongodb.org<https://jira.mongodb.org> using your JIRA, MongoDB Cloud Manager, or MongoDB Atlas credentials.

######################################################################

The information contained in this communication is confidential and

may contain information that is privileged or exempt from disclosure

under applicable law. If you are not a named addressee, please notify

the sender immediately and delete this email from your system.

If you have received this communication, and are not a named

recipient, you are hereby notified that any dissemination,

distribution or copying of this communication is strictly prohibited.

######################################################################

Comment by Jessica Sigafoos [ 14/Dec/22 ]

natasha.dilamani@mlp.com , are you still seeing this issue with the updated version of Compass? Thanks!

Comment by Natasha Dilamani [ 01/Dec/22 ]

I am using 1.26.1, will update my version. Thanks for letting me know

Comment by Anna Henningsen [ 01/Dec/22 ]

natasha.dilamani@mlp.com The issue you are reporting here has been resolve a while ago in Compass 1.27. Which Compass version are you using? If you are using a more recent version, can you attach a log file (https://www.mongodb.com/docs/compass/current/troubleshooting/logs/), as the ticket template suggests?

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