Iam running modx on ubuntu machine.
[[!Rowboat?
&table=`[[++table_prefix]]site_tmplvar_contentvalues`
&tpl=`test_tpl`
&limit=`0`
&columns=`{"DATE_FORMAT(value,'%Y-%m-01') ":"seminar_month_value"," DATE_FORMAT(value,'%M, %Y')":"seminar_month_name"}`
&debug=`1`
&sortBy=`value`
&cacheResults=`0`
&where=`{"tmplvarid:=":7}`
]]
this code is working fine. But if I change
&columns=`{"DISTINCT DATE_FORMAT(value,'%Y-%m-01') ":"seminar_month_value","DATE_FORMAT(value,'%M, %Y')":"seminar_month_name"}`
It is running no results.
query generated.
SELECT DISTINCT DATE_FORMAT(value,'%Y-%m-01') AS `seminar_month_value`, DATE_FORMAT(value,'%M, %Y') AS `seminar_month_name` FROM `modx_site_tmplvar_contentvalues`
WHERE `tmplvarid` = 7
ORDER BY `value` ASC
While running same code in local windows system it is working fine. Please guide me how to add distinct in rowBoat