Jqxgrid aggregate datetime column

[sanjeevParticipant]

Hi,

I have a jqxgrid in which i have datetime column to enter time duration. for that, i have given cellformat as ‘HH:mm’
i want to display aggregate of duration in string format in aggregate row. i have implemented custom aggregate to calculate and return total duration.
but the code gives error since cellformat is given as ‘HH:mm’.

i have implemented a sample fiddle fiddle to demonstrate my problem.

http://jsfiddle.net/sanjeev123/hrxtpq9p/

please verify the aggregate method given in last column of jqxgrid. the code will works fine if we remove cellsformat: “HH:mm” from column. how to give cellsformat as string for aggregate cell only

[Peter StoevKeymaster]

Hi Sanjeev,

Your custom function will definitely raise an error.

  'dd': function (aggregatedValue,currentValue,column, record) {
                                     
              return 'fdgfg';
          }

Aggregates are for Aggregation of Numeric data. Dates are not so you cannot aggregate dates, even if your function was written correctly.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts