CiviCRM Community Forums (archive)

I am using the Activity Detail report where I am passing in the values for the filters via query string parameters.

For example:
http://mygroup.org/civicrm/report/instance/35?reset=1&force=1&activity_date_time_from=20140301&activity_date_time_to=20140331&activity_type_id_value=2

The above example works okay. But If I need more than one activity_type_id_value   then I get an SQL error.  For 2 activity types I am using the URL:
http://mygroup.org/civicrm/report/instance/35?reset=1&force=1&activity_date_time_from=20140301&activity_date_time_to=20140331&activity_type_id_value=2,7

Is this the correct syntax for a multi-value parameter on a URL?

Stack trace is:
#0 /home/aaaprod/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/aaaprod/public_html/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/aaaprod/public_html/sites/all/modules/civicrm/packages/DB.php(971): PEAR_Error->PEAR_Error("DB Error: a515ac9c2796ca0e23adbe92c68fc9fc", "a515ac9c2796ca0e23adbe92c68fc9fc", 16, (Array:2), "SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_co...")
#4 /home/aaaprod/public_html/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error("a515ac9c2796ca0e23adbe92c68fc9fc", 16, (Array:2), "SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_co...")
#5 /home/aaaprod/public_html/sites/all/modules/civicrm/packages/DB/common.php(1903): PEAR->raiseError(NULL, "a515ac9c2796ca0e23adbe92c68fc9fc", NULL, NULL, "SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_co...", "DB_Error", TRUE)
#6 /home/aaaprod/public_html/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError("a515ac9c2796ca0e23adbe92c68fc9fc", NULL, NULL, NULL, "1241 ** Operand should contain 1 column(s)")
#7 /home/aaaprod/public_html/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/aaaprod/public_html/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_co...")
#9 /home/aaaprod/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_co...")
#10 /home/aaaprod/public_html/sites/all/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_co...")
#11 /home/aaaprod/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_co...")
#12 /home/aaaprod/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(922): CRM_Core_DAO->query("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_co...", TRUE)
#13 /home/aaaprod/public_html/sites/all/modules/civicrm/CRM/Report/Form.php(2050): CRM_Core_DAO::executeQuery("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_co...")
#14 /home/aaaprod/public_html/sites/all/modules/civicrm/CRM/Report/Form.php(2401): CRM_Report_Form->buildRows("SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_co...", NULL)
#15 /home/aaaprod/public_html/civicrm_custom_code/CRM/Report/Form/Activity.php(458): CRM_Report_Form->postProcess()
#16 /home/aaaprod/public_html/sites/all/modules/civicrm/CRM/Report/Form.php(507): CRM_Report_Form_Activity->postProcess()
#17 /home/aaaprod/public_html/sites/all/modules/civicrm/CRM/Core/Form.php(338): CRM_Report_Form->preProcess()
#18 /home/aaaprod/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(93): CRM_Core_Form->buildForm()
#19 /home/aaaprod/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Report_Form_Activity), "display")
#20 /home/aaaprod/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Report_Form_Activity), "display")
#21 /home/aaaprod/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php(289): HTML_QuickForm_Page->handle("display")
#22 /home/aaaprod/public_html/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(115): CRM_Core_Controller->run()
#23 /home/aaaprod/public_html/sites/all/modules/civicrm/CRM/Report/Page/Instance.php(104): CRM_Utils_Wrapper->run("CRM_Report_Form_Activity", NULL, NULL)
#24 /home/aaaprod/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(220): CRM_Report_Page_Instance->run((Array:4), NULL)
#25 /home/aaaprod/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(51): CRM_Core_Invoke::_invoke((Array:4))
#26 /home/aaaprod/public_html/sites/all/modules/civicrm/drupal/civicrm.module(382): CRM_Core_Invoke::invoke((Array:4))
#27 [internal function](): civicrm_invoke("report", "instance", "35")
#28 /home/aaaprod/public_html/includes/menu.inc(348): call_user_func_array("civicrm_invoke", (Array:3))
#29 /home/aaaprod/public_html/index.php(18): menu_execute_active_handler()