From 3aa2011e00aa76740567bc2f62d6a2728568f484 Mon Sep 17 00:00:00 2001
From: yashodha <yashodha@cividesk.com>
Date: Thu, 24 Aug 2023 17:48:12 +0530
Subject: [PATCH] (dev/core#4532) Add sort for country/state fields in reports

---
 CRM/Report/Form.php | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/CRM/Report/Form.php b/CRM/Report/Form.php
index 768e13c274..6c5e14cf46 100644
--- a/CRM/Report/Form.php
+++ b/CRM/Report/Form.php
@@ -5839,6 +5839,7 @@ LEFT JOIN civicrm_contact {$field['alias']} ON {$field['alias']}.id = {$this->_a
         'options' => CRM_Core_PseudoConstant::stateProvince(),
         'is_fields' => TRUE,
         'is_filters' => TRUE,
+        'is_order_bys' => TRUE,
         'is_group_bys' => TRUE,
       ],
       $options['prefix'] . 'country_id' => [
@@ -5847,6 +5848,7 @@ LEFT JOIN civicrm_contact {$field['alias']} ON {$field['alias']}.id = {$this->_a
         'name' => 'country_id',
         'is_fields' => TRUE,
         'is_filters' => TRUE,
+        'is_order_bys' => TRUE,
         'is_group_bys' => TRUE,
         'type' => CRM_Utils_Type::T_INT,
         'operatorType' => CRM_Report_Form::OP_MULTISELECT,
-- 
2.25.1