Hello, i use following query to display ticket's all status in one line rather multi-line.
select ticket,group_concat(newvalue) from ticket_change where ticket=75 and field='status' Output of query is 75 | new,assigned,closed it means i combine multiple row data into single column by a sql query. But when i put above query in trac for report generation, it raise error " Report execution failed: no such function: group_concat " is any other alternative way to get above result using sql query ?? Thanks, Rishikesh --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
