Either a where attribute on the class if that clause is always going to be present, or just stick it on whatever querying mechanism you're using (criteria or hql).
On Fri, Mar 13, 2009 at 6:01 PM, epitka <[email protected]> wrote: > > with join element? Just trying it out right now, but don't know how to > plug this piece in > "getutcdate() between ClientAcctType.EffDt and ClientAcctType.ExpDt" > > On Mar 13, 12:30 pm, Ayende Rahien <[email protected]> wrote: > > Joined entity? > > > > On Fri, Mar 13, 2009 at 9:38 PM, epitka <[email protected]> wrote: > > > > > Can anybody point out some example on how to map this query to one > > > entity? > > > > > select > > > Client.*, > > > ClientAcctType.AcctTypeCd as CurrentAccountStatusCode > > > from Client > > > inner join ClientAcctType on Client.ClientId = ClientAcctType.ClientId > > > where Client.ClientId = 6550056 > > > and getutcdate() between ClientAcctType.EffDt and ClientAcctType.ExpDt > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
