IBM Connections: Listing who voted on ideation blog

From Wiki

How to get who voted on ideation blog?

Open Connections, go to a community and go to Ideation Blog.

Get the url, and note for HANDLE_ID, https://connections.company.com/blogs/<HANDLE_ID>/?lang=en_us

Example:

https://connections.company.com/blogs/W74266639fc45_4d91_8205_20ce301b9973/?lang=en_us

Now, connect to BLOGS database and run this query, replacing the HANDLE_ID. See bellow:


SELECT WS.NAME,WLE.TITLE,RU.USERNAME,RU.FULLNAME
FROM BLOGS.WEBSITE WS,
	 BLOGS.ROLLERUSER RU, 
	 BLOGS.ROLLER_WEBLOGENTRY_RATING RWR,
	 BLOGS.WEBLOGENTRY WLE
WHERE 
  WS.HANDLE='W74266639fc45_4d91_8205_20ce301b9973' AND
  WS.EDITORTHEME='Ideation_Blog' AND
  WS.ID=RWR.WEBLOGID AND
  RWR.USERID=RU.ID AND
  RWR.ENTRYID=WLE.ID

Result (Example):

WS.NAME                                         WLE.TITLE            RU.USERNAME RU.FULLNAME
_____________________________________________   _________________    ______      _______________
Inovation on my Company                         Use LED Lamps?       fulano,     Fulano de Tal
Inovation on my Company                         Use LED Lamps?       ciclano     Ciclano de Tal
Inovation on my Company                         Use Recycled Paper?  asmith      Agent Smith
Inovation on my Company                         Use Recycled Paper?  neo         Neo
Inovation on my Company                         Use Recycled Paper?  morpheus    Morpheus


Ver também