D365 - AOT Query + View with group by and Max()

(0) Share

Report

Posted on by Sebastian Aurand

1,650

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":

8156.GroupBy.jpg

On top of the quey I created a simple View:

1057.View.jpg

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:

8231.SQLView.jpg

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

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi Sebastian,

The easiest way to make it work is to get rid of the query and add the table from the query as a data source to the view.

Looks like it's some kind of bug of an aggregated query in view.

Was this reply helpful? Yes No
Sebastian Aurand 1,650 on at

Like (0)

Report

It works, thanks!

Was this reply helpful? Yes No