Inactivate or retire news articles past their end date

[Ashley Heath]

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

[Martin Friedel]

Hello, 

have you checked this similar Community question that contains answer from ServiceNow employee?
News Article (Content Puublishing) Still Published when inactive 

Martin

[Ankur Bawiskar]

@Ashley Heath 

seems you are trying to run the job/script from global scope.

Did you try from the correct scope?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ashley Heath]

Thanks Ankur, I was thinking the same but couldn't figure out how to change the application scope when using the Scripts - Background function to validate that it was working correctly. It looked like it only ran everything from the Global scope.

[Pooja_Patil · Accepted solution]

@Ashley Heath , this is a good candidate for idea portal.

You can create a scheduled job in Content Publishing scope, this will allow updates on sn_cd_content_news table.

Please mark this as Helpful / Accept the Solution if this helps.

[Pooja_Patil · Accepted solution]

Please mark this as Helpful / Accept the Solution if this helps.