Merge pull request civicrm#24 from rohankatkar/CRM15846

kurund · kurund · commit d594680ca753 · 2015-02-13T19:13:35.000+05:30
Additional changes for CRM-15846
diff --git a/site/elements/civicustomsearch.php b/site/elements/civicustomsearch.php
@@ -52,10 +52,10 @@ protected function getInput() {
     require_once 'CRM/Core/Config.php';
     $config = CRM_Core_Config::singleton();
     $query = "
-SELECT value, description
-FROM civicrm_option_value
-WHERE option_group_id =24
-";
+SELECT op_val.value, op_val.description
+FROM civicrm_option_value op_val
+INNER JOIN civicrm_option_group op_group ON (op_group.id = op_val.option_group_id)
+AND op_group.name = 'custom_search'";
     $dao = CRM_Core_DAO::executeQuery($query);
     while ($dao->fetch()) {
       $options[] = JHTML::_('select.option', $dao->value, $dao->description);
