Class AssociateExtenderBase

Extender for fetching associate information.

Inheritance
Object
ExtensibleColumnsBase
ExtenderBase<AssociateTableInfo>
TableExtenderBase<AssociateTableInfo>
AssociateExtenderBase
AppointmentAssociateExtender
AssociateAssociateExtender
CategoryMembershipAssociateExtender
ChatSessionAssociateExtender
ContactAssociateExtender
ContactSupportAssociateExtender
DocumentAssociateExtender
EmailItemAccountAssociateExtender
FormSubmissionAssociateExtender
MailingAssociateExtender
NumbersUpdatedAssociateExtender
PersonAssociateExtender
PersonCorrespondingAssociateExtender
ProjectAssociateExtender
RelationAssociateExtender
SaleAssociateExtender
SaleHistoryAssociateExtender
SelecteionAssociateExtender
SuperListColumnSizeAssociateExtender
SystemEventRegisteredAssociateExtender
TargetAssignmentValueAssociateExtender
TicketCreatedByExtender
TicketOwnedByExtender
WebAppUsageAssociateExtender
WorkflowAssociateExtender
Inherited Members
Namespace: SuperOffice.CRM.ArchiveLists
Assembly: SoDataBase.dll
Syntax
public abstract class AssociateExtenderBase : TableExtenderBase<AssociateTableInfo>, IArchiveProviderQueryMapping, IArchiveExtender, IArchiveProviderDoesExtend, IArchiveProviderHasColumns, IArchiveProviderExtensible, IPlugin
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

Constructors

AssociateExtenderBase()

Constructs a new associate extender base

Declaration
protected AssociateExtenderBase()
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

AssociateExtenderBase(AssociateExtenderBase.Features)

Constructs the associate cache with a given set of features

Declaration
protected AssociateExtenderBase(AssociateExtenderBase.Features features)
Parameters
Type Name Description
AssociateExtenderBase.Features features
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

Fields

_colAssociateId

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colAssociateId
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colAssocName

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colAssocName
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colAssocTooltip

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colAssocTooltip
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colAssocType

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colAssocType
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colAssocUserName

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colAssocUserName
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colContactCategory

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colContactCategory
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colContactDepartment

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colContactDepartment
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colContactFullName

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colContactFullName
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colContactId

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colContactId
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colContactName

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colContactName
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colCredType

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colCredType
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colCredValue

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colCredValue
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colEjDisplayName

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colEjDisplayName
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colEjStatus

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colEjStatus
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colEjUserId

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colEjUserId
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colFirstName

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colFirstName
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colFullName

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colFullName
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colIsActive

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colIsActive
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colIsActiveText

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colIsActiveText
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colIsLocation

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colIsLocation
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colLastName

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colLastName
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colLocationAddress

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colLocationAddress
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colMiddleName

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colMiddleName
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colMrMrs

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colMrMrs
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colOtherGroups

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colOtherGroups
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colPersonEmail

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colPersonEmail
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colPersonId

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colPersonId
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colPortrait

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colPortrait
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colRole

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colRole
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colSimultaneous

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colSimultaneous
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colTitle

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colTitle
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

_colUserGroup

Extender for fetching associate information.

Declaration
protected ArchiveColumnInfo _colUserGroup
Field Value
Type Description
ArchiveColumnInfo
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnAssociateId

Extender for fetching associate information.

Declaration
public const string ColumnAssociateId = "associateDbId"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnAssocName

Extender for fetching associate information.

Declaration
public const string ColumnAssocName = "assocName"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnAssocTooltip

Extender for fetching associate information.

Declaration
public const string ColumnAssocTooltip = "assocTooltip"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnAssocType

Extender for fetching associate information.

Declaration
public const string ColumnAssocType = "assocType"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnAssocUserName

Extender for fetching associate information.

Declaration
public const string ColumnAssocUserName = "userName"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnContactCategory

Extender for fetching associate information.

Declaration
public const string ColumnContactCategory = "contactCategory"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnContactDepartment

Extender for fetching associate information.

Declaration
public const string ColumnContactDepartment = "contactDepartment"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnContactFullName

Extender for fetching associate information.

Declaration
public const string ColumnContactFullName = "contactFullName"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnContactId

Extender for fetching associate information.

Declaration
public const string ColumnContactId = "contactId"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnContactName

Extender for fetching associate information.

Declaration
public const string ColumnContactName = "contactName"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnCredDisplayValue

Extender for fetching associate information.

Declaration
public const string ColumnCredDisplayValue = "credentialDisplayValue"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnCredType

Extender for fetching associate information.

Declaration
public const string ColumnCredType = "credentialType"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnEjDisplayName

Extender for fetching associate information.

Declaration
public const string ColumnEjDisplayName = "ejDisplayName"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnEjStatus

Extender for fetching associate information.

Declaration
public const string ColumnEjStatus = "ejStatus"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnEjUserId

Extender for fetching associate information.

Declaration
public const string ColumnEjUserId = "ejUserId"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnFirstName

Extender for fetching associate information.

Declaration
public const string ColumnFirstName = "firstName"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnFullName

Extender for fetching associate information.

Declaration
public const string ColumnFullName = "fullName"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnIsActive

Extender for fetching associate information.

Declaration
public const string ColumnIsActive = "isActive"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnIsLocation

Extender for fetching associate information.

Declaration
public const string ColumnIsLocation = "isLocation"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnLastName

Extender for fetching associate information.

Declaration
public const string ColumnLastName = "lastName"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnLocationAddress

Extender for fetching associate information.

Declaration
public const string ColumnLocationAddress = "locationAddress"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnMiddleName

Extender for fetching associate information.

Declaration
public const string ColumnMiddleName = "middleName"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnMrMrs

Extender for fetching associate information.

Declaration
public const string ColumnMrMrs = "mrMrs"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnOtherGroups

Extender for fetching associate information.

Declaration
public const string ColumnOtherGroups = "otherGroups"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnPersonEmail

Extender for fetching associate information.

Declaration
public const string ColumnPersonEmail = "personEmail"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnPersonId

Extender for fetching associate information.

Declaration
public const string ColumnPersonId = "personId"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnPortraitThumbnail

Extender for fetching associate information.

Declaration
public const string ColumnPortraitThumbnail = "portraitThumbnail"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnRole

Extender for fetching associate information.

Declaration
public const string ColumnRole = "role"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnSimultaneousEjUser

Extender for fetching associate information.

Declaration
public const string ColumnSimultaneousEjUser = "simultaneousEjUser"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnTitle

Extender for fetching associate information.

Declaration
public const string ColumnTitle = "title"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

ColumnUserGroup

Extender for fetching associate information.

Declaration
public const string ColumnUserGroup = "usergroup"
Field Value
Type Description
String
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

Properties

ContactRelatedColumns

Columns taken from the Contact table, used to filter available columns in providers that know something about the associate type (note that if don't have Person, then you surely can't have Contact)

Declaration
public static string[] ContactRelatedColumns { get; }
Property Value
Type Description
String[]
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

EjRelatedColumns

Columns taken from the EjUser table, used to filter available columns in providers that know something about the associate type

Declaration
public static string[] EjRelatedColumns { get; }
Property Value
Type Description
String[]
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

PersonRelatedColumns

Columns taken from the Person table, used to filter available columns in providers that know something about the associate type

Declaration
public static string[] PersonRelatedColumns { get; }
Property Value
Type Description
String[]
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

Methods

InnerModifyQuery()

Add/map return fields to the query; call SetJoin to obtain the contact table info instance from the derived class

Declaration
protected override void InnerModifyQuery()
Overrides
SuperOffice.CRM.ArchiveLists.ExtenderBase<SuperOffice.CRM.Data.AssociateTableInfo>.InnerModifyQuery()
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

InnerPopulateRowFromReader(SoDataReader, ArchiveRow)

Populate the archive row with columns that are not handled by the base class

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

Reader with data fields
ArchiveRow row

Row to be populated
Overrides
SuperOffice.CRM.ArchiveLists.TableExtenderBase<SuperOffice.CRM.Data.AssociateTableInfo>.InnerPopulateRowFromReader(SuperOffice.Data.SoDataReader, SuperOffice.CRM.ArchiveLists.ArchiveRow)
Remarks

This extender actually fetches data from up to four additional tables - person, possibly leading to contact; and ejuser, possibly leading to hierarchy. Due to the need to reorganize joins on the fly in the Users provider (which is quite complex), we need to manage the four additional tables here, instead of using the more standard extender / joiner pattern. The InnerModifyQuery method therefore has a bit of code to do this, and if you add columns that come from the extra tables, then you must also update the conditions for those joins.

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)