Active Query Builder support area

Failed query validation by use of postgreSQL string_agg() function

Avatar
rainer kress
  • updated

In AQB Version 3.5.x I can use a postgreSQL string_agg() function within my sql and it worked. Now I had to add an order by to the string_agg() function. I got an error message about this unknown feature. So, I updated AQB to the current version 3.9.x. Now the effect is, that the sql parser eliminates the word "string_agg" out of the sql and generates a column with the parameters in brackets.
The correct function call is: string_agg(column, delimiter order by column)

How can this behavior be corrected?

Replies 5
Avatar
0
Andrey Zavyalov, PM

Hello Rainer,

thank you for report, it was a bug in SQL text emitting code, now it is fixed upstream, and the fix will be included in the next release.

Avatar
0
rainer kress

Hello Andrey,

thanks for the information. Will the "order by" clause be accepted too with that version?

Avatar
0
Andrey Zavyalov, PM

Hello Rainer,

yes, it is supported.

Avatar
0
rainer kress

Hello Andrey,

happy new year. When will the next version be released?

Avatar
0
rainer kress

Hello Andrey,

I see a new version, but no comment in the release notes corresponding to my issue. Is it fixed in that release?

Additional question: is it possible to use my_own_aggrgate function in AQB?