Apply a group function on calculated field in a dataset

Question

In a Dataset, I can create a calculated fields with CONCAT function, it works. But if I add a group function like COUNT DISTINCT I have an error in generated SQL

Answer 1

Dear François,

The problem is related to the Hibernate library, and how we create HQL.

if you use another aggregate function it's work, e.g. SUM...

We are evaluating a workaround.

Best Regards

Angelo.

Comments

Thanx Angelo