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

Multiple left joins on selecting multiple address fields in Drupal CiviCRM Views

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.2.7, 4.3.0
    • Fix Version/s: 4.3.0
    • Labels:
      None

      Description

      Following are the steps to replicate the issue:-
      1) Enable "Show the SQL query" under Drupal view "live preview" setting
      2) Select multiple address field (for eg. Longitude, Latitude etc.)
      3) In the View query multiple Left Join appears with different table aliases whose count depends on address fields.

        Attachments

          Activity

            People

            • Assignee:
              yashodha Yashodha Chaku
              Reporter:
              webaccess Web Access
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: