DealCustomFieldData
Create, modify, delete and query the available deal custom field data in ActiveCampaign.
Table Specific Information
Select
The 本製品 uses the ActiveCampaign API to process some of the filters.
For example, the following queries are processed server side:
SELECT * FROM DealCustomFieldData WHERE Id = 10003 SELECT * FROM DealCustomFieldData WHERE DealId = 1
Insert
Inserting a deal custom field data requires specifying a value for the DealId, CustomFieldId, and FieldValue columns.
Additionally, the 本製品 supports inserting deal custom fields data from the Deals table. See Deals for more information.
INSERT INTO DealCustomFieldData (FieldValue, CustomFieldId, DealId) VALUES ('custom field value', 1, 5)
Update
The 本製品 supports updating deal custom field data information. Updating deal custom field data requires specifying a value for the Id, DealId and CustomFieldId columns.
Additionally, it is possible to update deal custom fields data from the Deals table.
UPDATE DealCustomFieldData SET FieldValue = 'custom field value' WHERE Id = 8 AND DealId = 3 AND CustomFieldId = 2
Delete
The 本製品 supports removing deal custom field data.
DELETE FROM DealCustomFieldData WHERE Id = 10
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
The Id column of the DealCustomFieldData table. |
CreatedTimestamp | Datetime | False |
The CreatedTimestamp column of the DealCustomFieldData table. |
CustomFieldName | String | True |
The name of the custom field metum the field value relates to. |
CustomFieldId | Integer | False |
The CustomFieldId column of the DealCustomFieldData table. |
DealCustomFieldMetumId | Integer | False |
The DealCustomFieldMetumId column of the DealCustomFieldData table. |
DealId | Integer | False |
The DealId column of the DealCustomFieldData table. |
FieldValue | String | False |
The FieldValue column of the DealCustomFieldData table. |
DealLink | String | False |
The DealLink column of the DealCustomFieldData table. |
DealCustomFieldMetumLink | String | False |
The DealCustomFieldMetumLink column of the DealCustomFieldData table. |
UpdatedTimestamp | Datetime | False |
The UpdatedTimestamp column of the DealCustomFieldData. |
FieldCurrency | String | False |
Value of the custom field currency type for a specific deal. This field is required when inserting currency custom fields. |
FieldType | String | False |
Value of the custom field currency type for a specific deal. This field is required when inserting currency custom fields. |