I have an "Issue" table and an "Assignment" table. The assignment of an issue is tracked in the Assignment table with IssueId, UserId, AssignmentDate, etc. The Issue table does not have an AssigneeUserId field, but I would like the Issue entity to have an AssigneeUserId field. The Issue/Assignment relation is 1:n and I only want the latest assignment. I know I can drill down and filter to get the value, but can I attach it to the Issue entity (maybe when the entity initializes?).

Can you add a dynamic field to an entity? Is this the right approach? I have searched and couldn't find an example which leads me to my next question. Am I doing something bizarre? I'm an overlooking an obvious answer?

Thank in advance for your help, Jeff

If the relation was the opposite m:1 instead of 1:m, I would have suggested using "Filed mapped on related field"

But in your case, you may create a custom property within the generated entity class. (use the appropriate "user code region").

Then you may chose your way (WHEN) to populate this property. Normaly you should do a normal fetch with filters to get the needed value.