CRM-12712 Query builder does not work with IS EMPTY filter (on dates)

          Details

          • Type: Bug
          • Status: Done/Fixed
          • Priority: Minor
          • Resolution: Fixed/Completed
          • Affects Version/s: 4.3.3
          • Fix Version/s: 4.3.4
          • Component/s: None
          • Labels:
            None

            Description

            Using a custom date field, the IS EMPTY filter does not filter out rows with values (see attachment). The IS NULL/IS NOT NULL filter works well, however. Also, some documentation around what IS EMPTY IS would be useful, since it is not a standard MySQL condition. Does it include NULL values?

              Attachments

                Activity

                [CRM-12712] Query builder does not work with IS EMPTY filter (on dates)
                Kurund Jalmi added a comment -

                I think for date we don't need "IS EMPTY" because it is same as "IS NULL", so may be just remove that option for date fields

                Coleman Watts added a comment -

                Ok that's a very easy fix
                https://github.com/civicrm/civicrm-core/pull/902

                  People

                  • Assignee:
                    Kurund Jalmi
                    Reporter:
                    Rares P

                    Dates

                    • Created:
                      Updated:
                      Resolved: