I have a TableRecord where I show different course details which has fields like CourseId, CourseName, Session and StartDate. I want to GroupBy using CourseID and CourseName and add a new Attribute say 'New_Date' to show the most past date amoung the startdate for each group.My aggregate is showing something like this
I want this to look like the following
Thanks
Hello Sundeep.
Your aggregate will be something like this.
Can you try?
Nuno Reis wrote:
Hi Nuno,
In the StartDateMin field, which date should I select? Is that of the entity? Can you please provide a screenshot of the field selection?
From which folder here should I select the StartDate?
When I select the StartDate from GetCourseData aggregate as StartDateMin value, I am getting the default date 01-01-1900 00:00:00
I assumed you already had an entity with the data.
After placing the entity Course in aggregate, I simply right-clicked Id and picked Min, right-clicked COurseId and picked Group By and so on.
It worked.Thanks Nuno.
The only issue was that I added a new attribute and then selected the StartDate from aggregate. I right clicked the StartDate in the aggregate and selected Min. Its working fine now.