Removing entries from the ‘River of News’

The question of how an entry could be deleted from the ‘River of News’ (the ‘Discover’ tab on the Homepage) came up on the Lotus Connections Forum,  I’d been asked the same question some time ago by a customer (their issue was a status update that had been created and then was swiftly deleted but not before it added to the River of News), so whilst I was posting my response on the forum I thought it would be worth including it here.

To remove the entry we used the following process:

1. Find the event story UUID
a. Navigate to homepage and locate the entry title you want to delete.
b. View the page html source code from browser.
c. Search the entry title from the page html source code.
d. Locate the storyUUID around the occurrence of the title.

2. Remove the news record from database.
a. Connect to homepage database from command line.
b. Run following command and replace the storyUUID with the one you find in previous step.
select event_record_uuid from homepage.nr_news_records where news_records_id=’storyUUID’
delete from homepage.nr_news_records where event_record_uuid = ‘result from the previous select’