I discovered at this years conference that there is a setting in preferences to disable the “123 of your scheduled reports have been run…” message that pops up when you login.
Most of our scheduled reports are emailed so this message is just an annoyance to users.
The following SQL code will disable this message for all your users:
--Set everyones preferences so no reports message
UPDATE T_USER_PREFERENCE
SET preference_value = 'No'
WHERE preference_key = 'Alert Waiting Reports'
AND preference_value = 'Yes'
--Insert setting where does not exist
INSERT T_USER_PREFERENCE(userid,ug_id,preference_key,preference_value)
select u.userid,g.ug_id,'Alert Waiting Reports','No'
from t_metuser u
join tx_user_group g on g.userid = u.userid
left outer join T_USER_PREFERENCE p on u.userid = p.userid and p.preference_key = 'Alert Waiting Reports'
where p.userid is null
and u.inactive = 'N'
It can be scheduled to run every week to ensure setting stays disabled and for new users.
Hope this is of help to someone.
Thanks,
Dara
or easier still, go into Tessitura Select PREFERENCES from the TOOLS dropdown and uncheck the "Display Alert for Waiting Reports" check box.
That’s true Dale, and that works fine for myself and our power users.
However, we also have a bunch of users who don't want to have to go in and change preferences.
The code will disable this for all users so you can just tell them this pop up has been disabled.
There is an argument that its better to show users how to do a task so they know for the future, and in most cases I agree with this, but there are also situations where its good to just be able to tell users "Its fixed"!
I got a lot of happy users when I told them that message is gone away. :-)
my bad, I didn't see the part that said "for all users". carry on.