/** * Adding address fields with dbAlias for order clause. * * @param bool $orderBy * * @return array * Address fields */ public function addressFields($orderBy = FALSE) { $address = parent::addAddressFields(FALSE, TRUE); if ($orderBy) { foreach ($address['civicrm_address']['order_bys'] as $fieldName => $field) { $address['civicrm_address']['order_bys'][$fieldName]['dbAlias'] = "civicrm_address_{$fieldName}"; } } return $address; }