Forums (Obsolete)

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?

Kentico Support

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

Top