Triggered events get confused when actor.usr.*_address = org_unit.*_address
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Medium
|
Unassigned | ||
2.2 |
Won't Fix
|
Medium
|
Unassigned | ||
2.3 |
Fix Released
|
Medium
|
Unassigned | ||
2.4 |
Fix Released
|
Medium
|
Unassigned |
Bug Description
Evergreen 2.2.2
We're seeing with many triggered events a problem when a user's address is the same as an org unit's. They end up with the OU address printed on the notice, NOT their proper mailing address. Took me a while to catch this, but I have now, and I think it's bug worthy since it's happening across multiple types of notices.
Data:
evergreen=# SELECT mailing_address, billing_address FROM actor.usr WHERE id IN (SELECT usr FROM actor.card WHERE barcode=
mailing_address | billing_address
----+--
181 | 181
181 | 181
(2 rows)
evergreen=# SELECT * FROM actor.org_address WHERE id=181;
id | valid | address_type | org_unit | street1 | street2 | city | county | state | country | post_code | san
-----+-
181 | t | MAILING | 115 | 125 S FRANKLIN STREET | | BLOOMFIELD | | IN | US | 47424 |
(1 row)
evergreen=# SELECT * FROM actor.usr_address WHERE id=181;
id | valid | within_city_limits | address_type | usr | street1 | street2 | city | county | state | country | post_code | pending | replaces
-----+-
181 | t | t | Legacy Address #1 | 15285 | 945 MAXWELL LN | | ZIONSVILLE | | IN | US | 46077 | f |
(1 row)
Template Output Snippet:
<patron>
<barcode>
<first_
<family_
<addr_
<addr_
<addr_
<addr_
<addr_
<email><email address hidden></email>
<sys_
</patron>
Changed in evergreen: | |
status: | New → Confirmed |
importance: | Undecided → Medium |
Changed in evergreen: | |
milestone: | none → 2.4.0-rc |
Changed in evergreen: | |
milestone: | 2.4.0-rc → none |
Changed in evergreen: | |
milestone: | none → 2.5.0-m1 |
Changed in evergreen: | |
milestone: | 2.5.0-m1 → 2.5.0-m2 |
Changed in evergreen: | |
milestone: | 2.5.0-m2 → 2.5.0-alpha1 |
Changed in evergreen: | |
milestone: | 2.5.0-alpha1 → 2.5.0-alpha2 |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
Template attached