CRM-18080 Allow search for empty dates on relationships advanced search

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.6, 4.7
    • Fix Version/s: 4.7.21
    • Component/s: None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code

      Description

      We make heavy use of relationships on our CiviCRM implementations to record a variety of situations: volunteer relations between an organitzation and a volunteer, grants concessions relations between an organitzation and a user beneficiary, etc.

      Start and End Dates allows us to limit the time period in which the relationship is valid. Unfortunately there is no way to do a search of all the relationships that were active during a given period. See detailed discusion here.

      A first approach would be able to search for empty dates as can be done in Relationship Reports. See how here

      A second and more accurate solution would incorporate an optional search field to appear only when you select the status of the relationship Active or Inactive. Then this field allows you to filter the date range for which the relationship was active or inactive, depending on the case.

        Attachments

          Activity

          [CRM-18080] Allow search for empty dates on relationships advanced search
          Coleman Watts added a comment -

          Francesc Bassas i Bullich if you are wishing to contribute funding or work for this feature, please let me know. Otherwise we should probably close this issue since it is not high priority and no one is currently stepping up to work on it.

          Francesc Bassas i Bullich added a comment -

          Thanks Coleman, this new feature is on my long list of todos and will be urgent the day that users start to press me. However, if no one else does, I intend to try to work on it at one time or another.

          Francesc Bassas i Bullich added a comment -

          This can be closed considering that the main motivation has been attached here https://issues.civicrm.org/jira/browse/CRM-18081.

            People

            • Assignee:
              Unassigned
              Reporter:
              Francesc Bassas i Bullich

              Dates

              • Created:
                Updated:
                Resolved: