Free Queries to reset article, downloads (etc) view counters

Modifications & Addon Releases Modification guides and addons are posted here to share with the community. Do not post requests in here!

Notices

Hi Unregistered. Please remember that third-party modifications are not supported or moderated by Kayako. Make sure you check that a modification released here works for your version of your Kayako software.

(#1)

Jamie Edwards Online

Operations Manager

Posts: 5,256

Join Date: Jan 2006

Location: United Kingdom

Queries to reset article, downloads (etc) view counters - 21-03-2008, 04:07 PM

Unfortunately this cannot be done via the interface, yet.

In the meantime, use these SQL queries to quickly do it (first is for KB articles, second for download items, third for troubleshooters.

Code:

UPDATE `DBNAME`.`swkbarticles` SET `views` = '0';
UPDATE `DBNAME`.`swdownloaditems` SET `totaldownloads` = '0'; 
UPDATE `DBNAME`.`swtroubleshootercat` SET `views` = '0';

To reset the counters for knowledgebase category number 20;

Code:

UPDATE `dmca_ss`.`swkbarticles`,`dmca_ss`.`swkbarticlelinks` SET swkbarticles.views = '0' WHERE swkbarticlelinks.kbcategoryid = 20 AND swkbarticles.kbarticleid = swkbarticlelinks.kbarticleid

Use the above query as a template as your own. It uses an implicit join to connect the articles to their respective categories.

Jamie Edwards (jamie.edwards ]at[ kayako.com)
-------------------------------------------------------------------

Submit bug reports here.
Submit support tickets via the members area.
Submit sales queries either via live chat or via e-mail.
There is no official ETA on Version 4.
This is not an official support forum - submit a support ticket.

Tags

article, counters, downloads, queries, reset

« Add display order by "Manage Departments" | Merging Tickets - Keep Oldest Ticket ID »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Knowledgebase Ability to reset article views globally, by category or by article	Jamie Edwards	Will Implement (V4)	1	20-08-2008 09:57 AM
How to VIEW a PRIVATE KB Article?	NC Software	How do I?	5	05-04-2008 12:42 PM
Back-Link missing on KB article view	grahl	Wont Implement / Already Implemented	2	10-12-2007 08:57 AM
Downloads 'View downloads' link when viewing download categories	Aaron	Feature Requests	0	16-11-2007 07:37 PM
[HOW-TO] Reset Article ID counters	rgvodden	SupportSuite, eSupport and LiveResponse	5	14-06-2006 02:40 PM