Notification list - report of user's subscriptions?

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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.