Class WebAppUsageTableInfo
Table 'WebAppUsage': Usage statistics for web applications
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("WebAppUsage")]
public class WebAppUsageTableInfo : TableInfo, ICloneable
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().
Fields
DictionaryTableName
Conceptual name of table WebAppUsage in the database dictionary: WebAppUsage
Declaration
public const string DictionaryTableName = "WebAppUsage"
Field Value
| Type | Description |
|---|---|
| string |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().
Properties
AggregateBin
Field 'aggregateBin' in table 'WebAppUsage': Dictionary type UInt, .NET type: uint
Bin no. If this is aggregated dataDeclaration
public FieldInfo AggregateBin { get; }
Property Value
| Type | Description |
|---|---|
| FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().
AggregateCount
Field 'aggregateCount' in table 'WebAppUsage': Dictionary type UInt, .NET type: uint
Bin count, if this is aggregated dataDeclaration
public FieldInfo AggregateCount { get; }
Property Value
| Type | Description |
|---|---|
| FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().
AssocId
Field 'assocId' in table 'WebAppUsage': Dictionary type FK, target: Associate, .NET type: int
ID of associateDeclaration
public Int32FieldInfo AssocId { get; }
Property Value
| Type | Description |
|---|---|
| Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().
AssocId_InnerJoin_Associate
Generated join from the foreign key AssocId in this table, to its target table AssociateTableInfo.
Declaration
public TargetedInnerJoin<AssociateTableInfo> AssocId_InnerJoin_Associate { get; }
Property Value
| Type | Description |
|---|---|
| TargetedInnerJoin<AssociateTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
| Type | Description |
|---|---|
| SoTable |
Overrides
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().
DictionaryTableNumber
Table number for table WebAppUsage in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database
Declaration
public int DictionaryTableNumber { get; }
Property Value
| Type | Description |
|---|---|
| int |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().
RuntimeDefinition
Definition of the table as described in the deployed runtime dictionary
Declaration
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }
Property Value
| Type | Description |
|---|---|
| SoTable |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().
Timestamp
Field 'timestamp' in table 'WebAppUsage': Dictionary type DateTime, .NET type: DateTime
Time stamp of operationDeclaration
public DateTimeFieldInfo Timestamp { get; }
Property Value
| Type | Description |
|---|---|
| DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().
Version
Field 'version' in table 'WebAppUsage': Dictionary type UInt, .NET type: uint
Version number of usage statsDeclaration
public FieldInfo Version { get; }
Property Value
| Type | Description |
|---|---|
| FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().
ViewState
Field 'viewState' in table 'WebAppUsage': Dictionary type String[255], .NET type: string
Current view state, excluding dataDeclaration
public StringFieldInfo ViewState { get; }
Property Value
| Type | Description |
|---|---|
| StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().
WebAppUsageId
Field 'WebAppUsage_id' in table 'WebAppUsage': Dictionary type PK, .NET type: int
Primary keyDeclaration
public Int32FieldInfo WebAppUsageId { get; }
Property Value
| Type | Description |
|---|---|
| Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().
Methods
IdxViewState(string)
Shortcut method for looking up using the database index ViewState, which spans the following fields:
| Field | Description |
|---|---|
| ViewState | Current view state, excluding data |
Declaration
public Restriction IdxViewState(string viewState)
Parameters
| Type | Name | Description |
|---|---|---|
| string | viewState |
Returns
| Type | Description |
|---|---|
| Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().
IdxViewStateTimestamp(string, DateTime)
Shortcut method for looking up using the database index ViewStateTimestamp, which spans the following fields:
| Field | Description |
|---|---|
| ViewState | Current view state, excluding data |
| Timestamp | Time stamp of operation |
Declaration
public Restriction IdxViewStateTimestamp(string viewState, DateTime timestamp)
Parameters
| Type | Name | Description |
|---|---|---|
| string | viewState | |
| DateTime | timestamp |
Returns
| Type | Description |
|---|---|
| Restriction |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetWebAppUsageInfo().