Show / Hide Table of Contents

Class TicketExtenderBase

This is the base class for all extenders that add Person fields to their base query. It handles all person-related fields, as well as having its own standard extenders for udef, email, phone and fax. Derived classes should simply implement the method to join a PersonTableInfo to the .

Inheritance
Object
ExtensibleColumnsBase
ExtenderBase<TicketTableInfo>
TableExtenderBase<TicketTableInfo>
TicketExtenderBase
FavouriteTicketExtender
PersonRequestExtender
SimpleTicketExtender
TicketConnectExtender
TicketMessageTicketExtender
TicketSelectionMemberExtender
TicketTicketExtender
Implements
IArchiveProviderQueryMapping
IArchiveExtender
IArchiveProviderDoesExtend
IArchiveProviderHasColumns
IArchiveProviderExtensible
Inherited Members
TableExtenderBase<TicketTableInfo>._ourTable
TableExtenderBase<TicketTableInfo>.ModifyQuery()
TableExtenderBase<TicketTableInfo>.TableToExtend
TableExtenderBase<TicketTableInfo>.MainTableName
ExtenderBase<TicketTableInfo>.SetJoin()
ExtenderBase<TicketTableInfo>.GetRankRestriction(FieldInfo)
ExtenderBase<TicketTableInfo>.StyleHintPrefix
ExtensibleColumnsBase._minuteFields
ExtensibleColumnsBase.Visible
ExtensibleColumnsBase.Invisible
ExtensibleColumnsBase.AllowOrderBy
ExtensibleColumnsBase.DenyOrderBy
ExtensibleColumnsBase.GetAllRestriction
ExtensibleColumnsBase.GetNoneRestriction
ExtensibleColumnsBase.SetParent(IArchiveProviderExtensible)
ExtensibleColumnsBase.AddAvailableColumn(ArchiveColumnInfo[])
ExtensibleColumnsBase.GetAvailableColumns()
ExtensibleColumnsBase.SetDesiredColumns(String[])
ExtensibleColumnsBase.SetOrderBy(ArchiveOrderByInfo[])
ExtensibleColumnsBase.SetOrderByMapping(String, String[])
ExtensibleColumnsBase.SetOrderByMapping(ArchiveColumnInfo, ArchiveColumnInfo[])
ExtensibleColumnsBase.SetPrefixes(String, String)
ExtensibleColumnsBase.SetLocalAbsolutePrefixes(String, String)
ExtensibleColumnsBase.SetIconHint(String)
ExtensibleColumnsBase.AddLocalRestriction(ArchiveRestrictionInfo[])
ExtensibleColumnsBase.AddExtensionProvider(IArchiveExtender)
ExtensibleColumnsBase.GetExtensionProviders()
ExtensibleColumnsBase.GetTableInfosFromExtensionProviders()
ExtensibleColumnsBase.PopulateRowFromReader(SoDataReader, ArchiveRow)
ExtensibleColumnsBase.SuppressTableResults(SoDataReader, TableInfo)
ExtensibleColumnsBase.SuppressDeepTableResults(SoDataReader, TableInfo)
ExtensibleColumnsBase.AddColumnNameOverride(String, String)
ExtensibleColumnsBase.ApplyColumnNameOverrides(ArchiveRow)
ExtensibleColumnsBase.AddSubExtenderMapping(String, ExtensibleColumnsBase[])
ExtensibleColumnsBase.WantColumnForOutput(String[])
ExtensibleColumnsBase.WantColumnForOutput(ArchiveColumnInfo[])
ExtensibleColumnsBase.WantColumnForOutput(List<ArchiveColumnInfo>)
ExtensibleColumnsBase.WantColumnForRestriction(String[])
ExtensibleColumnsBase.WantColumnForRestriction(ArchiveColumnInfo[])
ExtensibleColumnsBase.WantColumnForOrderBy(String[])
ExtensibleColumnsBase.GetColumnOrderBy(String)
ExtensibleColumnsBase.WantColumnForOrderBy(ArchiveColumnInfo[])
ExtensibleColumnsBase.WantColumnForAnything(String[])
ExtensibleColumnsBase.WantColumnForAnything(ArchiveColumnInfo[])
ExtensibleColumnsBase.IsQueryNeeded()
ExtensibleColumnsBase.IsQueryRestriction()
ExtensibleColumnsBase.GetLeftOuterOrInnerJoin(Equal)
ExtensibleColumnsBase.GetLeftOuterOrInnerJoin(Equal, Restriction)
ExtensibleColumnsBase.SetLeftOuterOrInnerJoin(Equal)
ExtensibleColumnsBase.SetLeftOuterOrInnerJoin(Equal, Restriction)
ExtensibleColumnsBase.MapReturnField(ArchiveSelect, FieldInfo, Boolean, String, ArchiveColumnInfo[])
ExtensibleColumnsBase.MapIdField(FieldInfo)
ExtensibleColumnsBase.MapAssociateField(FieldInfo, ArchiveColumnInfo)
ExtensibleColumnsBase.MapEjUserField(FieldInfo, ArchiveColumnInfo)
ExtensibleColumnsBase.MapSimpleReturnField(FieldInfo, ArchiveColumnInfo[])
ExtensibleColumnsBase.MapSimpleImageField(FieldInfo, ArchiveColumnInfo, Int32, Int32)
ExtensibleColumnsBase.MapPictureBlob(FieldInfo, ArchiveColumnInfo, BlobLinkType, Int32, Int32, Int32)
ExtensibleColumnsBase.MapSimpleCustomField(FieldInfo, ArchiveColumnInfo[])
ExtensibleColumnsBase.MapSimpleListReturnField(FieldInfo, String, ArchiveColumnInfo[])
ExtensibleColumnsBase.MapOrderByField(FieldInfo, ArchiveColumnInfo)
ExtensibleColumnsBase.ActivateAsLinkField(String, ArchiveColumnInfo[])
ExtensibleColumnsBase.HasAvailableColumn(String)
ExtensibleColumnsBase.AddAndInitializeExtensionProvider<ExtenderType>(ExtenderType, String, String)
ExtensibleColumnsBase.AddAndInitializeExtensionProvider<ExtenderType>(ExtenderType)
ExtensibleColumnsBase.HasRestriction(String)
ExtensibleColumnsBase.ExtractRestrictions(String)
ExtensibleColumnsBase.ExtractRestrictions(ArchiveColumnInfo)
ExtensibleColumnsBase.ExtractRestriction(String)
ExtensibleColumnsBase.ExtractRestriction(ArchiveColumnInfo)
ExtensibleColumnsBase.ProcessRestrictions()
ExtensibleColumnsBase.ProcessOrderBy()
ExtensibleColumnsBase.PopulateSimpleFields(SoDataReader, ArchiveRow)
ExtensibleColumnsBase.CalculateOrderbyValue(String, SoDataReader, ArchiveColumnData)
ExtensibleColumnsBase.AddDbInfo(ArchiveColumnData, FieldInfo)
ExtensibleColumnsBase.AddDbInfo(ArchiveColumnData, Int32)
ExtensibleColumnsBase.ForceDisable()
ExtensibleColumnsBase.GetAssociateData(Int32)
ExtensibleColumnsBase.GetEjUserData(Int32)
ExtensibleColumnsBase.GetColumnIndex(ArchiveColumnInfo)
ExtensibleColumnsBase.GetColumnIndexFromReader(SoDataReader, FieldInfo, Int32)
ExtensibleColumnsBase.ConvertDbTypeToString(Object, ExtensibleColumnsBase.DbColumnBinding)
ExtensibleColumnsBase.GetStandardTooltipHint(SoDataReader, FieldInfo)
ExtensibleColumnsBase.GetLinkHint(SoDataReader, String)
ExtensibleColumnsBase.SetNonZeroBoolRestriction(ArchiveColumnInfo)
ExtensibleColumnsBase.AddUpdatedByMapping(ArchiveColumnInfo, FieldInfo, FieldInfo)
ExtensibleColumnsBase.AddRegisteredMapping(ArchiveColumnInfo, FieldInfo, ArchiveColumnInfo, FieldInfo)
ExtensibleColumnsBase.AddLastUpdatedMapping(ArchiveColumnInfo, FieldInfo, FieldInfo)
ExtensibleColumnsBase.AddUpdatedBy(SoDataReader, ArchiveRow, ArchiveColumnInfo, FieldInfo, FieldInfo)
ExtensibleColumnsBase.AddUpdatedDate(SoDataReader, ArchiveRow, ArchiveColumnInfo, FieldInfo, FieldInfo)
ExtensibleColumnsBase.AddAssociateFullName(SoDataReader, ArchiveRow, ArchiveColumnInfo, FieldInfo[])
ExtensibleColumnsBase.GetIdFieldTag(SoDataReader)
ExtensibleColumnsBase.GetArchiveColumnName(SoField)
ExtensibleColumnsBase.ExtensibleHelper
ExtensibleColumnsBase.ColumnHelper
ExtensibleColumnsBase.RestrictionHelper
ExtensibleColumnsBase.Parent
ExtensibleColumnsBase.DisableSubtreeIfNoRestriction
ExtensibleColumnsBase.RestrictionSetForSubtree
ExtensibleColumnsBase.ForceQueryNeeded
ExtensibleColumnsBase.ForceRestriction
ExtensibleColumnsBase.BlockOrderBy
ExtensibleColumnsBase.IdField
ExtensibleColumnsBase.LastSubExtenderWins
ExtensibleColumnsBase.ParentPrimaryKey
ExtensibleColumnsBase.QuoteAlternativeId
ExtensibleColumnsBase.SaleId
ExtensibleColumnsBase.NamePrefix
ExtensibleColumnsBase.DisplayNamePrefix
ExtensibleColumnsBase.RootQuery
ExtensibleColumnsBase.OrderBySlots
ExtensibleColumnsBase.PopulateDisplayValue
ExtensibleColumnsBase.PopulateTooltipHint
ExtensibleColumnsBase.DebugXML
Object.ToString()
Object.Equals(Object)
Object.Equals(Object, Object)
Object.ReferenceEquals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Namespace: SuperOffice.CRM.ArchiveLists
Assembly: SoDataBase.dll
Syntax
public abstract class TicketExtenderBase : TableExtenderBase<TicketTableInfo>, IArchiveProviderQueryMapping, IArchiveExtender, IArchiveProviderDoesExtend, IArchiveProviderHasColumns, IArchiveProviderExtensible, IPlugin

Constructors

TicketExtenderBase(TicketExtenderBase.Features)

Construct the extender and all all standard extenders (all features)

Declaration
public TicketExtenderBase(TicketExtenderBase.Features features = TicketExtenderBase.Features.All)
Parameters
Type Name Description
TicketExtenderBase.Features features

Fields

_colActivated

Declaration
protected ArchiveColumnInfo _colActivated
Field Value
Type Description
ArchiveColumnInfo

_colAuthor

Declaration
protected ArchiveColumnInfo _colAuthor
Field Value
Type Description
ArchiveColumnInfo

_colCategoryFullName

Declaration
protected ArchiveColumnInfo _colCategoryFullName
Field Value
Type Description
ArchiveColumnInfo

_colClosedAt

Declaration
protected ArchiveColumnInfo _colClosedAt
Field Value
Type Description
ArchiveColumnInfo

_colConnectId

Declaration
protected ArchiveColumnInfo _colConnectId
Field Value
Type Description
ArchiveColumnInfo

_colContactId

Declaration
protected ArchiveColumnInfo _colContactId
Field Value
Type Description
ArchiveColumnInfo

_colContent

Declaration
protected ArchiveColumnInfo _colContent
Field Value
Type Description
ArchiveColumnInfo

_colCreatedAt

Declaration
protected ArchiveColumnInfo _colCreatedAt
Field Value
Type Description
ArchiveColumnInfo

_colDeadline

Declaration
protected ArchiveColumnInfo _colDeadline
Field Value
Type Description
ArchiveColumnInfo

_colFirstReadByOwner

Declaration
protected ArchiveColumnInfo _colFirstReadByOwner
Field Value
Type Description
ArchiveColumnInfo

_colFirstReadByUser

Declaration
protected ArchiveColumnInfo _colFirstReadByUser
Field Value
Type Description
ArchiveColumnInfo

_colHasAttachment

Declaration
protected ArchiveColumnInfo _colHasAttachment
Field Value
Type Description
ArchiveColumnInfo

_colLanguageCode

Declaration
protected ArchiveColumnInfo _colLanguageCode
Field Value
Type Description
ArchiveColumnInfo

_colLastChanged

Declaration
protected ArchiveColumnInfo _colLastChanged
Field Value
Type Description
ArchiveColumnInfo

_colNumberOfMessages

Declaration
protected ArchiveColumnInfo _colNumberOfMessages
Field Value
Type Description
ArchiveColumnInfo

_colNumberOfReplies

Declaration
protected ArchiveColumnInfo _colNumberOfReplies
Field Value
Type Description
ArchiveColumnInfo

_colOrigin

Declaration
protected ArchiveColumnInfo _colOrigin
Field Value
Type Description
ArchiveColumnInfo

_colOwnedBy

Declaration
protected ArchiveColumnInfo _colOwnedBy
Field Value
Type Description
ArchiveColumnInfo

_colPersonId

Declaration
protected ArchiveColumnInfo _colPersonId
Field Value
Type Description
ArchiveColumnInfo

_colPriorityName

Declaration
protected ArchiveColumnInfo _colPriorityName
Field Value
Type Description
ArchiveColumnInfo

_colReadByCustomer

Declaration
protected ArchiveColumnInfo _colReadByCustomer
Field Value
Type Description
ArchiveColumnInfo

_colReadByOwner

Declaration
protected ArchiveColumnInfo _colReadByOwner
Field Value
Type Description
ArchiveColumnInfo

_colReadStatus

Declaration
protected ArchiveColumnInfo _colReadStatus
Field Value
Type Description
ArchiveColumnInfo

_colRealTimeSpentExternally

Declaration
protected ArchiveColumnInfo _colRealTimeSpentExternally
Field Value
Type Description
ArchiveColumnInfo

_colRealTimeSpentInternally

Declaration
protected ArchiveColumnInfo _colRealTimeSpentInternally
Field Value
Type Description
ArchiveColumnInfo

_colRealTimeSpentQueue

Declaration
protected ArchiveColumnInfo _colRealTimeSpentQueue
Field Value
Type Description
ArchiveColumnInfo

_colRealTimeToClose

Declaration
protected ArchiveColumnInfo _colRealTimeToClose
Field Value
Type Description
ArchiveColumnInfo

_colRealTimeToReply

Declaration
protected ArchiveColumnInfo _colRealTimeToReply
Field Value
Type Description
ArchiveColumnInfo

_colRepliedAt

Declaration
protected ArchiveColumnInfo _colRepliedAt
Field Value
Type Description
ArchiveColumnInfo

_colSentimentScore

Declaration
protected ArchiveColumnInfo _colSentimentScore
Field Value
Type Description
ArchiveColumnInfo

_colSLevel

Declaration
protected ArchiveColumnInfo _colSLevel
Field Value
Type Description
ArchiveColumnInfo

_colStatus

Declaration
protected ArchiveColumnInfo _colStatus
Field Value
Type Description
ArchiveColumnInfo

_colSuggestedCategory

Declaration
protected ArchiveColumnInfo _colSuggestedCategory
Field Value
Type Description
ArchiveColumnInfo

_colTags

Declaration
protected ArchiveColumnInfo _colTags
Field Value
Type Description
ArchiveColumnInfo

_colTicketId

Declaration
protected ArchiveColumnInfo _colTicketId
Field Value
Type Description
ArchiveColumnInfo

_colTicketStatusName

Declaration
protected ArchiveColumnInfo _colTicketStatusName
Field Value
Type Description
ArchiveColumnInfo

_colTimeSpentExternally

Declaration
protected ArchiveColumnInfo _colTimeSpentExternally
Field Value
Type Description
ArchiveColumnInfo

_colTimeSpentInternally

Declaration
protected ArchiveColumnInfo _colTimeSpentInternally
Field Value
Type Description
ArchiveColumnInfo

_colTimeSpentQueue

Declaration
protected ArchiveColumnInfo _colTimeSpentQueue
Field Value
Type Description
ArchiveColumnInfo

_colTimeToClose

Declaration
protected ArchiveColumnInfo _colTimeToClose
Field Value
Type Description
ArchiveColumnInfo

_colTimeToReply

Declaration
protected ArchiveColumnInfo _colTimeToReply
Field Value
Type Description
ArchiveColumnInfo

_colTitle

Declaration
protected ArchiveColumnInfo _colTitle
Field Value
Type Description
ArchiveColumnInfo

ColCategoryFullName

Declaration
public const string ColCategoryFullName = "categoryFullName"
Field Value
Type Description
String

ColumnConnectId

Declaration
public const string ColumnConnectId = "connectId"
Field Value
Type Description
String

ColumnStatus

Declaration
public const string ColumnStatus = "status"
Field Value
Type Description
String

ColumnTicketId

Declaration
public const string ColumnTicketId = "ticketId"
Field Value
Type Description
String

Properties

HasTicketIdRestriction

Having the ticketId restriction specified (or not), can influence the behaviour of the system (see request.onlyOwnCategories preference)

Declaration
public bool HasTicketIdRestriction { get; }
Property Value
Type Description
Boolean

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.TicketTableInfo>.InnerModifyQuery()

InnerPopulateRowFromReader(SoDataReader, ArchiveRow)

Derived classes should implement the population of ColumnData items for columns that are NOT handled by this base class in this method. Whether a column is handled by this base class is part of its database binding information, set by the various MapXXX methods.

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

Data reader with the query result (one row)

ArchiveRow row

archive row to be populated

Overrides
SuperOffice.CRM.ArchiveLists.TableExtenderBase<SuperOffice.CRM.Data.TicketTableInfo>.InnerPopulateRowFromReader(SuperOffice.Data.SoDataReader, SuperOffice.CRM.ArchiveLists.ArchiveRow)

SetRestriction(ArchiveRestrictionInfo[])

Set the restriction for the query. This method sets the restrictions for this provider, as well as invoking the same call on all known extenders. Recursion will take it to the bottom. This method actually only saves the restriction specification for use during query processing.

Declaration
public override bool SetRestriction(params ArchiveRestrictionInfo[] restrictions)
Parameters
Type Name Description
ArchiveRestrictionInfo[] restrictions

Array of restrictions (implicit AND)

Returns
Type Description
Boolean
Overrides
ExtensibleColumnsBase.SetRestriction(ArchiveRestrictionInfo[])

Implements

IArchiveProviderQueryMapping
IArchiveExtender
IArchiveProviderDoesExtend
IArchiveProviderHasColumns
IArchiveProviderExtensible

Extension Methods

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