Design and CSS styles
Version 2.x > Design and CSS styles > ORDER BY expression / KenticoCMS v3.1 View modes: 
User avatar
Member
Member
Lloyd_Smith - 7/31/2009 4:04:14 PM
   
ORDER BY expression / KenticoCMS v3.1
I am using both a tree menu and a repeater on the same page. The tree menu displays a link to the sub pages by title and the repeater is using the transformation CMS.MenuItem.ProductList. See https://www.cortechsolutions.com/Products/Tools-and-utilities.aspx for details.

I would like the order of the entires in the two to be the same. I am using the up and down options in the CMS desk to order the menu item entries as I wish them to appear in the site, and the tree menu appears correct, but I am not sure how to make the repeater sort entries in the same order as the tree menu. If there is a simple ORDER BY expression I can use, please let me know. Thanks in advance!

BTW - I am using the free license and will most likely upgrade soon. I love it so far!

User avatar
Kentico Consulting
Kentico Consulting
kentico_mirekr - 8/3/2009 9:41:30 AM
   
RE:ORDER BY expression / KenticoCMS v3.1
Hi,

If you want to order your items as they are ordered in CMS Desk Content tree you need to order them using following expression:

Order by: NodeLevel, NodeOrder, NodeName

Best Regards,
Miroslav Remias.

User avatar
Member
Member
alamir.youssef-oryx.com - 12/1/2010 11:39:43 PM
   
RE:ORDER BY expression / KenticoCMS v3.1
Hi,
I just wanted to sort the images in desc way by the file names, so I write this below expression and it worked

in order by field (NodeName DESC)

I hope this will help.

Best Regards,
ALamir