Notification list - report of user's subscriptions?

Friday 25 August 2006 11:26:27 pm

We have a few thousand users signed up for notifications of various pags/sections of the site. As part of our analytics, we would like to see what areas are the most popular. Also useful would be a count of how many subtree subscriptions each user had.

At the most basic, we would need to see which users have a subtree notification on a particular node.

The docs on the notification module only deal with the fetching the subscriptions of the current logged in user. Is there a way to extract this information based on a fetch of the node id, or to modify a template like the line.tpl to show a subscription count in it?

http://www.thinkcreative.com
Turning Ideas Into Strategic Solutions

Sunday 27 August 2006 6:11:29 am

Hi Folks,
as i had to answer the same question before and solved it with some SQL query, i posted this suggestion http://ez.no/bugs/view/8906 in order to adress the common "reporting" tasks.

So, Mark, i guess, your question can be answered with SQL queries. If you have access to your DB with some GUI (phpMyAdmin, sqlPlus), i can look up the query i had.
Please note, that your question "which users have a subtree notification on a particular node" aint that easy, because the notifications are stored for the top node of that tree.
Do you want to see the users that have notifications for EXACTLY this node or notifications on any subtree, that includes the particular node?

Marco
http://www.hyperroad-design.com