T243356 Find cases of early recurring 2020-01
ActivePublic
Actions

Authored by AndyRussG on Jan 24 2020, 5:20 PM.

Tags

None

Referenced Files

	F31532440: raw.txt
	Jan 24 2020, 5:20 PM

	F31532439: raw.txt
	Jan 24 2020, 5:20 PM

Subscribers

None

	SELECT
	r.next_sched_contribution_date,
	c.receive_date
	FROM
	civicrm_contribution as c
	LEFT JOIN

	civicrm_contribution_recur as r
	ON
	r.id = c.contribution_recur_id
	WHERE
	r.next_sched_contribution_date < '2020-02-01' AND
	c.receive_date > '2020-01-01' AND
	r.cancel_date IS NULL;

Event Timeline

AndyRussG created this paste.Jan 24 2020, 5:20 PM

AndyRussG edited the content of this paste. (Show Details)

AndyRussG changed the title of this paste from T243356 Query to check for early recurring 2019-01 to T243356 Find cases of early recurring 2019-01.

AndyRussG changed the title of this paste from T243356 Find cases of early recurring 2019-01 to T243356 Find cases of early recurring 2020-01.Jan 29 2020, 9:43 PM

AndyRussG mentioned this in T243356: Civi: January 2020 Ingenico recurrings processing in duplicate?.Jan 29 2020, 10:18 PM

T243356 Find cases of early recurring 2020-01ActivePublicActions

Event Timeline

T243356 Find cases of early recurring 2020-01
ActivePublic
Actions