Notifications
Clear all
Topic starter
We are updating the banner for staff. Some users rely on the default banner specified at the Enterprise level of 'preferences'. However, several users have manually created entries specifying a banner. So, how can I easily get all users on the same banner? As a fall-back, is there a table that I can report on to know who has a custom banner specified?
Thanks.
Posted : June 11, 2015 7:26 am
You can find the users who have a custom banner with this:
SELECT df.ListName, p.PREFVALUE
FROM PREF p
INNER JOIN DoctorFacility df
ON p.DoctorFacilityId = df.DoctorFacilityId
WHERE p.PREFNAME = 'BANNERPREF'
And you can clear those preferences with this:
DELETE PREF
WHERE PREFNAME = 'BANNERPREF'
AND DoctorFacilityId > 0
AND GROUPID = -1
Of course I would test that second one in a safe environment before implementing it in production.
Posted : June 11, 2015 8:01 am
