unusual SQL error with group_concat | Ben Bimber | 2011-05-10 15:24 |
Status: Closed | ||
ok, so that wasnt quite right, but i think I found 2 bugs: 1. the issue wasnt the group_concat itself. I had metadata that tried to give a URL to that column. the original XML was: <column columnName="previousObs"> <columnTitle>Previous Obs</columnTitle> <inputType>textarea</inputType> <url>/query/executeQuery.view?schemaName=study& query.queryName=irregularObsById& query.Id~eq=${Id} query.date~dateeq=${yesterday} </url> </column> The column 'yesterday' is a date. apparently that is what was throwing the date-to-string error. Seems like that is a bug. 2. If i get rid of that column and just use: <column columnName="previousObs"> <columnTitle>Previous Obs</columnTitle> <inputType>textarea</inputType> <url>/query/executeQuery.view?schemaName=study& query.queryName=irregularObsById& query.Id~eq=${Id} </url> </column> then some cells render correctly. they render correctly so long as the group_concat isnt actually concating anything together. In other words if there was only 1 value for that Id, the field renders correctly, with a URL. if more than 1 value is returned for that Id, in which case those values would get joined, then I get the error. seems like a separate bug. |
||