Contribution dataprocessor with current user contact filter shows no results
Creating a simple contribution dataprocessor with a contact filter on "contribution::contact id" field, generates no results.
The full sql query shows that the filter is used for "contribution soft:: contact id" instead of contribution
Dataprocessor config is attached contribution_listing.json
SELECT DISTINCT
`contribution`.`id` AS `contribution_id`
FROM
(
SELECT
`_contribution`.`id` AS `id`,
`_contribution`.`contact_id` AS `contact_id`,
`_contribution`.`financial_type_id` AS `financial_type_id`,
`_contribution`.`contribution_page_id` AS `contribution_page_id`,
`_contribution`.`payment_instrument_id` AS `payment_instrument_id`,
`_contribution`.`receive_date` AS `receive_date`,
`_contribution`.`non_deductible_amount` AS `non_deductible_amount`,
`_contribution`.`total_amount` AS `total_amount`,
`_contribution`.`fee_amount` AS `fee_amount`,
`_contribution`.`net_amount` AS `net_amount`,
`_contribution`.`trxn_id` AS `trxn_id`,
`_contribution`.`invoice_id` AS `invoice_id`,
`_contribution`.`invoice_number` AS `invoice_number`,
`_contribution`.`currency` AS `currency`,
`_contribution`.`cancel_date` AS `cancel_date`,
`_contribution`.`cancel_reason` AS `cancel_reason`,
`_contribution`.`receipt_date` AS `receipt_date`,
`_contribution`.`thankyou_date` AS `thankyou_date`,
`_contribution`.`source` AS `source`,
`_contribution`.`amount_level` AS `amount_level`,
`_contribution`.`contribution_recur_id` AS `contribution_recur_id`,
`_contribution`.`is_test` AS `is_test`,
`_contribution`.`is_pay_later` AS `is_pay_later`,
`_contribution`.`contribution_status_id` AS `contribution_status_id`,
`_contribution`.`address_id` AS `address_id`,
`_contribution`.`check_number` AS `check_number`,
`_contribution`.`campaign_id` AS `campaign_id`,
`_contribution`.`creditnote_id` AS `creditnote_id`,
`_contribution`.`tax_amount` AS `tax_amount`,
`_contribution`.`revenue_recognition_date` AS `revenue_recognition_date`,
`_contribution`.`is_template` AS `is_template`,
`_contribution_soft`.`contribution_id` AS `contribution_soft_contribution_id`,
`_contribution_soft`.`contact_id` AS `contribution_soft_contact_id`,
`_contribution_soft`.`amount` AS `contribution_soft_amount`,
`_contribution_soft`.`currency` AS `contribution_soft_currency`,
`_contribution_soft`.`pcp_id` AS `contribution_soft_pcp_id`,
`_contribution_soft`.`pcp_display_in_roll` AS `contribution_soft_pcp_display_in_roll`,
`_contribution_soft`.`pcp_roll_nickname` AS `contribution_soft_pcp_roll_nickname`,
`_contribution_soft`.`pcp_personal_note` AS `contribution_soft_pcp_personal_note`,
`_contribution_soft`.`soft_credit_type_id` AS `contribution_soft_soft_credit_type_id`
FROM
`civicrm_contribution` `_contribution`
LEFT JOIN `civicrm_contribution_soft` `_contribution_soft` ON `_contribution`.`id` = `_contribution_soft`.`contribution_id`
WHERE
1
AND `_contribution`.`is_test` = 0
AND `_contribution_soft`.`contact_id` IN ( 202 )
) `contribution`
WHERE
1
Versions
dataprocessor 1.29
CiviCRM 5.32+