Class SaintRestrictionExtenderBase

Base class for handling Saint restrictions - not column display (as yet anyway)

Inheritance
object
ExtensibleColumnsBase
ExtenderBase<CounterValueTableInfo>
SaintRestrictionExtenderBase
ContactSaintExtender
PersonSaintExtender
ProjectSaintExtender
SaleSaintExtender
Inherited Members
Namespace: SuperOffice.CRM.ArchiveLists
Assembly: SoDataBase.dll
Syntax
public abstract class SaintRestrictionExtenderBase : ExtenderBase<CounterValueTableInfo>, IArchiveProviderQueryMapping, IArchiveExtender, IArchiveProviderDoesExtend, IArchiveProviderHasColumns, IArchiveProviderExtensible
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

Constructors

SaintRestrictionExtenderBase(SaintTarget, string)

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
public SaintRestrictionExtenderBase(SaintTarget target, string iconHint)
Parameters
Type Name Description
SaintTarget target
string iconHint
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

Fields

CounterMask

Bitmask used for criteria storage for counters

Declaration
public const int CounterMask = 8388608
Field Value
Type Description
int
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

SaintActivityType

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
public const string SaintActivityType = "saintActivityType"
Field Value
Type Description
string
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

SaintAllChoice

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
public const string SaintAllChoice = "-1"
Field Value
Type Description
string
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

SaintAmountClass

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
public const string SaintAmountClass = "saintAmountClass"
Field Value
Type Description
string
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

SaintDirection

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
public const string SaintDirection = "saintDirection"
Field Value
Type Description
string
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

SaintIntention

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
public const string SaintIntention = "saintIntention"
Field Value
Type Description
string
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

SaintSaleStatus

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
public const string SaintSaleStatus = "saintSaleStatus"
Field Value
Type Description
string
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

SaintTicketCategory

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
public const string SaintTicketCategory = "saintTicketCategory"
Field Value
Type Description
string
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

SaintTicketStatus

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
public const string SaintTicketStatus = "saintTicketStatus"
Field Value
Type Description
string
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

StatusId

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
public const string StatusId = "statusId"
Field Value
Type Description
string
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

StatusMask

Bitmask used for criteria storage for statuses

Declaration
public const int StatusMask = 8912896
Field Value
Type Description
int
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colLastActivity

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colLastActivity
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colLastCompletedActivity

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colLastCompletedActivity
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colLastCompletedSale

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colLastCompletedSale
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colLastCompletedTicket

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colLastCompletedTicket
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colLastDoByActivity

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colLastDoByActivity
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colLastDoBySale

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colLastDoBySale
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colLastDoByTicket

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colLastDoByTicket
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colLastSale

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colLastSale
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colLastTicket

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colLastTicket
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfActivities

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfActivities
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfActivitiesInPeriod

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfActivitiesInPeriod
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfActivitiesInPeriod2

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfActivitiesInPeriod2
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfActivitiesInPeriod3

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfActivitiesInPeriod3
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfNotCompletedActivities

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfNotCompletedActivities
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfNotCompletedActivitiesInPeriod

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfNotCompletedActivitiesInPeriod
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfNotCompletedActivitiesInPeriod2

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfNotCompletedActivitiesInPeriod2
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfNotCompletedActivitiesInPeriod3

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfNotCompletedActivitiesInPeriod3
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfNotCompletedSales

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfNotCompletedSales
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfNotCompletedSalesInPeriod

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfNotCompletedSalesInPeriod
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfNotCompletedSalesInPeriod2

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfNotCompletedSalesInPeriod2
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfNotCompletedSalesInPeriod3

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfNotCompletedSalesInPeriod3
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfNotCompletedTickets

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfNotCompletedTickets
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfNotCompletedTicketsInPeriod

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfNotCompletedTicketsInPeriod
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfNotCompletedTicketsInPeriod2

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfNotCompletedTicketsInPeriod2
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfNotCompletedTicketsInPeriod3

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfNotCompletedTicketsInPeriod3
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfSales

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfSales
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfSalesInPeriod

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfSalesInPeriod
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfSalesInPeriod2

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfSalesInPeriod2
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfSalesInPeriod3

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfSalesInPeriod3
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfTickets

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfTickets
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfTicketsInPeriod

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfTicketsInPeriod
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfTicketsInPeriod2

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfTicketsInPeriod2
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_colNumberOfTicketsInPeriod3

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected ArchiveColumnInfo _colNumberOfTicketsInPeriod3
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_scolActivityType

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
[AllowedMultitenantStatic]
protected static ArchiveColumnInfo _scolActivityType
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_scolAmountClass

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
[AllowedMultitenantStatic]
protected static ArchiveColumnInfo _scolAmountClass
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_scolDirection

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
[AllowedMultitenantStatic]
protected static ArchiveColumnInfo _scolDirection
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_scolIntention

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
[AllowedMultitenantStatic]
protected static ArchiveColumnInfo _scolIntention
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_scolSaleStatus

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
[AllowedMultitenantStatic]
protected static ArchiveColumnInfo _scolSaleStatus
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_scolTicketCategory

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
[AllowedMultitenantStatic]
protected static ArchiveColumnInfo _scolTicketCategory
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

_scolTicketStatus

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
[AllowedMultitenantStatic]
protected static ArchiveColumnInfo _scolTicketStatus
Field Value
Type Description
ArchiveColumnInfo
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

Properties

MainTableName

The name of the table that this node is the handler for

Declaration
public override string MainTableName { get; }
Property Value
Type Description
string
Overrides
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

TableToExtend

Return the table to extend, as defined by THIS extender class.

Declaration
public override TableInfo TableToExtend { get; }
Property Value
Type Description
TableInfo
Overrides
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

Methods

AddStatusDefCheck(Select, StatusValueTableInfo)

Add an additional join to the status monitor query, to exclude rows referring to status monitors that are either deleted or in the needsUpdate (dirty) state

Declaration
protected void AddStatusDefCheck(Select query, StatusValueTableInfo statusValueTable)
Parameters
Type Name Description
Select query
StatusValueTableInfo statusValueTable
Remarks

This logic needs to be in sync with the the StatusMonitorCache, so that the display of visual status monitors corresponds to their presence or absence in Selections based on the monitors

ConvertAllChoiceToDbValue(ArchiveRestrictionInfo, int)

The values that are used by the Saint system to denote the 'all' choice for various subrestrictions are not constant... But in netServer we try to hide that, and say -1. Here, we convert that -1 value to whatever is the appropriate database value.

Declaration
public static ArchiveRestrictionInfo ConvertAllChoiceToDbValue(ArchiveRestrictionInfo subRestriction, int allChoiceDbValue)
Parameters
Type Name Description
ArchiveRestrictionInfo subRestriction

Subrestriction to check
int allChoiceDbValue

Actual value to use for the 'all' choice
Returns
Type Description
ArchiveRestrictionInfo

Possibly modified clone of original restriction
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

ConvertDbValueToAllChoice(ArchiveRestrictionInfo, int)

The values that are used by the Saint system to denote the 'all' choice for various subrestrictions are not constant... But in netServer we try to hide that, and say -1. Here, we convert that -1 value to whatever is the appropriate.

Declaration
public static ArchiveRestrictionInfo ConvertDbValueToAllChoice(ArchiveRestrictionInfo subRestriction, int allChoiceDbValue)
Parameters
Type Name Description
ArchiveRestrictionInfo subRestriction

Subrestriction to check
int allChoiceDbValue

Actual value to use for the 'all' choice
Returns
Type Description
ArchiveRestrictionInfo

Possibly modified clone of original restriction
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

GetStatusIdFromStatusColumn(string)

Parse the name of a statusmonitor column to retrieve the ID

Declaration
public static int GetStatusIdFromStatusColumn(string columnName)
Parameters
Type Name Description
string columnName
Returns
Type Description
int
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

GetSubRestrictionColumnInfo(string)

Get archive column info for a subrestriction

Declaration
public static ArchiveColumnInfo GetSubRestrictionColumnInfo(string columnName)
Parameters
Type Name Description
string columnName

Name of subrestriction column
Returns
Type Description
ArchiveColumnInfo

Information object for column, or null if this was not a valid subrestriction
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

GetSubRestrictionNames(string)

Get the names of the subrestrictions that belong to a particular saint column

Declaration
public static string[] GetSubRestrictionNames(string columnName)
Parameters
Type Name Description
string columnName

Saint column name
Returns
Type Description
string[]

Array of subrestriction names, null if the column was not a saint column or had no subrestrictions
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

InnerModifyQuery()

Set up custom binding for each outer-level restriction (column)

Declaration
protected override void InnerModifyQuery()
Overrides
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

InnerPopulateRowFromReader(SoDataReader, ArchiveRow)

There is no population with values... could possibly have populated those that are used as restrictions, but it would take a little figuring to correctly map rows to subrestrictions

Declaration
protected override void InnerPopulateRowFromReader(SoDataReader reader, ArchiveRow row)
Parameters
Type Name Description
SoDataReader reader
ArchiveRow row
Overrides
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

IsSaintColumn(string)

Determine whether a certain column name is a saint column or not (statuses are parsed only for the saintStatus prefix, which is not bomb-proof but generally good enough)

Declaration
public static bool IsSaintColumn(string columnname)
Parameters
Type Name Description
string columnname

Column name, case sensitive
Returns
Type Description
bool

true if the column is a saint column
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

IsSaintEnabled(SoTable)

Is saint enabled for the current user, and the given parent entity

Declaration
public static bool IsSaintEnabled(SoTable ownerEntity)
Parameters
Type Name Description
SoTable ownerEntity
Returns
Type Description
bool
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

SetJoin()

Subclass contract: Implementations of this method should create the extenders' table information object, join it to the relevant parent, and return the table information instance

Declaration
protected override CounterValueTableInfo SetJoin()
Returns
Type Description
CounterValueTableInfo
Overrides
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

SetSaintCounterJoin(ArchiveSelect, CounterValueTableInfo, Restriction)

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected abstract void SetSaintCounterJoin(ArchiveSelect targetQuery, CounterValueTableInfo cvInfo, Restriction subClause)
Parameters
Type Name Description
ArchiveSelect targetQuery
CounterValueTableInfo cvInfo
Restriction subClause
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

SetSaintStatusJoin(ArchiveSelect, StatusValueTableInfo, Restriction)

Base class for handling Saint restrictions - not column display (as yet anyway)

Declaration
protected abstract void SetSaintStatusJoin(ArchiveSelect targetQuery, StatusValueTableInfo svInfo, Restriction subClause)
Parameters
Type Name Description
ArchiveSelect targetQuery
StatusValueTableInfo svInfo
Restriction subClause
Remarks

The purpose of this class is to handle restrictions on Saint criteria. Such restrictions represent the (so far only) use of subrestrictions within one ArchiveRestrictionInfo. A completely specified restriction targets one particular Saint counter, as a combination of restrictions on the CounterValue table and a choice of one counter or date field within that table.

Each complete restriction results in one (aliased) join with the CounterValue table, so if you specify a dozen restrictions then you will get a dozen joins. Due to reasonably efficient indexing this does not usually represent a problem, even with a good number of millions of rows.

Implements

Extension Methods