Details
-
Suggestion
-
Resolution: Unresolved
-
None
-
None
-
JDK 1.5 on Linux. Running in Tomcat 5.5 but all of this is irrelevant.
-
7
-
16
-
Description
NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? See the corresponding suggestion.
On a busy site where users comment and edit a lot, you end up with hundreds of pages that you are subscribed to. At some point, while cleaning up, it would be nice to be able to select a bunch of pages (via checkboxes perhaps) and then click on a button that says "Unwatch all selected pages" or something to that effect.
Workaround
These watch statuses can be manually deleted via database commands.
Always take a database backup and stop Confluence before running database queries that manipulate the database
We can run something like this to get the specific page name along with the notificationid (substituting in the username:
Select notifications.notificationid, content.lowertitle FROM notifications
INNER JOIN CONTENT on notifications.contentid = content.contentid
WHERE notifications.username IN (SELECT user_key FROM user_mapping WHERE username= '<user-name>');
Then run the following to delete notificationids for the pages you want to remove for the user:
DELETE from notifications where notificationid in (12345,6789);
Attachments
Issue Links
- is duplicated by
-
- Closed
-
- Closed
-
- Closed
- is related to
-
- Not Being Considered
- relates to
-
- Gathering Interest
- mentioned in
-
Page Loading...
-
-
-
-
-
-
-
-
-
