Hello,
I'm currently trying to "Group by" a Standard table ("HcmPersonCertificate"). Unfortunatly the resulting view isn't what I expected. This is the base Query where I want to Group by the fields "Person" and "CertificateType" in order to get the max "ExpirationDate":
On top of the quey I created a simple View:
The SQL-View in the DB, which is created from this view, isn't correct, because also the field "Expiraton Date" is in the "Group by" field list and no "max" is in the select field list:
How could I achieve that the view is with Group by "Person" and "CertificateType" and Max(ExpirationDate)? What is wrong?
Thanks in advance for any hint.
Sebastian
