We've has a few testers completely mess up their home pages, as users tend to
We can reset their dashboard to the default but this doesn't change any of the settings that affect this, such as layout or report templates applied etc.
We need some way to be able to reset all dashboard user settings, especially as ocassionally one gets corrupted completely (we've still not managed to fix one).
Support sent us this some time ago but it doesn't seem to affect any settings at all, or fix the dashboard if it is broken.
Delete from tps_user_preference where tps_user_guid = (select tps_guid from tps_user where tps_name = 'XXXXXX')
Has anyone any ideas?
Cheers - Adam.