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
1 comments
12:48 Jun 08, 2018
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
Show all comments