IBM Connections: Removing Posts on User Profile using SQL

From Wiki

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_SERVER>/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

Retrieved from "https://ebasso.net/wiki/index.php?title=IBM_Connections:_Removing_Posts_on_User_Profile_using_SQL&oldid=3590"