Hi Thomas, Is there a way of doing this from the staff client? Thanks! Gordana Gordana Vitez Library Services & Systems Coordinator NC Libraries and Learning Commons Niagara College 300 Woodlawn Rd Welland Ontario L3C 7L3 Phone: (905) 735 2211 ext 7404 Fax: (905) 736 6021 gvi...@niagaracollege.ca
>>> On 6/6/2012 at 5:20 PM, in message >>> <20120606172023.781033cqtxt3r...@mail.mvlc.org>, Thomas Berezansky >>> <tsb...@mvlc.org> wrote: You need to do two things. 1 - Update the org_depth for the STAFF_* penalties (and possibly any INVALID_* ones) to be 0. Don't change them all, some should be ignoring it anyway but are placed based on the owner of group penalty thresholds. 2 - Update the existing standing penalties of those IDs to be owned by the consortia, as the org_depth only applies on *new* ones. This is easiest in the DB itself, and if you only changed the STAFF_ and maybe INVALID_ ones this should work: UPDATE actor.usr_standing_penalty SET org_unit = 1 WHERE standing_penalty IN (SELECT id FROM config.standing_penalty WHERE org_depth = 0); Thomas Berezansky Merrimack Valley Library Consortium Quoting "Turner, Jennifer M" <jennifer.tur...@mnsu.edu>: > How can staff-applied standing penalties and messages be configured > to display at all org units in a consortium? Currently, when we > apply an alert or note message from a branch library, it only > displays to staff logged in at that library. Messages applied from > the headquarters location (system-level) may be viewed at all org > units. > > We've looked at the settings for Standing Penalty Types (Admin > > Local Admin > Standing Penalties). Do we need to adjust the > org_depth setting here? Currently this field is NULL for all > penalty types. If it needs to be adjusted, what integer value > should be entered. I've experimented with 0, 1, 2, and 3, but none > of those seemed to change the system's behavior. > > Thanks for any assistance! > > Jenny > > > Jennifer Turner | PALS, A Program of the Minnesota State Colleges > and Universities | 507-389-2000 > >