groupBy() and text type columns

Suite and Optimus Suite 5
#1

I am using groupBy()

grid.png1294×95 3.96 KB


I would like to know:

  1. if it is possible to put into a group title value from the fifth column “COIL DESCR” (it is a sting and it always has the same values withing a group) and how?
  2. how can I format fourth column “BATCH”, so I it will be shown in a group title like “0016” instead of “16”. I’ve tried to use setNumberFormat(), but it didn’t solve the problem.

Thanks!

#2

For the formating of the group’s header you may use the mask attribute of groupBy() method:
docs.dhtmlx.com/doku.php?id=dhtm … ct_groupby