Show / Hide Table of Contents

Class SearchCriteriaTableInfo

Table 'SearchCriteria': Criteria storage for Selection and other Find mechanisms

Inheritance
Object
TableInfo
SearchCriteriaTableInfo
Implements
ICloneable
Inherited Members
TableInfo.ToString()
TableInfo.RegisterFields(FieldInfo[])
TableInfo.FieldInfoFromSoField(SoField)
TableInfo.Clone()
TableInfo.IsSameTable(TableInfo)
TableInfo.FindField(String)
TableInfo.ProtAll
TableInfo.HashCheckFields
TableInfo.TableName
TableInfo.DbName
TableInfo.IsDictionaryTable
TableInfo.All
TableInfo.Item[String]
TableInfo.PrimaryKeyField
Object.Equals(Object)
Object.Equals(Object, Object)
Object.ReferenceEquals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("SearchCriteria")]
public class SearchCriteriaTableInfo : 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 .

Fields

DictionaryTableName

Conceptual name of table SearchCriteria in the database dictionary: SearchCriteria

Declaration
public const string DictionaryTableName = "SearchCriteria"
Field Value
Type Description
String

Properties

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides
TableInfo.Definition

DictionaryTableNumber

Table number for table SearchCriteria 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
Int32

DisplayName

Field 'displayName' in table 'SearchCriteria': Dictionary type String[255], .NET type: String

Display name when these criteria are a saved archive filter

Declaration
public StringFieldInfo DisplayName { get; }
Property Value
Type Description
StringFieldInfo

LeftOuterJoin_SearchCriteriaGroup_SearchCriteriaId

Generated left outer join from the primary key SearchCriteriaId on this table, to SearchCriteriaGroup.SearchCriteriaId.

Declaration
public TargetedLeftOuterJoin<SearchCriteriaGroupTableInfo> LeftOuterJoin_SearchCriteriaGroup_SearchCriteriaId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SearchCriteriaGroupTableInfo>

Name

Field 'name' in table 'SearchCriteria': Dictionary type String[255], .NET type: String

Name of this criteria collection

Declaration
public StringFieldInfo Name { get; }
Property Value
Type Description
StringFieldInfo

OwnerGuiName

Field 'ownerGuiName' in table 'SearchCriteria': Dictionary type String[255], .NET type: String

Name of the owner GUI control, this is the GUI XML id in SIX.web

Declaration
public StringFieldInfo OwnerGuiName { get; }
Property Value
Type Description
StringFieldInfo

OwnerId

Field 'ownerId' in table 'SearchCriteria': Dictionary type RecordId, .NET type: Int32

Record ID in ownerTable that owns these criteria

Declaration
public Int32FieldInfo OwnerId { get; }
Property Value
Type Description
Int32FieldInfo

OwnerName

Field 'ownerName' in table 'SearchCriteria': Dictionary type String[255], .NET type: String

Name of owner; this is the archive provider name in NetServer/SIX.web

Declaration
public StringFieldInfo OwnerName { get; }
Property Value
Type Description
StringFieldInfo

OwnerTable

Field 'ownerTable' in table 'SearchCriteria': Dictionary type TableNumber, .NET type: Int16

Table number of table that owns these criteria

Declaration
public UInt16FieldInfo OwnerTable { get; }
Property Value
Type Description
UInt16FieldInfo

OwnerType

Field 'ownerType' in table 'SearchCriteria': Dictionary type Enum, .NET type: Int16

Selection, Reporter, FindProject, ...

Declaration
public FieldInfo OwnerType { get; }
Property Value
Type Description
FieldInfo

Registered

Field 'registered' in table 'SearchCriteria': Dictionary type UtcDateTime, .NET type: DateTime

Registered when

Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type Description
DateTimeFieldInfo

RegisteredAssociateId

Field 'registered_associate_id' in table 'SearchCriteria': Dictionary type FK, .NET type: Int32

Registered by whom

Declaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

RegisteredAssociateId_InnerJoin_Associate

Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

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

SearchCriteriaId

Field 'SearchCriteria_id' in table 'SearchCriteria': Dictionary type PK, .NET type: Int32

Primary key

Declaration
public Int32FieldInfo SearchCriteriaId { get; }
Property Value
Type Description
Int32FieldInfo

TextId

Field 'textId' in table 'SearchCriteria': Dictionary type FK, .NET type: Int32

Extra information (descriptive) for this Criteria set

Declaration
public Int32FieldInfo TextId { get; }
Property Value
Type Description
Int32FieldInfo

TextId_InnerJoin_Text

Generated join from the foreign key TextId in this table, to its target table TextTableInfo.

Declaration
public TargetedInnerJoin<TextTableInfo> TextId_InnerJoin_Text { get; }
Property Value
Type Description
TargetedInnerJoin<TextTableInfo>

Updated

Field 'updated' in table 'SearchCriteria': Dictionary type UtcDateTime, .NET type: DateTime

Last updated when

Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type Description
DateTimeFieldInfo

UpdatedAssociateId

Field 'updated_associate_id' in table 'SearchCriteria': Dictionary type FK, .NET type: Int32

Last updated by whom

Declaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

UpdatedAssociateId_InnerJoin_Associate

Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

UpdatedCount

Field 'updatedCount' in table 'SearchCriteria': Dictionary type UShort, .NET type: Int16

Number of updates made to this record

Declaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type Description
UInt16FieldInfo

Methods

IdxOwnerId(Int32)

Shortcut method for looking up using the database index OwnerId, which spans the following fields:

FieldDescription
OwnerIdRecord ID in ownerTable that owns these criteria
Declaration
public Restriction IdxOwnerId(int ownerId)
Parameters
Type Name Description
Int32 ownerId
Returns
Type Description
Restriction

IdxOwnerIdOwnerName(Int32, String)

Shortcut method for looking up using the database index OwnerIdOwnerName, which spans the following fields:

FieldDescription
OwnerIdRecord ID in ownerTable that owns these criteria
OwnerNameName of owner; this is the archive provider name in NetServer/SIX.web
Declaration
public Restriction IdxOwnerIdOwnerName(int ownerId, string ownerName)
Parameters
Type Name Description
Int32 ownerId
String ownerName
Returns
Type Description
Restriction

IdxOwnerIdOwnerTable(Int32, Int16)

Shortcut method for looking up using the database index OwnerIdOwnerTable, which spans the following fields:

FieldDescription
OwnerIdRecord ID in ownerTable that owns these criteria
OwnerTableTable number of table that owns these criteria
Declaration
public Restriction IdxOwnerIdOwnerTable(int ownerId, short ownerTable)
Parameters
Type Name Description
Int32 ownerId
Int16 ownerTable
Returns
Type Description
Restriction

IdxOwnerIdOwnerTableOwnerType(Int32, Int16, Int16)

Shortcut method for looking up using the database index OwnerIdOwnerTableOwnerType, which spans the following fields:

FieldDescription
OwnerIdRecord ID in ownerTable that owns these criteria
OwnerTableTable number of table that owns these criteria
OwnerTypeSelection, Reporter, FindProject, ...
Declaration
public Restriction IdxOwnerIdOwnerTableOwnerType(int ownerId, short ownerTable, short ownerType)
Parameters
Type Name Description
Int32 ownerId
Int16 ownerTable
Int16 ownerType
Returns
Type Description
Restriction

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top