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 Offline

Operations Manager

Posts: 5,451

Join Date: Jan 2006

Location: United Kingdom

Queries to reset article, downloads (etc) view counters - 21-03-2008, 05: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.
PyLiveResponse - open source LiveResponse for Mac, Linux

Tags

article, counters, downloads, queries, reset

« XOOPS LoginShare implemented :-) | Change Ticket ID depending of your department »

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 10:57 AM
How to VIEW a PRIVATE KB Article?	NC Software	How do I?	5	05-04-2008 01:42 PM
Back-Link missing on KB article view	grahl	Wont Implement / Already Implemented	2	10-12-2007 09:57 AM
Downloads 'View downloads' link when viewing download categories	Aaron	Feature Requests	0	16-11-2007 08:37 PM
[HOW-TO] Reset Article ID counters	rgvodden	SupportSuite, eSupport and LiveResponse	5	14-06-2006 03:40 PM