Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. 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

            People

            • Assignee:
              Unassigned
              Reporter:
              francescbassas Francesc Bassas i Bullich
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: