This is SQL, I was trying to achieve this via Criteria API or HQL. Anyway, after I sent the message (tooka while to get approved), I managed to find a solution..
ulu On 12 сен, 05:54, Fabio Maulo <[email protected]> wrote: > And you have idea about this?SELECT Count(Value) FROM PageTags GROUP BY > Value > > 2009/9/11 ulu <[email protected]> > > > > > > > Hi, > > > I'm trying to fetch a list of values, rather than entities. > > Specifically, I've got a Page entity with a set of tags, atag being a > > string, and I'm trying to do something similar to > > SELECT Count(Value) FROM PageTags GROUP BY Value > > > My mapping is: > > <set name="Tags" table="PageTags" > > access="nosetter.camelcase- > > underscore"> > > <key column="PageId" /> > > <element column="Value" type="String" /> > > </set> > > > I tried: > > _session.CreateQuery("select page.Tags from ServicePageStructure > > page").List() > > and > > _session.CreateCriteria(Of QnA)().CreateCriteria("Tags") > > but have no idea what to try next. > > > Please help > > > thanks a lot > > ulu > > -- > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
