nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

NotifyInterests2 Table

Michael_Fennell

Hi Forum

I was wondering if anyone can give me any guidance on how to decode the Intrest Level and the EventId Bit Mask in the NotifyInterest2 table

Regards

Mike.

Find more posts tagged with

Comments

Bhupinder_Singh

See my reply and replies by others on this thread:

https://knowledge.opentext.com/go/6523493

- Bhupinder

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, June 14, 2012 12:04 PM
To: eLink Recipient
Subject: NotifyInterests2 Table

NotifyInterests2 Table

Posted bymichael.fennell@fsa.gov.uk (Fennell, Michael) On 06-14-2012 12:02

Hi Forum

I was wondering if anyone can give me any guidance on how to decode the Intrest Level and the EventId Bit Mask in the NotifyInterest2 table

Regards

Mike.

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Michael_Fennell

Hi Bhupinder

Thanks for your reply, even though i am a little confused as to how i can decode this within my SQL

I dont suppose you have any piece of SQL showing the decoding method.

Regards

Mike.

Bhupinder_Singh

I have this example sent to me a while back from my colleague Colin Sim

Who has set Notification of Discussions or Task/Task List for MS SQL

select
kuaf.name "Login", kuaf.firstname "First Name", kuaf.lastname "Last Name", dtree.dataid "Item ID",
dtree.name "Name of Discussion, Task/Task List",
InterestLevel "Report#",

notifyinterests2.EventIDMask "Event Mask",
( case notifyinterests2.EventIDMask
when 2 then 'Topic Added to Discussion'
when 4 then 'Reply Added to Discussion'
when 6 then 'Topic & Reply Added to Discussion'
when 8 then 'Add Item on Task List'
when 8192 then 'Item Status Change'
when 8198 then 'Topic & Reply Added to Discussion or Item Status Changes'
when 8200 then 'Add Item & Item Staus Change on Task List'
else 'Not specified' end )"Event being Notified"

from notifyinterests2, kuaf, dtree
where notifyinterests2.userid=kuaf.id
and notifyinterests2.nodeid=dtree.dataid
and (dtree.subtype=204 or dtree.subtype=206 or dtree.subtype=215)

- Bhupinder

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, June 15, 2012 5:10 AM
To: eLink Recipient
Subject: RE NotifyInterests2 Table

RE NotifyInterests2 Table

Posted bymichael.fennell@fsa.gov.uk (Fennell, Michael) On 06-15-2012 05:07

Hi Bhupinder

Thanks for your reply, even though i am a little confused as to how i can decode this within my SQL

I dont suppose you have any piece of SQL showing the decoding method.

Regards

Mike.

[To post a comment, use the normal reply function]
Topic:	NotifyInterests2 Table
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Michael_Fennell

Hi Bhupinder

Thanks for this i was already looking into it too and even though the solution you sent covered if they select one intrest it did not cover all so i am going down the following approach

An Item is Added	8
An Item Status Change	8192
A Version Added	16
A Version Status Change	16384
A Compound Document Release-Revision Added	65536
An Item is Added/An Item Status Change	8200
An Item is Added/A Versions Added	24
An Item is Added/A Version Status Change	16392
An Item is Added/A Compound Document Release-Revision Added	65544
An Item is Added/An Item Status Change/A Version Added	8216
An Item is Added/An Item Status Change/A Version Added/A Version Status Change	24600
An Item is Added/An Item Status Change/A Version Added/A Version Status Change/A Compound Document Release-Revision Added	90136
An Item is Added/A Version Added	24
An Item is Added/A Version Added/A Version Status Change	16408
An Item is Added/A Version Added/A Version Status Change\A Compound Document Release-Revision Added	81944
An Item Status Change/A Version Added	8208
An Item Status Change/A Version Added/A Version Status Change	24592
An Item Status Change/A Version Added/A Version Status Change\A Compound Document Release-Revision Added	90128
An Item Status Change/A Version Status Change	24576
An Item Status Change/A Compound Document Release-Revision Added	73728
A Version Added/A Version Status Change	16400
A Version Added/A Version Status Change/A Compound Document Release-Revision Added	81936
A Version Status Change\A Compound Document Release-Revision Added	81920

Basically trying to cover all the variations, well only the ones i am concerned about i will then use an Oracle Decode statement to get the values.

Thanks again for your reply.

Mike.

Thomas Heusser

Hi,

thanks for sharing this.

I have the following Issue:

We need Notifications for dynamic generated Folder. Based on Naming-Conventions and Attributs, i know, which User needs Notification on which (newly created) folder. We should innitiate those Notifications, whithout that each User needs to add the notification himself (on folder they even do not know, that they (newly) exist).

I see 2 Approaches:

a) Doing somthing by Sheduled Live/Webreport

b) updating the Notification Table "automatically" and use the default Notification

Even i know, we should never do such things on Database level, i prefere the approach b) ... Any comments to that?

Thomas