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; } } }

Who has notification setup

David_Turpie

Is it possible to get a report listing users who have subscribed to an item?I am particularly interested in knowing which of my users have subscribed to a news areaThanksDavid

Find more posts tagged with

Comments

Martin_Gäckler

Here is a sample SQL:select distinct k.name "User Name", k.mailaddress "Mail Address", d.name "Node Name" from KUAF k, dtree d, notifyinterests2 n where k.id = n.userid and d.dataid = n.nodeid and n.nodeid in ( select dataid from dtree connect by prior dataid=parentid start with dataid=%1 )