help w/ Criteria

denov · **Joined:** Fri May 30, 2008 3:17 pm **Posts:** 2

i'm havng a bit of time trying to convert this query to a Criteria. somebody please tell me if there's a better way than using a criteria.

Code:

SELECT * FROM tow
  WHERE towId IN (
    SELECT towId FROM towstatuschange
    WHERE towId NOT IN (select towId from towstatuschange
           where (newTowStatusId in (104,105) AND date < DATEADD(minute, -10, getdate())) group by towId) 
   GROUP BY towId
)

i have pojos for the Tow table and TowStatusChange table.

LaLiLuna · **Posted:** Sat May 31, 2008 7:56 am

Have a look at detachedcriteria to create subqueries with criteria. -> reference doc