Bulk update extra-fields

•
Environment: cloud
• 1 minute to read
 • 1 minute to read
Extra Fields

Field Type

OperationTypes

Expected Field Values
Integer

Set

Values Count = 1

Values[0] = (int)

Clob and Varchar

SelectOne, Clear, SearchAndReplace, RegEx

Values Count = 0 to 7

SelectOne: 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

Date and DateTime

Set, Clear

Values Count = 1

Set:
Values[0] = (Date)
or
Values[0] = (DateTime)

Clear:
Sets date to min date: 1/1/0001 12:00:00 AM

Time

Set

Values Count = 1

Check:
Values[0] = (int)

Value:
Number of minutes since midnight.
TimeSpan Set, Clear

Values Count = 1

Set:
Values[0] = (int, day)
Values[1] = (int, hour)
Values[2] = (int, minute)

Clear:
Sets TimeSpan to 0
Bool Set

Values Count = 1

Check:

Values[0] = (int) 0 or 1
0 = False
1 = True
Float Set

Values Count = 1

Values[0] = (float)

CustomerId,
TicketId,
UserId,
AttachmentId,
CategoryId,
PriorityId,
FaqEntryId,
SaleId,
ProjectId,
AppointmentId,
ContactCategoryId,
BusinessId,
ExtraTableId

SelectOne, Clear

Values Count = 1

Set:
Values[0] = (int)

Clear:
Sets value to 0
Link: Not Supported