optikalefx
Totals
Does Open JS-Grid include a way to generate "Total" row that displays the sum of the table column (assuming the data is numeric)?
It does not, That wouldn't be too easy either. You'd need to process the data on the load event and add a row doing the summation yourself. Not so simple unfortunately
Am I correct that it also does not support the use of MySQL Rollup with a group by, as "GROUP BY FIELD WITH ROLLUP"? I tried it several ways, but OpenJS-Grid rejected my syntax attempts.
Also, I was wondering, in cases where a query is beyond the scope of OpenJS-Grid, is it practical to put a completed query into the code?
Where is the query developed/called, i.e. where would I put the completed query to be used instead of the one that OpenJS-Grid develops?
You could do that, but then you couldn't use searching, paging, sorting, saving or deleting. Because those rely on knowing the parts of the query.
Thanks for the info. I guess you did not notice my question (2 above) "Am I correct that it also does not support the use of MySQL Rollup with a group by, as "GROUP BY FIELD WITH ROLLUP"? I tried it several ways, but OpenJS-Grid rejected my syntax attempts.".
Also, where is the query created?
Hi , I have downloaded and use your openJS grid, it is perfect,, thank you so much. but it is only white color style, so may I ask u how can we use the same black style with it's features like highlighting , etc ?? best regards,
my mean is the nice black theme show in your video and the blue highlight and selection of grid row...
pls explain if possible, thank you so much..