All,
I'm really struggling to come up with the correct HQL for an object
configuration such as:
Transaction (singular)
-> TransactionItems (collection of TransactionItem)
--> SendAccount (singular property of a Transaction Item)
--> Entries (collection of Entry)
--> Timestamp (datetime property of an Entry)
I need to navigate the whole tree in a single HQL statement. Something
along the lines of:
FROM T
WHERE T.Active = true
AND exists (FROM T.TransactionItems TI WHERE elements
(TI.SendAccount.Entries) AS E WHERE E.Timestamp = ?)
This doesn't work by the way - throws an index out of range exception.
I can do this in SQL but I can't work out what the right sort of HQL
should be. I need to use a "subselect" type query (for other reasons
not listed here) and I'm sure "elements" is what I want, but I can't
find a syntax that gets past the HQL parser
--
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.
