| Code Block | ||
|---|---|---|
| ||
select AQB__Type__c,RecordType.name RecordType, count(id) from AQB__ActivityReport__c task group by AQB__Type__c,RecordType.name order by RecordType.name |
...
AQB__ReportStatus__c | EmailMessage | Comment | Data in Production |
AQB__Subject__c | Subject | EmailMessage is text and longer, no issue |
|
RecordTypeId | EmailMessage does not have record type |
| |
AQB__Date__c | MessageDate | date to datetime, should be no issue |
|
AQB__Type__c | EmailMessage is already an email so no need to map the type |
| |
AQB__EssentialMove__c | field does not exist in EmailMessage |
| |
AQB__Purpose__c | field does not exist in EmailMessage |
| |
AQB__ReportStatus__c | Status
| EmailMessage status picklist values are 1-5 This needs to be set to other than draft, otherwise only the createdby user will be able to view the record |
|
USYD_Sub_Purpose__c |
| field does not exist in EmailMessage | |
AQB__Status__c | Status | EmailMessage status picklist values are 1-5 | |
AQB__Account__c | AQB__Account__c |
| |
AQB__Account__c | RelatedToId |
| |
Usyd_Account_2__c |
| field does not exist in EmailMessage | |
AQB__Opportunity__c | AQB__Opportunity__c | field does not exist in EmailMessage |
|
AQB__Result__c | HtmlBody | Rich text vs HTML |
|
Name |
| not mapped |
|
OwnerId | OwnerId |
|
|
CreatedById | CreatedById |
|
|
CreatedDate | CreatedDate |
|
|
LastModifiedById | LastModifiedById |
|
|
LastModifiedDate | LastModifiedDate |
|
|