IBM Connections: Listing who voted on ideation blog

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//?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 =


 * IBM Connections:Reorg Connections Databases
 * IBM Connections:Limpeza de diretórios


 * Mais Artigos sobre IBM Connections IBM Connections