Old Forums
Search:
Portal Engine Questions on portal engine and web parts.
Version 7.x > Portal Engine > Order by expression options View modes: 
User avatar
Member
Member
grujer - 1/27/2014 4:36:54 PM
   
Order by expression options
I am displaying documents from a folder in a repeater, and need to know the different options I have for ordering them. I know NodeName, but I would like to know other options, especially dealing with the date the documents were added. A basic list of the top 8 or 10 expressions would be very helpful.

Thanks,
Jeremy
User avatar
Member
Member
kentico_sandroj - 1/27/2014 8:56:58 PM
   
RE:Order by expression options
Hi Jeremy,

Unfortunately, we do not have a list of the available expressions as they vary greatly depending on which data/document types you are working with and what their columns are. In order to check what the available options are for each scenario, you could use the SQL Debug to see which columns are available in the Query, then use any of the columns for your ORDER BY expression. One expression that is specific to Kentico and may be of interest to you is reproducing the Content Tree ORDER BY. Otherwise you would use the ORDER BY conditions as any other SQL statement. You may also use macros and K# instead of static values.

Please let me know if you have additional questions.

Best Regards,
Sandro

Top