Unprocessed lexemes remain - MongoDB Data Source

Stimulsoft Reports.WEB discussion
Post Reply
jayro.boy
Posts: 10
Joined: Tue Aug 15, 2023 6:26 pm
Location: Brasil

Unprocessed lexemes remain - MongoDB Data Source

Post by jayro.boy »

Hello again!

I have been facing a problem when connecting to MongoDB on Reports.WEB.
If I just try to generate a report using unfiltered data, everything goes fine and I can see all the information. However, even the most basic queries, such as this one:
A query for all documents created in 2023 for my timezone
A query for all documents created in 2023 for my timezone
query_editor_stimulsoft.png (29.66 KiB) Viewed 9400 times

Result in the following error:
Parser error: Syntax error - Unprocessed lexemes remain
Parser error: Syntax error - Unprocessed lexemes remain
unprocessed_lexemes_stimulsoft.jpg (46.77 KiB) Viewed 9400 times


I have googled this but the only relevant result for the google search is a forum post from 2016, last answered in 2019, which states that the problem has been solved and was related to the NET version being used at the time.


Can anyone point me in the right direction?
Lech Kulikowski
Posts: 6271
Joined: Tue Mar 20, 2018 5:34 am

Re: Unprocessed lexemes remain - MongoDB Data Source

Post by Lech Kulikowski »

Hello,

Please clarify which version are you use?

Thank you.
diego.tj
Posts: 1
Joined: Fri Aug 18, 2023 5:40 pm

Re: Unprocessed lexemes remain - MongoDB Data Source

Post by diego.tj »

updated from version 2023.3.2 from 12 August 2023 and still have the same problem.

STIMULSOFT REPORTS.WEB
jayro.boy
Posts: 10
Joined: Tue Aug 15, 2023 6:26 pm
Location: Brasil

Re: Unprocessed lexemes remain - MongoDB Data Source

Post by jayro.boy »

Lech Kulikowski wrote: Fri Aug 18, 2023 3:59 pm Hello,

Please clarify which version are you use?

Thank you.
Hello!
stimulsoft_version.png
stimulsoft_version.png (18.4 KiB) Viewed 9352 times
Version 2023.3.2 from august 12,2023
Max Shamanov
Posts: 792
Joined: Tue Sep 07, 2021 10:11 am

Re: Unprocessed lexemes remain - MongoDB Data Source

Post by Max Shamanov »

Hello.

We have reproduced the issue and need some time to make an improvement.
We will let you know when we get any results.

As a workaround you can use variable with query.
Please check the attached images.

Thank you.
#12273
Attachments
Designer_MNFxOzRVRZ.png
Designer_MNFxOzRVRZ.png (77.69 KiB) Viewed 9330 times
Designer_tyE7rux4iA.png
Designer_tyE7rux4iA.png (87.15 KiB) Viewed 9330 times
jayro.boy
Posts: 10
Joined: Tue Aug 15, 2023 6:26 pm
Location: Brasil

Re: Unprocessed lexemes remain - MongoDB Data Source

Post by jayro.boy »

Thank you for the answer!
Lech Kulikowski
Posts: 6271
Joined: Tue Mar 20, 2018 5:34 am

Re: Unprocessed lexemes remain - MongoDB Data Source

Post by Lech Kulikowski »

Hello,

You are welcome.
Max Shamanov
Posts: 792
Joined: Tue Sep 07, 2021 10:11 am

Re: Unprocessed lexemes remain - MongoDB Data Source

Post by Max Shamanov »

Hello,

Were added some fixes and improvements in that direction.
Now the queries work without using variables.
Please check the next release build.

Thank you.
Post Reply