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
Like
Sorry for the inconvenience, but it actually works fine.
it would be nice to have an interface to manage the tiles
Hi Nicolas,
Thank you for this example and a new idea, we will give it to our developers.
Thank you for helping us make the system better.