Setting delimiter in the QgsAggregateCalculator

Question

With PyQGIS I want to aggregate some fields in my layer. When I use:

mylayer.aggregate(QgsAggregateCalculator.StringConcatenate, myField)

Then I get a concatenated string without a delimiter. So I tried to add one but failed.

mylayer.aggregate(QgsAggregateCalculator.StringConcatenate, myField, delimiter=',')

QgsVectorLayerr.aggregate():'delimiter' is not a valid keyword argument

mylayer.aggregate(QgsAggregateCalculator.StringConcatenate, myField,
                  QgsAggregateCalculator.AggregateParameters(delimiter=','))

'delimiter' is an unknown keyword argument

mylayer.aggregate(QgsAggregateCalculator.StringConcatenate, myField, 
                  QgsAggregateCalculator.AggregateParameters(delimiter(',')))

name 'delimiter' not defined

mylayer.aggregate(QgsAggregateCalculator.StringConcatenate, myField,
                  QgsAggregateCalculator.AggregateParameters.delimiter(','))

'AggregateParameters' object attribute 'delimiter' is an instance attribute

mylayer.aggregate(QgsAggregateCalculator.StringConcatenate, myField,
                  QgsAggregateCalculator.AggregateParameters.setDelimiter(','))

AttributeError: type object 'AggregateParameters' has no attribute 'setDelimiter'

mylayer.aggregate(QgsAggregateCalculator.StringConcatenate, myField,
                  QgsAggregateCalculator.delimiter(','))

TypeError: QgsAggregateCalculator.delimiter(): first argument of unbound method must have type 'QgsAggregateCalculator'

The help, that shows up when I type the expression, says:

aggregate(QgsAggregateCalculator.Aggregate, QString, QgsAggregateCalculator.AggregateParameters parameters=QgsAggregateCalculator.AggregateParameters(), QgsExpressionContext context=None)

It looks like, if you don't provide parameters, it would use the standard parameters. So I tried QgsAggregateCalculator(mylayer).setDelimiter(','), but that doesn't make any difference. The concatenated string still doesn't contain a delimiter.

So what am I missing here?

score 7 · Accepted Answer · edited Nov 19 '22 at 12:18

7

Use the QgsAggregateCalculator like this:

params = QgsAggregateCalculator.AggregateParameters()
params.delimiter = ","
aggr = mylayer.aggregate(QgsAggregateCalculator.StringConcatenate, myField, params)

edited Nov 19 '22 at 12:18

Taras

32,823
4
66
137

answered Feb 12 '22 at 13:58

Kadir Şahbaz

76,800
56
247
389

Thanks a lot, this works. I think, i wouldn't have found this solution in years. – André Feb 12 '22 at 14:54

Setting delimiter in the QgsAggregateCalculator

1 Answers1

Linked