Concat alphanumeric in header

Discontinued products Uncategorized discussions
#1

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.







#2

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.

#3

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…
uploadfilesystem.com//viewim … 693492.jpg

Have you ever seen that?




#4
Solved. Just a type convertion trouble in the DB. Thank you.
Solved. Just a type convertion trouble in the DB. Thank you.