+ Add post
Hi Community!
How are you?
How could I put together a query similar to that with ESQ on the server side? Can I use aggregation functions?
SELECT Max(l.CreatedOn), l.SmrRecordId FROM SmrLoggingRecord l JOIN [dbo].[Case] c ON l.SmrRecordId = c.Id AND c.UpriEstadoCasoId = '78346E42-83AD-4790-B901-DB750A1D157E' WHERE l.SmrColumnCaption = 'Estado del Caso' GROUP BY SmrRecordId
King Regards!
Ezequiel
Like
Hi,
There is good description here how to write such queries. When reading pay attention to "Adding columns to query" section there. You can not only use aggregation in queries but also can use aggregation in filters