I have a drupal view that shows aggregated totals grouped by user from civi contribution pages.
The view has a contextual filter that takes the contribution page id as an argument.
The view works well if I pass in one argument.
I would like to be able to pass in multiple arguments, so, display contributions from contribpageID1 AND contribpageID2.
On contextual filters with drupal fields I am able, in the "more section", to select "Allow multiple values". This option isn't available on the
CiviCRM Contributions: Contribution Page field.
Is this a limitation of the civi views integration? Or a setting I can't find.
Below is the query being run:
SELECT SUM(civicrm_contribution.total_amount) AS civicrm_contribution_total_amount
WHERE (( (civicrm_contribution.contribution_page_id = '12') )AND(( (civicrm_contribution.financial_type_id IN ('1')) AND (civicrm_contribution.contribution_status_id IN ('1')) AND (civicrm_contribution.is_test = '0') AND (civicrm_contribution.receive_date >= '2014-12-31 00:00:00') AND (civicrm_contribution.receive_date <= '2015-12-31 00:00:00') )))
LIMIT 20 OFFSET 0
On line 5, I want it to say ...
_page_id = '12,15')...
Aggregation is turned on but the option is not there when this is turned off either.