projects
/
migration-tools.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
(parent:
01a59bd
)
fixing errant line
author
Rogan Hamby
<rhamby@esilibrary.com>
Thu, 23 Jan 2020 14:25:20 +0000 (09:25 -0500)
committer
Rogan Hamby
<rhamby@esilibrary.com>
Thu, 23 Jan 2020 14:25:20 +0000 (09:25 -0500)
mig-xml/evergreen_staged_report.xml
patch
|
blob
|
history
diff --git
a/mig-xml/evergreen_staged_report.xml
b/mig-xml/evergreen_staged_report.xml
index
81f3cc1
..
29283e6
100644
(file)
--- a/
mig-xml/evergreen_staged_report.xml
+++ b/
mig-xml/evergreen_staged_report.xml
@@
-1135,8
+1135,6
@@
id = ac_sc.owner GROUP BY 2,3 ORDER BY 2,3</query>
<heading>ID.Active.Owner.Name</heading>
<query>SELECT ed.id, ed.active::TEXT, aou.shortname, ed.name
FROM action_trigger.event_definition ed
- <query>SELECT ed.id, ed.active::TEXT, aou.shortname, ed.name
- FROM action_trigger.event_definition ed
JOIN actor.org_unit aou ON aou.id = ed.owner
WHERE ed.owner IN (SELECT DISTINCT home_ou FROM m_actor_usr)
OR ed.owner IN (SELECT DISTINCT parent_ou FROM actor.org_unit WHERE id in (SELECT DISTINCT home_ou FROM m_actor_usr));