Disable scheduled reports popup message

That’s lovely, Dara, thanks!  It’s the little things that make life easier J

Cheers,

Kathleen

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

--
View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/5083/16430.aspx#16430 or reply to this message
--
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!