Notification list - report of user's subscriptions?

Next topic

Author	Message
Mark Marsiglio	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
Kristof Coomans	Sunday 27 August 2006 2:20:51 am Hello Mark I think there are no such template fetch functions at the moment, but it would be a nice enhancement. Can you post an enhancement request in the bug tracker? independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Marco Zinn	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
Norman Leutner	Sunday 27 August 2006 11:10:14 pm If you want to the query within ez, just take a look at this extension, it show how to execute a sql query into ez and return the result. http://ez.no/community/contribs/template_plugins/topauthors Mit freundlichen Grüßen Best regards Norman Leutner ____________________________________________________________ eZ Publish Platinum Partner - http://www.all2e.com http://ez.no/partners/worldwide_partners/all2e_gmbh