Start Building Professional
Web Apps Today

Concat alphanumeric in header

Hi support,

Im using groupBy function to show items grouped by a Doc ID. I want to show same ID plus a string loading from DB.
I've tried all the concat variants, with cast, convert, etc but It always shows me no sense characters in the header.

What i want to do is concat two columns values (in the DB) and use this new value to group in grid.

Here is my working code..

        mygrid.init();
        mygrid.customGroupFormat=function(text,count){ return text+" ("+ (count - 1) +" docs)" };
        mygrid.groupBy(4);


Thanks.

groupBy(ind) allow only to group grid content by values of specified column. You can concat two columns values and use this new value to group in grid.

Thats right. Im using MySql, and the CONCAT_WS function to concat both columns in the query. (actually im just concating an int column value with a 'text')
This is what im getting...
http://www.uploadfilesystem.com//viewimage.php?file=/imagenes/09/02/09/jg693492.jpg

Have you ever seen that?