Report problem

[peterberlin]

Hi,
For reports that access "Event" modules, you can evaluate the duration. You can not sum the duration.
peter

[yuri]

Hi Peter,

In entityDefs of your entity (in custom dir) you need to append to duration field definition:

,
            "select": "TIMESTAMPDIFF(SECOND, date_start, date_end)",
            "orderBy": "duration {direction}" 

It will look like

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

In the next advanced pack release it will work. But duration sum will be displayed in seconds

[peterberlin]

Thank you very much