Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • D dataprocessor
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Issues 42
    • Issues 42
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • Extensions
  • dataprocessor
  • Issues
  • #77
Closed
Open
Issue created Jan 26, 2021 by Don Wijesooriya@chamilwijesooriyaReporter

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+

Edited Jan 26, 2021 by Don Wijesooriya
Assignee
Assign to
Time tracking