Custom AML - Select="max(generation)" - How to use SQL MAX in query?

Chris, In this particular scenario, I am trying to return every revision of the current part at its highest relevant current generation. e.g. Rev 1 gen 1 Rev 1 gen 2 Rev 2 gen 1 Rev 2 gen 2 Rev 2 gen 3 returning Rev 1 Gen 2 Rev 2 Gen 3 This default behavior of returning only the most recent active result is proving to be hard to work around. At this point, I'm not sure what else to do aside from writing a server side method that query with raw SQL. In the meantime, I now have a bug in that a object is refusing to increment its major rev.