Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...Limiting storage of Feedback EntriesLimiting storage of Feedback Entries
Previous
 
Next
New Post
1/5/2011 4:26 PM
 
Is there a provision in the Feedback Module (I'm using 4.4.3) to limit the number of entries that the Feedback Module keeps in the database?
Is there a way to "mass delete" old, or outdated entries, or do I need to go to the database table directly and delete them there?

thanks!
 
New Post
1/5/2011 8:03 PM
 
Both of those features would be good ones but are not currently available in Feedback module v 4.04.03. Please visit the Feedback project's issue tracker at http://dnnfeedback.codeplex.com/worki... and add them (separately) as feature requests. That way they will be considered for implementation in future versions, most likely by adding a multi-select checkbox and command buttons  for Archive, Publish, Delete, etc. to the Moderate/Management page and by creating a custom scheduler task to periodically delete Feedback entries with options for earliest date and maximum number of entries to retain.

In the meantime, the older entries would need to be deleted either by opening the database's Feedback table for editing in SQL Server Management Studio or similar tool, then selecting multiple rows and then delete. Even better would be to execute a simple delete query based on the CreatedOnDate column. The query could also be created and run in the Host-->SQL page.

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
1/5/2011 10:18 PM
 
Thanks, Bill, I'll post those requests.
In the meantime, since I have not mastered SQL commands and queries, can you suggest a command line
I could use in Host>SQL to delete ALL feedback entries?
 
New Post
1/6/2011 7:46 AM
 
If you are sure that you want to delete ALL Feedback entries from ALL Feedback modules (including those in any other portals of the same DotNetNuke installation), you could execute the following in the Host-->SQL control:

TRUNCATE TABLE {databaseOwner}{objectQualifier}Feedback

Be sure that you check the "Execute as Script" checkbox to properly resolve the {databaseOwner} and {objectQualifier} tokens.


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
1/6/2011 5:36 PM
 
Thanks - it worked great. I was also looking at Mitchel Sellers free SQL Scheduler (here).
Can I create a Procedure to do this inside this Scheduler? Since I can only call a SQL Stored Procedure, where does one create a "SQL Stored Procedure" for this custom job type?
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...Limiting storage of Feedback EntriesLimiting storage of Feedback Entries


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out