This is a report/SOQL to snapshot Activity Report data in production:
...
AQB__ReportStatus__c | Task | Comment | Data in Production | ||||||||||
AQB__Subject__c | Subject | we need a subject that is a text field, not a SF picklist field |
| ||||||||||
RecordTypeId | RecordTypeId |
|
| ||||||||||
AQB__Date__c | ActivityDate |
|
| ||||||||||
|
| picklist not match |
| ||||||||||
TaskSubtype | |||||||||||||
CallType | |||||||||||||
AQB__EssentialMove__c | AQB__EssentialMove__c | not on Task layout, raised a Jira ticket to surface
|
| ||||||||||
| AQB__Purpose__c |
|
| ||||||||||
| AQB__ReportStatus__c |
|
| ||||||||||
|
| not mapped | 989 | ||||||||||
AQB__ActivityDate__c |
| not mapped | 224,698 | ||||||||||
AQB__Account__c | AQB__Account__c |
|
| ||||||||||
AQB__Account__c | whatid |
|
| ||||||||||
|
|
|
| ||||||||||
Usyd_Account_2__c |
| not mapped | 205 | ||||||||||
AQB__Opportunity__c | AQB__Opportunity__c |
|
| ||||||||||
AQB__Result__c |
| we don't have a rich text box to map this to |
| ||||||||||
Name |
| not mapped |
| ||||||||||
OwnerId | OwnerId |
|
| ||||||||||
CreatedById | CreatedById |
|
| ||||||||||
CreatedDate | CreatedDate |
|
| ||||||||||
LastModifiedById | LastModifiedById |
|
| ||||||||||
LastModifiedDate | LastModifiedDate |
|
|
...
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 |
|
|