Active Query Builder support area

Failed query validation by use of postgreSQL string_agg() function

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

Replies 12
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?

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