IBM Connections: Removing Posts on User Profile using SQL

'''IMPORTANT: Use at your own risk. No implied or specific warranties are given.'''

I use these commands to remove a post that Connections generate an error.

= = Get item id throught Firefox/Firebug

https:///connections/opensocial/rest/ublog/@me/@all/urn:lsid:lconn.ibm.com:profiles.note: 94d74bb1-136a-44ce-81f5-a0e370003b39

With item_id connect to HOMEPAGE database.

select * from HOMEPAGE.NR_STORIES where ITEM_ID = '94d74bb1-136a-44ce-81f5-a0e370003b39'; select * from HOMEPAGE.NR_DISCOVERY_VIEW where ITEM_ID = '94d74bb1-136a-44ce-81f5-a0e370003b39'; delete from HOMEPAGE.NR_DISCOVERY_VIEW where ITEM_ID = '94d74bb1-136a-44ce-81f5-a0e370003b39'; select * from HOMEPAGE.NR_PROFILES_VIEW where ITEM_ID = '94d74bb1-136a-44ce-81f5-a0e370003b39'; DELETE from HOMEPAGE.NR_PROFILES_VIEW where ITEM_ID = '94d74bb1-136a-44ce-81f5-a0e370003b39'; select * from HOMEPAGE.NR_STORIES where ITEM_ID = '94d74bb1-136a-44ce-81f5-a0e370003b39'; DELETE from HOMEPAGE.NR_STORIES where ITEM_ID = '94d74bb1-136a-44ce-81f5-a0e370003b39';

SELECT * from HOMEPAGE.NR_DISCOVERY_VIEW where ROLLUP_ENTRY_ID = '94d74bb1-136a-44ce-81f5-a0e370003b39'; DELETE from HOMEPAGE.NR_DISCOVERY_VIEW where ROLLUP_ENTRY_ID = '94d74bb1-136a-44ce-81f5-a0e370003b39'; SELECT * from HOMEPAGE.NR_PROFILES_VIEW where ROLLUP_ENTRY_ID = '94d74bb1-136a-44ce-81f5-a0e370003b39'; DELETE from HOMEPAGE.NR_PROFILES_VIEW where ROLLUP_ENTRY_ID = '94d74bb1-136a-44ce-81f5-a0e370003b39'; select * from HOMEPAGE.NR_STORIES where ITEM_CORRELATION_ID = '94d74bb1-136a-44ce-81f5-a0e370003b39'; DELETE from HOMEPAGE.NR_STORIES where ITEM_CORRELATION_ID = '94d74bb1-136a-44ce-81f5-a0e370003b39';

= Ver também =


 * IBM Connections: Listing who voted on ideation blog
 * IBM Connections:Reorg Connections Databases
 * IBM Connections:Limpeza de diretórios


 * Mais Artigos sobre IBM Connections IBM Connections