Reporter source Payments: All excludes anonymized transactions
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
New
|
Undecided
|
Unassigned |
Bug Description
Evergreen 3.6
Payments: All source links to the action.circulation table not action.
Example report - display payment accepting library, payment year, billed patron profile, sum amount collected.
The same basic query looking at payment types rather than patron profile works as expected.
Table joins from generated SQL for query:
SELECT * FROM (SELECT "198f9d6731e291
(EXTRACT(YEAR FROM "005ba04582862d
"45732b5bf748e
SUM("005ba0458
FROM money.all_payments AS "005ba04582862d
INNER JOIN actor.workstation
INNER JOIN actor.org_unit
INNER JOIN money.billable_xact
LEFT OUTER JOIN action.circulation
LEFT OUTER JOIN actor.usr
LEFT OUTER JOIN permission.grp_tree
tags: | added: reports |