View source for 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

 <nowiki>https://<CONNECTIONS_SERVER>/connections/opensocial/rest/ublog/@me/@all/urn:lsid:lconn.ibm.com:profiles.note:</nowiki>'''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]]

[[Category:IBM Connections]]
[[Category:Tuning IBM Connections]]