Active Query Builder support area

Failed query validation by use of postgreSQL string_agg() function

Avatar
  • updated
  • Fixed

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?

Avatar
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
rainer kress

Hello Andrey,

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

Avatar
Andrey Zavyalov, PM

Hello Rainer,

yes, it is supported.

Avatar
rainer kress

Hello Andrey,

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

Avatar
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?

Avatar
rainer kress

Hello Team,

 

I wish you a happy new year 2024. I had a 3-year subscription of ActiveQueryBuilder until November 09, 2023. Although I selected the checkbox “Prolongation e-mail notifications“ at your website, I didn’t get this e-mail in November 2023. I asked meanwhile three times via your website contact, how to reinstall the minimum 15% discount for my new 3-year prolongation I want do. I didn’t get an answer until now. How can you help me in that case?

 

Image 1626

 

 

Mit freundlichen Grüßen / kind regards

Rainer Kress

Senior Consultant, Datenschutzbeauftragter

Telefon:  +49 (89) 89 05 59 - 233

Mobil:     +49 (172) 8 16 96 05
__________________________


Dynaware Systemberatung GmbH
Welserstraße 1
81373 München
http://www.Dynaware.de

mailto:Rainer.Kress@Dynaware.de
Geschäftsführer: Dr. Alexander Bartmann

HRB 108659, Amtsgericht München
Steuernummer:
143 / 131 / 80582

Umsatzsteuer-ID: DE 169255951

__________________________

Avatar
rainer kress

Hello Team,

 

another 2 days are gone. When can I expect an answer for my questions?

 

Mit freundlichen Grüßen / kind regards

Rainer Kress

Senior Consultant, Datenschutzbeauftragter

Telefon:  +49 (89) 89 05 59 - 233

Mobil:     +49 (172) 8 16 96 05
__________________________


Dynaware Systemberatung GmbH
Welserstraße 1
81373 München
http://www.Dynaware.de

mailto:Rainer.Kress@Dynaware.de
Geschäftsführer: Dr. Alexander Bartmann

HRB 108659, Amtsgericht München
Steuernummer:
143 / 131 / 80582

Umsatzsteuer-ID: DE 169255951

__________________________


Attachments:
image001.png
Avatar
rainer kress

Hello Team,

 

this is at minimum my sixth e-mail to you. Until now I didn’t get any answer.

Again, my question is: you didn’t send me a reminder for the prolongation in November 2023, so I missed the date to get the additional 15% discount for a new 3-year subscription.

Is it possible that I can get a quote with this discount to immediately renew our 3-year/3-licenses subscription?

Thanks in advance.

 

Kind regards,

Rainer

 

--

Mit freundlichen Grüßen / kind regards

Rainer Kress

Senior Consultant, Datenschutzbeauftragter

Telefon:  +49 (89) 89 05 59 - 233

Mobil:     +49 (172) 8 16 96 05
__________________________


Dynaware Systemberatung GmbH
Welserstraße 1
81373 München
http://www.Dynaware.de

mailto:Rainer.Kress@Dynaware.de
Geschäftsführer: Dr. Alexander Bartmann

HRB 108659, Amtsgericht München
Steuernummer:
143 / 131 / 80582

Umsatzsteuer-ID: DE 169255951

__________________________


Attachments:
image001.png
Avatar
Andrey Zavyalov, PM

Hello Rainer,

Sorry for not answering. This seems to be an e-mail sending issue on our server for both of us. I will answer to all of your questions shortly.

Avatar
Rainer Kress

Dear Activedbsoft Team,

 

when can I expect your answer. I only want a new prolongation for our 3-user/3-year license.

Thanks in advance.

 

Kind regards,

Rainer