Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Ben Williams 5 posts 95 karma points
    Feb 23, 2018 @ 01:19
    Ben Williams
    0

    Remove all blog posts

    Is there a way to remove/delete all blog posts listed in the archive instead of having to click the select all checkbox and click Delete on each page. I'm testing BlogML data import and when there's 150+ blog posted entered, it gets time-consuming deleting all the entries back out.

    Kind regards,

    Ben Williams

  • Dennis Aaen 4392 posts 17760 karma points admin hq c-trib
    Feb 23, 2018 @ 20:02
    Dennis Aaen
    0

    Hi Ben and welcome to Our, :)

    The archive node in the Articulate package are using the standard content list view. The great thing about this list view is that you can define how many items should be visible per page.

    So if you go the developer section --> Data Types --> Listview - Content then you will see something like this.

    enter image description here

    As you can see you can configure how many items that should be shown per page by changing the value in Page Size

    Hope this helps,

    /Dennis

  • Ben Williams 5 posts 95 karma points
    Mar 13, 2018 @ 04:31
    Ben Williams
    0

    Hello Dennis. Thank you for the tip.

  • Shannon Deminick 1444 posts 4861 karma points hq
    Feb 26, 2018 @ 07:03
    Shannon Deminick
    3

    Why not just delete the Archive node and then re-create it?

  • Ben Williams 5 posts 95 karma points
    Mar 11, 2018 @ 04:28
    Ben Williams
    100

    Thank you Shannon. I did not realize I could do that.

    The workaround I previously came up with shortly after posting my question was to run this SQL Server script:

    declare @blogParentId int
    set @blogParentId = 4777
    
    update [myumbracodb].[dbo].[umbracoNode] set trashed = 1, 
        parentID = -20, 
        level = 1, 
        path = ('-1,-20,' + CONVERT(varchar, id)) 
        where parentid = @blogParentId
    
  • Shannon Deminick 1444 posts 4861 karma points hq
    Mar 12, 2018 @ 03:49
    Shannon Deminick
    0

    You should definitely steer clear of running manual SQL scripts against Umbraco, without knowing all implications, this can cause you problems - least of which your caches and indexes will be out of sync.

  • Ben Williams 5 posts 95 karma points
    Mar 13, 2018 @ 04:30
    Ben Williams
    0

    Thank you. I did not realize that caches and indexes would be out of sync. Looks like I have more learning to do.

Please Sign in or register to post replies

Write your reply to:

Draft