MariaDB wrong SQL generated

Database Support
, , ,
#1

Hello Helical Team,

I am using Helical Insight EE versin 5.0. What I have observed is that when we use date wise sum of sales report generated is correct.
But when we apply Dbfunction to extract Week and WeekOfYear from date, then the data is getting repeated. SQLQuery generated is wrong. How to fix this issue?

Thank You,
Vema.

#2

Hello Vema,

For MariaDB related issue we need to add MariaDB mysql dialect in adhocSqlSettings.xml file as shown in the below image
Path of this file : “..\hi\hi-repository\System\Admin”

image

Thank You,
Helical Team.