|(no subject) [message #687499]
||Thu, 16 June 2011 19:16
| Martin Taal
Registered: July 2009
Here the answer I gave earlier but which disappeared in the void (there are apparently problems with the newsgroup/forum to sync up):|
I think you should make this a join to the MobileProvider entity (assuming that's the name), and use the special elements function, something like this:
select count(asset.ID) from Asset as asset, MobileProvider as mp where mp in elements(asset.StateInfo) and mp.Name='Vodafone'
Hibernate/HQL has some nice collection functions which you can use in the where clause.
Powered by FUDForum
. Page generated in 0.05644 seconds