Dear,
I would like to display a field on the timeline of email activity on the account page.
On my activity custom object, i have add fields : dateRead, dateClick, dateBounce…
For example i would like to display dateClick if it is filled in.
So to know more about the account tile :
select *, [Data], cast('' as xml).value('xs:base64Binary(sql:column("Data"))', 'varchar(max)')
from TimelinePageSetting
if i decode the base64 account page result :
[
{
"entityConfigKey": "706f803d-6a30-4bcd-88e8-36a0e722ea41",
"entitySchemaName": "Activity",
"referenceColumnName": "Account",
"masterRecordColumnName": "Id"
},
{
"entityConfigKey": "09a70391-b767-40ab-97b8-6d1b538adbe6",
"entitySchemaName": "Activity",
"typeColumnName": "Type",
"typeColumnValue": "e2831dec-cfc0-df11-b00f-001d60e938c6",
"referenceColumnName": "Account",
"masterRecordColumnName": "Id"
}, …
I have two activity results.
The email tile activity seems to be the second line.
select Name, [Data],cast('' as xml).value('xs:base64Binary(sql:column("Data"))', 'varchar(max)')
from TimelineTileSetting
After decode, here’s the json in the db :
{
"entitySchemaName": "Activity",
"typeColumnValue": "e2831dec-cfc0-df11-b00f-001d60e938c6",
"viewModelClassName": "Terrasoft.UsrEmailTimelineItemViewModel",
"viewClassName": "Terrasoft.UsrEmailTimelineItemView",
"orderColumnName": "SendDate",
"authorColumnName": "SenderContact",
"messageColumnName": "Body",
"filters": {
"ownerFilter": {
"comparisonType": 15,
"existsFilterColumnName": "[ActivityParticipant:Activity].Id",
"subFilterColumnName": "Participant"
}
},
"columns": [{
"columnName": "Title",
"isSearchEnabled": true,
"columnAlias": "Subject"
},{
"columnName": "Sender",
"columnAlias": "AuthorEmail"
},{ "columnName": "Recepient",
"columnAlias": "RecipientEmail"
},{ "columnName": "Contact",
"columnAlias": "Recipient"
}]
}
I have changed
"viewModelClassName": "Terrasoft.EmailTimelineItemViewModel",
"viewClassName": "Terrasoft.EmailTimelineItemView",
by
"viewModelClassName": "Terrasoft.UsrEmailTimelineItemViewModel",
"viewClassName": "Terrasoft.UsrEmailTimelineItemView",
(to update :
UPDATE TimelineTileSetting
SET
Data=convert(varbinary(MAX),'{VAR json}')
WHERE Id='{VAR Id}'
)
I copied objects EmailTimelineItemViewModel and EmailTimelineItemView to UsrEmailTim…
But modifications i do on this two new objects are not displayed in the tile.
Did i do something wrong ?
Thank you !
Nico
