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

Manage Events / search by date range uses incorrect WHERE criteria

    Details

    • Documentation Required?:
      None
    • Funding Source:
      Core Team Funds

      Description

      When I go to "Manage Events" and use the "Find Events" box to search by date range, although it does narrow down the list, the search excludes some events that do overlap the search period, and includes some events that do not overlap the search period. The inclusion of incorrect events, occurs particularly when the event has a start date but no end date.

      Screenshots are attached of the issue on our live site (4.4.20), 4.7 demo, and 4.6 on my personal test server.

        Attachments

        1. Screenshot_2016-03-16_09-47-25.png
          135 kB
          David Knoll
        2. Screenshot_2016-03-16_14-47-50.png
          155 kB
          David Knoll
        3. Screenshot_2016-03-16_14-54-01.png
          177 kB
          David Knoll

          Activity

            People

            • Assignee:
              rohan1990 Rohan Ramesh Katkar
              Reporter:
              DaveFF David Knoll
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 3 hours
                3h