Query Admin- Input Validation for a Passthrough Query
Brought to you by:
gsteimer,
tsgopensource
In the Query Admin, when the user enters an invalid query name and nothing else, the user gets this error in a popup window: Error: Two query variables differing only by capitalization may not be used in the same query. For example, both user and User as varaiable names is prohibited. Please fix this issue and try saving again. The user should just be getting a wearning that the query name is invalid and the query type needs to be selected. This popup error should be shown when the user inserts two variables in the Query Text area with the same name but different cases.
If the user clicks ok and then selects query type, then clicks ok again a warninig will be briefly shown then the user will be taken back to the Manage Queries page. Invalid characters will be left in the title.
See STS016- Passthrough Query C5 and TSG Rest Query C%