Have you tried the result of that SQL ? 2009/9/14 ulu <[email protected]>
> > 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 > > > -- 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 -~----------~----~----~----~------~----~------~--~---
