Hello,
I've got a two tables: A and A_Version
A_Version table stores a copy of A before each modification.
Table A:
ID
SomeOtherColumnToFilter
Table A_Version:
ID
ID_A
Version_Number
I would like to retrieve an AEntity collection with the latest versions taken from A_Version (the latest Version_Number). As usual I've defined an EntityCollection and prefetch path but unfortunateley I don't know the ID_A in a moment when prefetch path filter is defined. I need it (or maybe there is some other solution) to determine the max value of the version. How can I do that?
Best Regards,
MiloszeS