IBM Connections: Removing Posts on User Profile using SQL

From Wiki
Revision as of 21:26, 29 June 2016 by Ebasso (talk | contribs) (Criou página com: ''''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 i...')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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