Question

Edit the account page email activity timeline

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 0

Like

2 comments

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.

Show all comments