ESQ Aggregation functions

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 0

Like

1 comments

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