Question

Group by in SQL How do I do that in Mendix?

2

I have 2 entities in my model called "issues" and "actions" The relation between them is 1: *, so one issue has many actions. Now I want to make a form which shows for each issue only the MOST RECENT action. Of cause a field "Add-date" is in the action entity. For each issue only the action with the latest/most recent add-date should be used.

asked 2011-01-27

Paul van Eulem

2 answers

Michel Weststrate · Answer 1 · 2011-01-27

Hi Paul,

To achieve that you need to add an 'most_recent' association from issue to action, which you update upon new actions. (You can use object events to achieve that)

Bart Tolen · Answer 2 · 2011-01-28

If it is just for presentation you can add a calculated attribute that uses a microflow to search and return the most recent action. This works per issue.