hi all
i want create hql for average from date
my code :
Code:
public static int GetAvgTime(int InboxId, DateTime StartTime, DateTime EndTime)
{
Criteria criteria = new Criteria();
criteria.Query = "select avg(result.FixTime-flt.CreateTime ) from Fault flt join flt.ReceivedFaults inbox join flt.Results result where result.State != SentToAnotherUnit AND flt.Stat=Done AND inbox.Id= :InboxId";
criteria.Parameters.Add("Id", InboxId);
criteria.Parameters.Add("id", InboxId);
DataFacade dFacade = new DataFacade();
return dFacade.GetCount(criteria);
}