Page 1 of 1

Unprocessed lexemes remain - MongoDB Data Source

Posted: Fri Aug 18, 2023 2:28 pm
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 10231 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 10231 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?

Re: Unprocessed lexemes remain - MongoDB Data Source

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

Please clarify which version are you use?

Thank you.

Re: Unprocessed lexemes remain - MongoDB Data Source

Posted: Fri Aug 18, 2023 5:55 pm
by diego.tj
updated from version 2023.3.2 from 12 August 2023 and still have the same problem.

STIMULSOFT REPORTS.WEB

Re: Unprocessed lexemes remain - MongoDB Data Source

Posted: Mon Aug 21, 2023 1:02 pm
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 10183 times
Version 2023.3.2 from august 12,2023

Re: Unprocessed lexemes remain - MongoDB Data Source

Posted: Tue Aug 22, 2023 10:52 am
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

Re: Unprocessed lexemes remain - MongoDB Data Source

Posted: Tue Aug 22, 2023 12:45 pm
by jayro.boy
Thank you for the answer!

Re: Unprocessed lexemes remain - MongoDB Data Source

Posted: Wed Aug 23, 2023 10:33 pm
by Lech Kulikowski
Hello,

You are welcome.

Re: Unprocessed lexemes remain - MongoDB Data Source

Posted: Thu Aug 24, 2023 8:03 am
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.