MongoDB Where Clauses Not Used When Querying Data
MongoDB Where Clauses Not Used When Querying Data
I'm evaluating the reporting software for use with a MongoDb 4.0 server. I'm able to connect and see all of our collections as a data source. I'm also able to view the data. However when I try to use a where clause with the data, it does not appear to be used. I even added a bad query to see if a validation would be trigger. It just gave me back all results.
The query I'm attempting to use is very simple.
{"_id": "A LONG GUID HERE" }
I tried the same query with a MongoDB 3.4 installation and got the same results.
Im using version 2019.3.2
The query I'm attempting to use is very simple.
{"_id": "A LONG GUID HERE" }
I tried the same query with a MongoDB 3.4 installation and got the same results.
Im using version 2019.3.2
-
- Posts: 6254
- Joined: Tue Mar 20, 2018 5:34 am
Re: MongoDB Where Clauses Not Used When Querying Data
Hello,
Please check the following video:
https://www.youtube.com/watch?v=oCfpMlAbkXY
If the issue still present, please send us a sample report with test data for analysis.
Thank you.
Please check the following video:
https://www.youtube.com/watch?v=oCfpMlAbkXY
If the issue still present, please send us a sample report with test data for analysis.
Thank you.
Re: MongoDB Where Clauses Not Used When Querying Data
Thank you, yes I saw the video. I still have the issue. I've attached a sample dataset and the same report with the issue.
Let me know if you need anything else.
Let me know if you need anything else.
- Attachments
-
- sampledata.zip
- Sample data
- (2.28 KiB) Downloaded 117 times
-
- Posts: 6254
- Joined: Tue Mar 20, 2018 5:34 am
Re: MongoDB Where Clauses Not Used When Querying Data
Hello,
We need some time to investigate the issue.
Thank you.
We need some time to investigate the issue.
Thank you.
Re: MongoDB Where Clauses Not Used When Querying Data
Can I get a status on this bug?
Thanks.
Thanks.
-
- Posts: 6254
- Joined: Tue Mar 20, 2018 5:34 am
Re: MongoDB Where Clauses Not Used When Querying Data
Hello,
We work hard on this problem and do our best to do it as fast as possible. We will let you know when the solution is available.
Thank you.
We work hard on this problem and do our best to do it as fast as possible. We will let you know when the solution is available.
Thank you.
Re: MongoDB Where Clauses Not Used When Querying Data
Thank you for the update.
-
- Posts: 6254
- Joined: Tue Mar 20, 2018 5:34 am
Re: MongoDB Where Clauses Not Used When Querying Data
Hello,
We will try to implement it in the next release.
Thank you.
We will try to implement it in the next release.
Thank you.
Re: MongoDB Where Clauses Not Used When Querying Data
Awesome! Looking forward to trying it out!
-
- Posts: 6254
- Joined: Tue Mar 20, 2018 5:34 am
Re: MongoDB Where Clauses Not Used When Querying Data
Hello,
Ok.
Please let us know if you need any additional help.
Thank you.
Ok.
Please let us know if you need any additional help.
Thank you.