Class SearchCriterionRecordData

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the SearchCriterion table.

Inheritance
object
SearchCriterionRecordData
Inherited Members
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class SearchCriterionRecordData
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Constructors

SearchCriterionRecordData()

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the SearchCriterion table.

Declaration
public SearchCriterionRecordData()
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Fields

Active

Should this criterion be executed

Declaration
public short Active
Field Value
Type Description
short
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ColumnName

Column name from archive provider in NetServer/SIX.web

Declaration
public string ColumnName
Field Value
Type Description
string
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

CriterionId

Usually DbFieldId of field to be searched

Declaration
public int CriterionId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ExtraId

Extra info, forms part of the internal unique identification of the criterion

Declaration
public int ExtraId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

LinkType

Link type, AND or OR

Declaration
public short LinkType
Field Value
Type Description
short
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

OperatorId

Operator ID

Declaration
public short OperatorId
Field Value
Type Description
short
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

OperatorName

Operator name from archive provider

Declaration
public string OperatorName
Field Value
Type Description
string
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Parenthesis

Parenthesis value, positive is number of opening parentheses to prepend to this criterion, negative is the number of closing parentheses to append

Declaration
public short Parenthesis
Field Value
Type Description
short
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Rank

Ordering within this group

Declaration
public short Rank
Field Value
Type Description
short
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Registered

Registered when in UTC.

Declaration
public DateTime Registered
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

RegisteredAssociateId

Registered by whom

Declaration
public int RegisteredAssociateId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SearchCriteriaGroupId

Owning group

Declaration
public int SearchCriteriaGroupId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SearchCriterionId

Primary key

Declaration
public int SearchCriterionId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UdefIdentity

Extra info for searching udef fields, to keep track of actual field across layout changes

Declaration
public int UdefIdentity
Field Value
Type Description
int
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UniqueKey

Unique key (hash) from ArchiveRestrictionInfo

Declaration
public int UniqueKey
Field Value
Type Description
int
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Updated

Last updated when in UTC.

Declaration
public DateTime Updated
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdatedAssociateId

Last updated by whom

Declaration
public int UpdatedAssociateId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdatedCount

Number of updates made to this record

Declaration
public short UpdatedCount
Field Value
Type Description
short
Remarks

Please use this class instead of a full SearchCriterionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SearchCriterionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Extension Methods