Subtotal: $30,902.00
Friends, could anyone suggest a solution for sorting Live Articles posts in the following scenario?
We sort by post date descending, but we now have foreign language groups translating past articles, so a publish date sort doesn't work. Most blogging tools I've used allow a post date override, but I don't see that option in Live Articles. I tried adding a custom field with the format YYYYMMDD, but I can't see how to add that field as a sort option.
Appreciate any suggestions you have. Thank you.
John
There is no UI to override or change post date of articles at this time.
But you can change it from database through SQL quary from LiveArticles_Article_Version table.
Thanks, Ashish. Unfortunately, I don't know SQL.
Please run following SQL quary from Persona bar > Settings > SQL Console to update publish date of article.
update LiveArticles_Article set PublishedOn='2020-06-05 15:16:11.337' where ArticleID=(select TOP 1 ArticleID from LiveArticles_Article_Version where title='ArticleTitle')
Note: In above query you should specify your desired publish date and title of that article where the text is bold.