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

Add parameter to dateQueryBuilder fn to change date value to desired format

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.7.0
    • Fix Version/s: 4.7.23
    • Component/s: None
    • Labels:
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code
    • Verified?:
      No

      Description

      Currently in CRM_Contact_BAO_Query::dateQueryBuilder(), it builds where clause for date field whose value(s) are considered in mysql format (YmdHis). This put a restriction on date columns like civicrm_financial_trxn.trxn_date which stores and operates on ISO format date values.

      It can be resolved by introducing $dateFormat parameter for dateQueryBuilder() to format the date to desired.

        Attachments

          Activity

            People

            • Assignee:
              jitendra.purohit Jitendra Purohit
              Reporter:
              monish.deb Monish Deb
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: