Announcement

Collapse
No announcement yet.

Report problem

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Report problem

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

  • #2
    Hi Peter,

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

    PHP Code:
    ,
                
    "select""TIMESTAMPDIFF(SECOND, date_start, date_end)",
                
    "orderBy""duration {direction}" 
    It will look like
    PHP Code:
            "duration": {
                
    "type""duration",
                
    "start""dateStart",
                
    "end""dateEnd",
                
    "options": [9001800360072001080086400],
                
    "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

    Comment


    • #3
      Thank you very much

      Comment

      Working...
      X