Subscription

[Former Member]

Hi,

I want to find the number of subscription on a discussion (Urget Request)? How can i do this from API?

Thaks for help,

Ramona

[DirkLehmann · Accepted solution]

Hi Ramona,

do I get you right that you want to know how many Subscriptions exist on a discussion?

This function is currently not available in the APIs, as you can only check for a single recipient. (If you check the JavaDoc you'll see that you always need a Recipient/User to ask for a subscription....there's no method like: "Hey, I got a resource here, give me all the subscriptions on it...no matter who owns/created the subscription")

Regards

Dirk

[Former Member · Accepted solution]

Hi Dirk,

Thank you for asking me.

Ok... but I really must to find out...

Is there any possibility like: take all the users and see what subscription they have and count them in this way?

Do you have any suggestions, no matter how much time it takes to run?

I have to find out the top three subscribed folders of a community and the number of subscriptions on these three folders too. Is the same thing, isn't it?

Regards,

Ramona

Message was edited by: Ramona-Teodora Ciunta

Message was edited by: Ramona-Teodora Ciunta

[DirkLehmann · Accepted solution]

Hi,

well I guess that's currently the only way to do by API: Get all users, get all subscriptions for each user and summarize over the subscribed resources (Which are attached at every subscription).

Maybe (but this is no offical way to do...so I never told you ) you can have a look directly into the DB. Check the DB tables wcm_sub_subscriptions (KMC_SUB_SUBS in NW04), wcm_sub_recipients (KMC_SUB_RCPT) and wcm_sub_resources (KMC_SUB_RES). They are the persistance of the subscriptions. You might read the data directly from there, but please <b>never ever</b> touch (write/change) anything in there.

Regards

Dirk

[DirkLehmann · Accepted solution]

One last note on this:

The SAP NetWeaver04 SPS 10 version will bring an API that offers a getSubscription(RID) method.

With that it'll be easily possible to get all Subscriptions on a resource (no matter who the owner is).

Regards

Dirk

[Former Member · Accepted solution]

Hi Dirk,

Thanks a lot for help! Good news with the new version!

regards,

Ramona