Forums - Kentico CMS for ASP.NET

RSS Kentico.com website My account

Home

Forums

Blogs

Please note: The forums are currently intended for Kentico community. Although we monitor them time to time, we cannot guarantee a timely response. If you need a help with Kentico CMS, please feel free to send your message to support@kentico.com.

If you want to add new post or reply to post, please sign in.

Search:

Portal Engine Questions on portal engine and web parts.

Version 5.x > Portal Engine > TagCloud webpart: extract top N tag order by tagCount DESC and sort them by Name

View modes:


Member	mattia.biancardi-gmail - 11/10/2011 3:31:48 AM TagCloud webpart: extract top N tag order by tagCount DESC and sort them by Name Hi, I need to extract top N tag Order by TagCount DESC and then show them sort by TagName. Obviously using 2 order by conditions (ORDER BY TagCount DESC, TagName ASC) doesn't work as i need! Someone can help me? Reply \| Quote \| Subscribe to post

Kentico

kentico_janh - 11/10/2011 6:31:19 AM

RE:TagCloud webpart: extract top N tag order by tagCount DESC and sort them by Name

Hi,

I am afraid, that you won't be able to do that, because you are ordering only one sql query, so you can't preorder tags by a TagCount, select top N of them and then order them by a TagName.

The "order by" expression, that you mentioned, orders alphabetically only those tags, which have the same TagCount.

Best regards,
Jan Hermann

Reply | Quote | Subscribe to post