How to add duration field to new entity

[Nishan Perera]

Hi,

I want to add duration field to new entity.

Eg: For case i need to add duration field. How can I add it ??

[Nishan Perera]

Hi,

I found a way to sort this. Please let me know if im wrong.

Path - client/custom/src/views/fields/Case.json

"duration": {
            "type": "duration",
            "start": "dateStart",
            "end": "dateEnd",
            "options": [300, 600, 900, 1800, 2700, 3600, 7200],
            "default": 300,
            "notStorable": true,
            "select": "TIMESTAMPDIFF(SECOND, call.date_start, call.date_end)",
            "orderBy": "duration {direction}"
}

and rebuild. Now its appear in field and layout. Please check and let me know if im wrong.

[yuri]

Hello,

Change 'call' to 'case'.

"select": "TIMESTAMPDIFF(SECOND, `case`.date_start, `case`.date_end)"

[Nishan Perera]

Hello,

Change 'call' to 'case'.

"select": "TIMESTAMPDIFF(SECOND, `case`.date_start, `case`.date_end)"

Hi Yuri, Thank you so much.

[Nishan Perera]

Here is the previous post for the same with better explanation

https://forum.espocrm.com/forum/general/29579-how-to-use-duration-fieldtype-in-my-object