GROUP_CONCAT is not working in dhtmlx data processor

Suite and Optimus Suite 5
#1

My database query is ,

$scheduler->render_sql("select * from datatable INNER JOIN tablestr ON FIND_IN_SET(tablestr.str_id , datatable.str_id) ",“id”,“start_time,end_time,name,section_id,color,GROUP_CONCAT(t_no) t_no”);

This executing without error but my generated sql is showing
“<t_no) t_n></t_no) t_n>”
Result is not displaying properly.Why group_concat() is not executing.

#2

You can try to use render_complex_sql instead of render_sql and move GROUP instruction in the SQL select code ( connector doesn’t expect to have anything except of names in the list of id fields )

#3

I tried it’s not working. Connector is not accepting. Can you give some example.

#4

Add the next line before render_sql

$scheduler->enable_log("some.txt");

Run the app again and some.txt will contain the exact sql code and detailed error info in case of server side error. Check the auto-generated sql, is it valid for your data or not.

#5

Thank you stalin . I could rectify issue. :slight_smile: