Distinct count sorting not working in Postgress

Database Support
, , ,
#1

Hello Helical Team,

Hello Team. I am using helical insight EE version 5.0. What I have observed is that when I am using distinct count and doing sorting on top of it, it is not working. It is giving incorrect result.

Thank You,
Netta.

#2

Hello Netta,

Open the file adhocSqlSettings.xml file present in the location like “..\hi\hi-repository\System\Admin”
Comment out the below highlighted line mentioning about PostgreSQLDialect

image

Then restart the server and try creating new report in private browsers.

Thank You,
Helical Insight.