Jump to content

Browse Listings & Reviews Multiple Record Delete


Paul Gerth

Recommended Posts

It would be great if you could add a check box for each item (and a check box to select or deselect ALL at once) in the Browse Listings and Browse Reviews so it would be possible to delete more than one listing or review at a time.

 

Right now the only quick way to delete multiple records at once seems to be to delete the articles from the Article Manager and then use the following SQL statement:

 

DELETE FROM jos_jreviews_content WHERE contentid NOT IN (SELECT id FROM jos_content) 

 

This is especially important for JReviews CSV Import users as we tend to be moving a lot of data in and out and end up with a lot of orphaned Article records in the jos_jreviews_content table.

Link to comment
  • 5 months later...
  • 1 year later...
  • 4 months later...
  • 2 years later...
×
×
  • Create New...