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
TicketExtenderBase
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
Fields
_colActivated
Declaration
protected ArchiveColumnInfo _colActivated
Field Value
_colAuthor
Declaration
protected ArchiveColumnInfo _colAuthor
Field Value
_colCategoryFullName
Declaration
protected ArchiveColumnInfo _colCategoryFullName
Field Value
_colClosedAt
Declaration
protected ArchiveColumnInfo _colClosedAt
Field Value
_colConnectId
Declaration
protected ArchiveColumnInfo _colConnectId
Field Value
_colContactId
Declaration
protected ArchiveColumnInfo _colContactId
Field Value
_colContent
Declaration
protected ArchiveColumnInfo _colContent
Field Value
_colCreatedAt
Declaration
protected ArchiveColumnInfo _colCreatedAt
Field Value
_colDeadline
Declaration
protected ArchiveColumnInfo _colDeadline
Field Value
_colFirstReadByOwner
Declaration
protected ArchiveColumnInfo _colFirstReadByOwner
Field Value
_colFirstReadByUser
Declaration
protected ArchiveColumnInfo _colFirstReadByUser
Field Value
_colHasAttachment
Declaration
protected ArchiveColumnInfo _colHasAttachment
Field Value
_colLanguageCode
Declaration
protected ArchiveColumnInfo _colLanguageCode
Field Value
_colLastChanged
Declaration
protected ArchiveColumnInfo _colLastChanged
Field Value
_colNumberOfMessages
Declaration
protected ArchiveColumnInfo _colNumberOfMessages
Field Value
_colNumberOfReplies
Declaration
protected ArchiveColumnInfo _colNumberOfReplies
Field Value
_colOrigin
Declaration
protected ArchiveColumnInfo _colOrigin
Field Value
_colOwnedBy
Declaration
protected ArchiveColumnInfo _colOwnedBy
Field Value
_colPersonId
Declaration
protected ArchiveColumnInfo _colPersonId
Field Value
_colPriorityName
Declaration
protected ArchiveColumnInfo _colPriorityName
Field Value
_colReadByCustomer
Declaration
protected ArchiveColumnInfo _colReadByCustomer
Field Value
_colReadByOwner
Declaration
protected ArchiveColumnInfo _colReadByOwner
Field Value
_colReadStatus
Declaration
protected ArchiveColumnInfo _colReadStatus
Field Value
_colRealTimeSpentExternally
Declaration
protected ArchiveColumnInfo _colRealTimeSpentExternally
Field Value
_colRealTimeSpentInternally
Declaration
protected ArchiveColumnInfo _colRealTimeSpentInternally
Field Value
_colRealTimeSpentQueue
Declaration
protected ArchiveColumnInfo _colRealTimeSpentQueue
Field Value
_colRealTimeToClose
Declaration
protected ArchiveColumnInfo _colRealTimeToClose
Field Value
_colRealTimeToReply
Declaration
protected ArchiveColumnInfo _colRealTimeToReply
Field Value
_colRepliedAt
Declaration
protected ArchiveColumnInfo _colRepliedAt
Field Value
_colSentimentScore
Declaration
protected ArchiveColumnInfo _colSentimentScore
Field Value
_colSLevel
Declaration
protected ArchiveColumnInfo _colSLevel
Field Value
_colStatus
Declaration
protected ArchiveColumnInfo _colStatus
Field Value
_colSuggestedCategory
Declaration
protected ArchiveColumnInfo _colSuggestedCategory
Field Value
_colTags
Declaration
protected ArchiveColumnInfo _colTags
Field Value
_colTicketId
Declaration
protected ArchiveColumnInfo _colTicketId
Field Value
_colTicketStatusName
Declaration
protected ArchiveColumnInfo _colTicketStatusName
Field Value
_colTimeSpentExternally
Declaration
protected ArchiveColumnInfo _colTimeSpentExternally
Field Value
_colTimeSpentInternally
Declaration
protected ArchiveColumnInfo _colTimeSpentInternally
Field Value
_colTimeSpentQueue
Declaration
protected ArchiveColumnInfo _colTimeSpentQueue
Field Value
_colTimeToClose
Declaration
protected ArchiveColumnInfo _colTimeToClose
Field Value
_colTimeToReply
Declaration
protected ArchiveColumnInfo _colTimeToReply
Field Value
_colTitle
Declaration
protected ArchiveColumnInfo _colTitle
Field Value
ColCategoryFullName
Declaration
public const string ColCategoryFullName = "categoryFullName"
Field Value
ColumnConnectId
Declaration
public const string ColumnConnectId = "connectId"
Field Value
ColumnStatus
Declaration
public const string ColumnStatus = "status"
Field Value
ColumnTicketId
Declaration
public const string ColumnTicketId = "ticketId"
Field Value
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
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
Returns
Overrides
Implements
Extension Methods
EnumUtil.MapEnums<From, To>(From)