1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Sort Events

18 posts, 0 answered
  1. danfinney
    danfinney avatar
    51 posts
    Registered:
    09 Jul 2008
    04 Aug 2008
    Link to this post
    Ok, I give up.  How do you sort the Events by Start Date????  In the advanced tab under EventsView I see the following:

    Filters > Sort Expression>  Publication_Date DESC

    Clicking the little question mark helpfully tells me that I can use "Publication_Date DESC" but it does not tell me what else I might be able to use.  I have tried changing the setting to "Start_Date"  and "Start_Date DESC" but these do not work.

    Is there a list of available settings somewhere?
  2. Rebecca
    Rebecca avatar
    536 posts
    Registered:
    24 Sep 2012
    04 Aug 2008
    Link to this post
    Hi danfinney,

    The controls based on Content View have certain meta fields you can filter by. There is a complete list of meta fields for each control in the Sitefinity Developer Manual. Follow this link to find out more about sorting events: Using ContentManager with Events.

    In your case, you should use Event_Start DESC.

    Greetings,
    Rebecca
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  3. Mark Bodine
    Mark Bodine avatar
    2 posts
    Registered:
    08 May 2006
    04 Aug 2008
    Link to this post
    Sorting the order of article appearance with the Images and Documents control

    Is there a way to set the order (sort) of the articles that are presented to the public interface using the Images and Documents control?

    I would like the administrator to order the articles in a certain way and then have them presented that way to the user.

    Thanks in advance.

    Mark
    mark@freedom22.org)
  4. Rebecca
    Rebecca avatar
    536 posts
    Registered:
    24 Sep 2012
    04 Aug 2008
    Link to this post
    Hi Mark Bodine,

    I suppose you are talking about the Image Gallery and the Download List controls. There is a property you can set at the Advanced tab of both controls. You just need to expand the Filters section and set SortExpression.

    For example, the DownloadList control can be ordered by the following meta fields:
    • Name
    • Size
    • Extension
    • Author
    • Description

    For the Image Gallery control, the meta fields you can sort by are:

    • Author
    • AlternateText
    • Extension
    • Name
    • Height
    • Width
    • Size

    So, for example, to sort the the items in the download list by their title, you need to set Name DESC for the value of the SortExpression property.

    Kind regards,

    Rebecca
    the Telerik team


    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  5. danfinney
    danfinney avatar
    51 posts
    Registered:
    09 Jul 2008
    04 Aug 2008
    Link to this post
    Thanks Rebecca!

    Event_Start DESC seems to be sorting them in reverse chronological order. Is there a way to sort them chronologically by Start Date?

    I checked the Developer Menu, but as a Designer, I have to say that most of the Developer Manual seems incomprehensible. (not trying to be overly critical, just giving you some feedback) For instance, I do not see anything with regards to the "DESC" value that you just mentioned in the post.

    You have a wonderful tool tip feature on the CMS, but it is not very useful when the tip for BehaviorMode (for instance) says "defines the behavior mode for the control."  It would be nice if the tip told you either what settings were available, or where in the manual you could find the full information.

    -Dan Finney

    indianapolis web design
  6. Mark Bodine
    Mark Bodine avatar
    2 posts
    Registered:
    08 May 2006
    04 Aug 2008
    Link to this post
    Thanks Rebecca for your email. I need to explain in more detail what I am trying to do:

    I would like the administrator to be able to order a list of articles using the Document List control from Images and Documents, either by

    (1) using another field in the database (such as is done in DotNetNuke where the Documents module has a sort index field. Currently in Sitefinity, you can sort on the meta fields you listed, but is there a way to (maybe by creating a new meta field column?) sort by some other index that I can enter for each article?

    OR

    (2) using something like that available in the Ajax Control Tooklit called reordering list, whereby you can just drag articles from one position to another and then have a new index in the database record the sort order. Someone on the forum mentioned that you could use the Rad Dock for this, but I don't know if this is the correct way or not.  I have not been able to fill up Sitefinity 3.2 with the RadControls. Is this documented on how to do this? It seem that Sitefintiy manual says all the RadControls are available for use, but I don't know how to bring them into Sitefinity.

    Thanks in advance.

    mark
    mark@freedom22.org
  7. danfinney
    danfinney avatar
    51 posts
    Registered:
    09 Jul 2008
    06 Aug 2008
    Link to this post
    Rebecca,

    I haven't heard from you.  Is there a way to sort them chronologically by Start Date?   Should I open a support ticket instead of asking in the forum?
  8. danfinney
    danfinney avatar
    51 posts
    Registered:
    09 Jul 2008
    06 Aug 2008
    Link to this post
    Ok, for anyone else out there that may have gone to art school...  DESC is descending.  ASC is ascending. 
  9. Ivan
    Ivan avatar
    478 posts
    Registered:
    16 Jun 2015
    08 Aug 2008
    Link to this post
    Hello Mark Bodine,

    The only module in Sitefinity that supports explicit ordering out of box is the List module. If you would like to give the administrator the ability to order events explicitly, you should add new metafield to Events module (e.g. Ordinal). In this field content editors / administrators would enter the number (e.g. 1 for the first event, 10 for the tenth event). In the EventsView you would set the SortExpression to Ordinal ASC.

    I hope you'll find this information helpful. Let us know if there is anything else we can do for you.

    Kind regards,
    Ivan
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  10. Jozef Staes
    Jozef Staes avatar
    2 posts
    Registered:
    29 Jan 2008
    13 Nov 2008
    Link to this post
    I need some help with this issue. I've been pulling my hairs trying to figure out the system behind the Events ordering, cause it's not making any sense to me.

    What I want to do:

    I have a website with two Event overviews. So when I create an event it's either Category A or Category B, and it should pop up in that list in order of when the event is about to take place (with the nearest event at the top)

    What I've done:

    I've created two pages with an EventsView module and selected Category as Displaymode. I've entered the CategoryIDs in both instances.

    So far so good, and indeed both list only show the events of their category.

    But the order is completely random, even though I've got  SortExpression set to Events_Start ASC. They're not even sorted in the order I created them, there is just no pattern whatsoever.

    I must be missing something here. Any help or tips are welcome.

    Niel Staes
  11. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    16 Jun 2017
    13 Nov 2008
    Link to this post
    Hi Jozef Staes,

    In Sitefinity version 3.5 SortExpression property for Events works for CategoriesList control. I set Event_Start ASC and the events was sorted as expected.

    I hope this helps.

    Greetings,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  12. Jozef Staes
    Jozef Staes avatar
    2 posts
    Registered:
    29 Jan 2008
    13 Nov 2008
    Link to this post
    That's great news. I'd been looking all over the place to get this working. Time to get our IT guy into gear.

    Kind regards,

    Niel Staes
  13. Joel
    Joel avatar
    28 posts
    Registered:
    18 Jun 2008
    19 Feb 2009
    Link to this post

    I am interested in a solution for the same problem.

    - I have a list of events entered
    - They are assigned to various categories
    - I have one eventview module in place

    I want to list the events by category in Start_Date ASC.

    I have them currently sorted correctly by start date, but not by Category.

    What's the best way to set this up?

    I would like it would be multiple eventview modules, each assigned to 1 category and Start_Date ASC

    Unfortunately, I don't even know where to find the Category ID.

    Guidance would be helpful.

    Thanks!
  14. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    16 Jun 2017
    20 Feb 2009
    Link to this post
    Hello Joel,

    Under Filters section you should change FilterExpression and SortExpression properties values.

    Here is an example below:

    FilterExpression:
    Publication_Date <= "#now" AND Expiration_Date > "#now" AND Category = "EventsCategory" 

    SortExpression: Event_Start ASC

    Just to let you know, there is no metafield Start_Date by default. The default value is Event_Start.

    Greetings,
    Ivan Dimitrov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  15. Joel
    Joel avatar
    28 posts
    Registered:
    18 Jun 2008
    20 Feb 2009
    Link to this post
    Thanks!

    However, I am using 3.2 and I don't have the FilterExpression.

    Under advanced > Filters I only have.

    SortExpression (which I set..thanks!)
    DateFrom
    SummarySettings

    Sorry, I should have indicated my version.
  16. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    16 Jun 2017
    20 Feb 2009
    Link to this post
    Hello Joel,

    Under 3.2 Filterexpresion is not supported. You should upgrade your version to the last stable release if possible. If this is not an option, then you should extend the ContentView controls and implement the filtering in the extended class.

    All the best,
    Ivan Dimitrov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  17. Jose Philip
    Jose Philip avatar
    1 posts
    Registered:
    15 Oct 2009
    19 Mar 2010
    Link to this post

    Hi,

    in the  advanced tab for Content Place holder under Filters menu Sitefinity 3.2 display 3 fields such as DateFrom, Summary Settings , Sort Expression.

     

    I have uploaded documents in library, and selected that library to display, but I need to sort  the diplayed documents according to say, uploaded date, Is it possible.

    How can I sort the documents displayed from a library, in Content Place Holder on any fields?

     

    Thank you,

    Jose Philip

  18. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    16 Jun 2017
    19 Mar 2010
    Link to this post
    Hello Jose Philip,

    Content Place Holder is declared in the master page. It is not presentation layer of any module. I suppose that you use one of the built-in controls.

    How can I sort the documents displayed from a library, in Content Place Holder on any fields?

    Since the control you use has Sort Expression property you can perform a search by metakey - DESC or ASC. All metakeys are declared in the web.config <metaFields> node. The metakeys are declared per provider and they can be used only in the scope of a provider. Also I suggest that you should upgrade to latest official release - Sitefinity 3.7 SP3. The version 3.2 that you use was released almost two years ago.

    Sincerely yours,
    Ivan Dimitrov
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Register for webinar
18 posts, 0 answered