select
${IF(LEN(col)==0,"*",col)}
from table1 t
${IF(LEN(col)==0,"","group by "+col)}
当我下拉树选择一个值时,不报错,选择两个及以上时会报错,应该咋写呢?
分隔符,需要用逗号
${IF(LEN(col)==0,"","group by "+replace(col,"','",",")}
中间要是逗号,不能用','
${if(len(col)==0,"* --",""} ${replace(col,",",","','")}
${if(len(col)==0,"--","group by "} ${replace(col,",",","','")}