Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-5254

CiviEvent Dashboard - Event Summary table shows events farthest in the future first and may not show current and upcoming events

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.0
    • Fix Version/s: 3.1
    • Component/s: CiviEvent
    • Labels:
      None

      Description

      The current query for showing events in the dashboard event summary is not ideal. ORDER BY is end_date DESC with limit 10. We should ORDER BY start_date ASC so current and upcoming events float to the top. The WHERE clause should include events where start date is greater than 7 days ago - so we catch events which have just completed and events which are coming up soon.

        Attachments

          Activity

            People

            • Assignee:
              neha.saraph Neha Kulkarni
              Reporter:
              dgg David Greenberg
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: