Can't use WITH in SQL Server

Report Bugs
1

Hello Team,

This is URGENT.

I’ve connected our SQL Server database with Holistics and created a query model using my script, similar to how I used to work with MySQL. The query executed successfully, and I was able to retrieve the correct data.

image
image1148×817 75.1 KB

However, after creating the model, when I attempted to run the same query again from the model view, the error appeared.

image
image1543×752 61.5 KB

Please note that no changes were made to the query. I only executed it once to create the model, and then ran it again from the model view, which resulted in the error.

I also tested the query in my local SQL Server editor, and it works perfectly without any issues.

Additionally, I created a dataset and attempted to build a new report, but encountered the same error.

As a test, I removed the WITH statement from the script, and everything worked fine afterward.

This is a blocker for me, as I need to use SQL Server features such as WITH (CTEs) in my queries.

Could you please investigate this issue as soon as possible?

Thank you.

2

Hi Hamza,

Sorry about the issue.

There is indeed a limitation with SQL Server WITH clause in subqueries (Query Models) that our engineering team need to revise.

On the other hand, we also replied to your support ticket on April 7th regarding this issue.
Would you mind checking your inbox and spam inbox again? It could be more convenient to continue the discussion in the ticket.

3

Thank you for the updates … Please I’ll be waiting your updates regarding WITH statement in SQL Server.

I’ve more than 78 reports have this statement and it will be a big issue to change all of them to a normal select statement.

I appreciate if you can priorities this …

Best Regards,

5

Hi Hamza,

We are working on a patch and expect to release it in the next 1-2 weeks.
We will notify you when it is done.

In the meantime, please let us know if you need any assistance.

6

Hi @Hamza_Rashed1 ,

We would need a bit more time to work on this.
Probably 2 more weeks

I’ll let you know when the patch is done

7

Ok, please we still need this urgently before we start the new reports for the new clients in our system.

Thanks for your understaing

8

Hello and good morning.

Kindly any updates on this? Thank you for your support. Let me know please when this can be done please?

Thanks

9

Hi Hamza,

We’re sorry for this delay. The patch will be released within this week.

I’ll let you know when it’s released

Best,

10

I really appreciate that … Looking forward to hearing from you. Thank you so much

11

Hi Hamza,

We’ve released the patch, please try it on your side again.

If you encounter any query that does not work, please send the query over the ticket support and we will fix that.

Best