I'm hoping someone can help me out with this one, but we've been using the News and Rich Content functionality for about a year now (under the Content Library) and we're starting to build a number of articles that are showing as "Active" and "Published" even though the "News end date" value has passed.
I've been trying to find a way to create a scheduled job or something that runs periodically to mark articles where the "news end date" value has passed as "inactive" and "retired" but I am running into some roadblocks. When I look at the articles in either the Content Library or by viewing the content record in the 'sn_cd_content_news' table I see that the "Active" check box is able to be changed manually but the "State" value is greyed out.
I've tried running a couple variations of background scripts to test and get permission errors:
Security restricted: Write operation against 'sn_cd_content_news' from scope 'rhino.global' has been refused due to the table's cross-scope access policy
Has anyone had any success putting automation in place to curate old news articles or, better yet, is there an existing job/function that I need to activate that will help us with this? I'm trying to get ahead of this as I don't want to be years down the road trying to clean out old news articles from the views.
Best regards,
Ash
