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

Profile listing doesn't produce expected results when range-searching custom date field

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.7.8
    • Fix Version/s: 4.7.16
    • Component/s: None
    • Labels:
      None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Core Team Funds

      Description

      1. Create custom group used for Contacts and custom field of type Date within it.
      2. Make it searchable with Search by Range: Yes.
      3. Create profile used for listings which uses this field; make this field Searchable.
      4. Fill this field for some contact with some date/time (i.e. 08.06.2016 00:00).
      5. Use profile in Listing mode.
      6. In Search criteria, you will see From and To fields. If you fill one of them with the exact date you enterend on step 4, it will find that contact (even if the range itself is incorrect – for example From 09.06.2016 To 08.06.2016). If you enter some range which contains that date (for example, From 07.06.2016 To 09.06.2016), you will see No mathes found message.

      Is it as if From and To fields used for OR search, not Range search.

        Attachments

          Activity

            People

            • Assignee:
              jitendra.purohit Jitendra Purohit
              Reporter:
              fkhodkov Fedor Khodkov
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: