MongoDB Where Clauses Not Used When Querying Data

Stimulsoft Reports.JS discussion
appclan
Posts: 5
Joined: Fri Jul 12, 2019 9:11 pm

MongoDB Where Clauses Not Used When Querying Data

Post 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
Lech Kulikowski
Posts: 6245
Joined: Tue Mar 20, 2018 5:34 am

Re: MongoDB Where Clauses Not Used When Querying Data

Post 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.
appclan
Posts: 5
Joined: Fri Jul 12, 2019 9:11 pm

Re: MongoDB Where Clauses Not Used When Querying Data

Post 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.
Attachments
sampledata.zip
Sample data
(2.28 KiB) Downloaded 117 times
Lech Kulikowski
Posts: 6245
Joined: Tue Mar 20, 2018 5:34 am

Re: MongoDB Where Clauses Not Used When Querying Data

Post by Lech Kulikowski »

Hello,

We need some time to investigate the issue.

Thank you.
appclan
Posts: 5
Joined: Fri Jul 12, 2019 9:11 pm

Re: MongoDB Where Clauses Not Used When Querying Data

Post by appclan »

Can I get a status on this bug?
Thanks.
Lech Kulikowski
Posts: 6245
Joined: Tue Mar 20, 2018 5:34 am

Re: MongoDB Where Clauses Not Used When Querying Data

Post 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.
appclan
Posts: 5
Joined: Fri Jul 12, 2019 9:11 pm

Re: MongoDB Where Clauses Not Used When Querying Data

Post by appclan »

Thank you for the update.
Lech Kulikowski
Posts: 6245
Joined: Tue Mar 20, 2018 5:34 am

Re: MongoDB Where Clauses Not Used When Querying Data

Post by Lech Kulikowski »

Hello,

We will try to implement it in the next release.

Thank you.
appclan
Posts: 5
Joined: Fri Jul 12, 2019 9:11 pm

Re: MongoDB Where Clauses Not Used When Querying Data

Post by appclan »

Awesome! Looking forward to trying it out! :D :D
Lech Kulikowski
Posts: 6245
Joined: Tue Mar 20, 2018 5:34 am

Re: MongoDB Where Clauses Not Used When Querying Data

Post by Lech Kulikowski »

Hello,

Ok.
Please let us know if you need any additional help.

Thank you.
Post Reply