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