Page 1 of 2
MongoDB Where Clauses Not Used When Querying Data
Posted: Fri Jul 12, 2019 9:20 pm
by appclan
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
Re: MongoDB Where Clauses Not Used When Querying Data
Posted: Mon Jul 15, 2019 8:38 pm
by Lech Kulikowski
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.
Re: MongoDB Where Clauses Not Used When Querying Data
Posted: Tue Jul 16, 2019 3:09 pm
by appclan
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.
Re: MongoDB Where Clauses Not Used When Querying Data
Posted: Wed Jul 17, 2019 7:10 am
by Lech Kulikowski
Hello,
We need some time to investigate the issue.
Thank you.
Re: MongoDB Where Clauses Not Used When Querying Data
Posted: Thu Aug 01, 2019 3:42 pm
by appclan
Can I get a status on this bug?
Thanks.
Re: MongoDB Where Clauses Not Used When Querying Data
Posted: Tue Aug 06, 2019 9:43 pm
by Lech Kulikowski
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.
Re: MongoDB Where Clauses Not Used When Querying Data
Posted: Thu Aug 08, 2019 8:35 pm
by appclan
Thank you for the update.
Re: MongoDB Where Clauses Not Used When Querying Data
Posted: Fri Aug 09, 2019 12:45 pm
by Lech Kulikowski
Hello,
We will try to implement it in the next release.
Thank you.
Re: MongoDB Where Clauses Not Used When Querying Data
Posted: Mon Aug 19, 2019 8:39 pm
by appclan
Awesome! Looking forward to trying it out!
Re: MongoDB Where Clauses Not Used When Querying Data
Posted: Mon Aug 19, 2019 8:53 pm
by Lech Kulikowski
Hello,
Ok.
Please let us know if you need any additional help.
Thank you.