"UsageStats"

• 2 minutes to read

This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.UsageStatsProvider inside NetServer's SODatabase assembly.

Supported Entities

Name	Description
"usageStats"	[usageStats]

Supported Columns

Name	Restriction	Description	OrderBy
getAllRows	bool	GetAll: Get all rows of archive - use with care, you may be fetching the whole database
getNoRows	bool	GetNone: Do not get any rows from the archive
usageStats_id	int	UsageStats Id: Db Id of UsageStats row	x
dateAndAssocId	int	Date & Associate: Encoded Week number since 2003 and Associate Id	x
date	None	Date: Stored as number of weeks since 2003 in Hi-Word of usagestats.associate_id column
associateId	None	Associate id
functionId	int	Function Id: Function Id is an action identifier e.g. Window Shown, Menu Item Selected	x
functionHiWord	None	Func Hi-Word: Hight-Word (16 Bit) of FunctionId
functionLoWord	None	Func Lo-Word: Low-Word (16 Bit) of FunctionId
subId	int	Sub Id: Sub Id is the key context for the action e.g a Window or MenuItem identifier	x
uses	int	Use count: Number of times this action was registered for the context identified by the subId key	x
subHiWord	None	Sub Hi-Word: Hight-Word (16 Bit) of SubId
SubLoWord	None	Sub Lo-Word: Low-Word (16 Bit) of SubId
subHiByte	None	Sub Hi-Byte: Hight-Byte (8 Bit) of SubId's Low Word
subLoByte	None	Sub Lo-Byte: Low-Byte (8 Bit) of SubId's Low Word
data1	int	Data 1: The Data 1 field is known to contain the encoded Build info of the Win client	x
data2	int	Data 2: Currently unused	x
data3	int	Data 3: Undefined use...	x
data4	int	Data 4: Undefined use...	x
data5	int	Data 5: Undefined use...	x
version	None	File version: Decoded Build info of client version number as Revision.Build

Sample

GET /api/v1/archive/UsageStats?$select=functionHiWord,uses
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv