SQL-Query gets double columns

Posted 4 days ago by Ewald Winkler

Post a topic
Un Solved
E
Ewald Winkler

If you create a new service with a simple SQL-Query like this one:

SELECT [strg_1] FROM [au2matorStaging].[dbo].[TC_Basetable] where [strg_1] = 'Testeintrag 08'

Press "save" an test it. You will get a Popup with the right data.
If you enter the Service-Editmode for this service again and only press "Apply" and the test ist again. The Query will not work and shows this:
If you look in the [au2mator].[dbo].[RunbookParameterMappings] - Column "ViewSqlQuery"
you will see that the select colums have been extended.
It seems, that if the column name appears after the "Select" and also appears at the end of the "where" clause, pressing "Apply" (in edit mode) will add it again at the beginning of the "Select" clause!
I hope you can reproduce the problem
Ewald

0 Votes


1 Comments

M

Michael Seidl posted 2 days ago Admin

Hi, we have created our internal Bug with ID A2M-1075 to follow here: au2mator - Self Service Portal Roadmap : au2mator

0 Votes

Login or Sign up to post a comment