Salesforce Knowledge Developer Guide

Introduction to Developing with Salesforce Knowledge
Setting Up a Development Organization
Building a Search Page with Visualforce Tags
Managing Articles using Apex and REST APIs
PublishingService Class
Archive the Master Version of an Article
Assign a Task Related to a Translation
Assign a Task Related to a Master Article
Delete a Master Version of an Article
Delete Translated Version of an Article
Edit an Online Version of a Master Article
Publish the Master Version of an Article
Restore an Archived Version of an Article
Retrieve Article Metadata
Retrieve a Version of an Article
Search for Metadata Elements of a Master Version
Search for Metadata Elements of a Translated Version
Set a Translated Article Version to Complete
Set a Translated Article Version to Incomplete
Submit an Article for Translation
Unpublish the Master Version of an Article
Unpublish the Online Version of a Translated Article
Update View Statistics with the Salesforce Object Query Language
Track Search Keywords with the Salesforce Object Search Language
Update Article View Statistics with the Salesforce Object Search Language
PDF

Newer Version Available

This content describes an older version of this product. View Latest

Update View Statistics with the Salesforce Object Query Language

The UPDATE VIEWSTAT clause is used in a SELECT statement to report on Salesforce Knowledge article searches and views. It allows developers to update an article’s view statistics.

You can use this syntax to increase the view count for every article you have access to online:

1SELECT Title FROM FAQ__kav
2WHERE PublishStatus='online' and
3Language = 'en_US' and
4KnowledgeArticleVersion = 'ka230000000PCiy'
5UPDATE VIEWSTAT