Failed query validation by use of postgreSQL string_agg() function
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?
Hello Rainer,
There is definitely an e-mail delivery issue with our public forums, so I higly recommend using support tickets (https://support.activequerybuilder.com/user/tickets) for prolongation and other non-public issues, as I get notified faster then. Also please make sure that you don't post any private information to publically accessible forums like this.