Defining custom delimiter for Django GROUP_CONCAT simulator

Asked Nov 01 '16 at 09:19

Active Nov 01 '16 at 09:19

Viewed 459 times

class Concat(Aggregate):
    # supports COUNT(distinct field)
    function = 'GROUP_CONCAT'
    template = '%(function)s(%(distinct)s%(expressions)s)'

    def __init__(self, expression, distinct=False, **extra):
        super(Concat, self).__init__(
            expression,
            distinct='DISTINCT ' if distinct else '',
            output_field=CharField(),
            **extra)

I have come across a splendid answer in Stackoverflow which provided a Django solution to simulate MySQL's GROUP_CONCAT. And now I am wondering how to set a delimiter for it in Django. I tried many possible options, among them '%(function)s(%(distinct)s% ", "(expressions)s)', but none of my attemps were successful. Any ideas ?

edited May 23 '17 at 10:30

Community

asked Nov 01 '16 at 09:19

Edgar Navasardyan

4,261
8
58
121

Why would you need delimeter here? – Sardorbek Imomaliev Nov 01 '16 at 10:35
In fact, I would like to insert a newline as delimiter, because I have a long line in my HTML table resulting in rows overlapping – Edgar Navasardyan Nov 04 '16 at 08:44

Defining custom delimiter for Django GROUP_CONCAT simulator

0 Answers0