How can i do Select GROUP_CONCAT

Airprimus

Hello,

how is the following SQL query also possible via Datatables Editor?

SELECT s_article_configurator_option_relations.article_id, GROUP_CONCAT(s_article_configurator_options.name) AS configuration  
FROM s_article_configurator_options LEFT JOIN s_article_configurator_option_relations ON s_article_configurator_option_relations.option_id = s_article_configurator_options.id GROUP BY  s_article_configurator_option_relations.article_id;

Thanks,
Lars

rf1234

I assume this doesn't have to be updatable?

As far as I know you can only do this with Editor using a view. That works fine; I did it myself as well.

colin

It would be worth looking at this thread, also from @rf1234, that has a good explanations and examples,

Colin

rf1234

This thread might also be relevant: https://datatables.net/forums/discussion/comment/180279/#Comment_180279

In case you need to update your grouped view it shows how to update the base table(s) of that view using "on ValidatedEdit".