I want to create a view in AOT that does the same as the following query:select t1.ExecutionId
from DMFDefinitionGroupExecution t1
inner join ServiceParameters t2
on t1.DEFINITIONGROUP = t2.DEFINITIONGROUP
where t1.CREATEDDATETIME = (
from DMFDefinitionGroupExecution t2
where t1.DEFINITIONGROUP = t2.DEFINITIONGROUP)
group by t1.ExecutionId
but I have no idea on how to add that range with the max in the designer.
Any ideas on that?
Thanks in advance