Ticket table

•
Environment: cloud
• 2 minutes to read
 • 2 minutes to read

Ticket fields. Key constants are in BulkUpdateSystem.TicketFieldValueKeys.

Ticket

FieldValueKeys

OperationTypes

Expected Field Values

Affected Properties

Author

Set, Clear, SearchAndReplace, RegEx

Values Count = 0 to 7

Set: Values[0] = (string)

Clear:
Clears value

SearchAndReplace:
Values[1] = searchString
Values[2] = replaceString
Values[3] = options

RegEx:
Values[4] = expression
Values[5] = replace with
Values[6] = options

Author

Title

Title

ActivateDate

Set

Values Count = 1

Values[0] = (datetime)

Activate

Deadline

Set

Values Count = 1

Values[0] = (datetime)

Deadline

ReadByOwner

Set

Values Count = 1

Values[0] = (datetime)

ReadByOwner

Category

SelectOne

Values Count = 1

Values[0] = (int) Category

Category

OriginalCategory

SelectOne

Values Count = 1

Values[0] = (int) OrigCategory

OrigCategory

InternalStatus

SelectOne

Values Count = 1

Values[0] = (int) Status

Status

Status

SelectOne

Values Count = 1

Values[0] = (int) TicketStatus

TicketStatus

Status

Activate

UserStatus

SelectOne

Values Count = 1

Values[0] = (int) TicketStatus

TicketStatus

ReadStatus

SelectOne

Values Count = 1

Values[0] = (int) ReadStatus

ReadStatus

Origin

SelectOne

Values Count = 1

Values[0] = (int) Origin

Origin

Priority

SelectOne

Values Count = 1

Values[0] = (int) Priority

Priority

OriginalPriority

SelectOne

Values Count = 1

Values[0] = (int) OrigPriority

OrigPriority

OwnedBy

SelectOne

Values Count = 1

Values[0] = (int) OwnedBy

OwnedBy

SecurityLevel

SelectOne

Values Count = 1

Values[0] = (int) Slevel

Slevel

Tags

addItems, removeItems, Clear

addItems:
Values Count = 0…n
Values[n] = (int)

removeItems:
Values Count = 1…n
Values[n] = (int)

Clear:
Clears all existing rows

Tags

MdoTag

Add, Remove, Clear

Values Count = 0…2

Add: if value doesn’t already exist
Values[0] = (string) value
Values[1] = (string) description

Remove:
Values[0] = (string) value

Clear:
Clears all existing rows

Tags

Sale

SelectOne

Values Count = 1

Values[0] = (int) SaleId

SaleId

Project

SelectOne

Values Count = 1

Values[0] = (int) ProjectId

ProjectId

TicketType

SelectOne

Values Count = 1

Values[0] = (int) TicketType

TicketType