We use cookies to try and give you a better experience in Freshdesk.
You can learn more about what kind of cookies we use, why, and how from our Privacy policy. If you hate cookies, or are just on a diet, you can disable them altogether too. Just note that the Freshdesk service is pretty big on some cookies (we love the choco-chip ones), and some portions of Freshdesk may not work properly if you disable cookies.
We’ll also assume you agree to the way we use cookies and are ok with it as described in our Privacy policy, unless you choose to disable them altogether through your browser.
If you create a new service with a simple SQL-Query like this one:
Press "save" an test it. You will get a Popup with the right data.
If you look in the [au2mator].[dbo].[RunbookParameterMappings] - Column "ViewSqlQuery"
I hope you can reproduce the problem
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:
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!
Ewald
0 Votes
1 Comments
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