• State Verified Answer
  • Replies 15 replies
  • Answers 4 answers
  • Subscribers 16 subscribers
  • Views 5302 views
  • Users 0 members are here
Options
Related

Deleting multiple articles via admin panel

Karl Barber

I have an article application containing many entries, over 30k and want to delete them all, in the admin panel I am allowed to delete all but it only seems to delete 100 entries

If I delete the application the content is not removed, the application is hidden but still exists in the platform, is there a way to remove it and all its content ? 

Parents
  • 0

    Hi Stephen 

    Further to this issue I ran a trace on the database and the lookup queries to locate articles to delete seemed to be running with no user id ? 

    If I manually re-ran the query from the trace it found zero records to process, but if I changed the user id passed in it worked fine 

    @SecureByUserId=0,@PermissionId='BBCD6087-5DCC-4E30-B5C2-808EE3E33AF8',@Fetch=100,@Offset=0

    e.g.

    @SecureByUserId=2100,@PermissionId='BBCD6087-5DCC-4E30-B5C2-808EE3E33AF8',@Fetch=100,@Offset=0

    I can supply the full queries if needed but didn't want to paste it publicly

Reply
  • 0

    Hi Stephen 

    Further to this issue I ran a trace on the database and the lookup queries to locate articles to delete seemed to be running with no user id ? 

    If I manually re-ran the query from the trace it found zero records to process, but if I changed the user id passed in it worked fine 

    @SecureByUserId=0,@PermissionId='BBCD6087-5DCC-4E30-B5C2-808EE3E33AF8',@Fetch=100,@Offset=0

    e.g.

    @SecureByUserId=2100,@PermissionId='BBCD6087-5DCC-4E30-B5C2-808EE3E33AF8',@Fetch=100,@Offset=0

    I can supply the full queries if needed but didn't want to paste it publicly

Children

About
Privacy Policy
Terms of use
Copyright 2024 Verint, Inc.
Powered by Verint Community