Hi
I am trying to create an SQLView where i am using a variable (populationFormSOU1). The result of this variable is comma separated as :- shvnNIx,1biz5LW,BZuwzHr5,RP4CW,lYFre,n5z2VKrv,5Ut1oxMO,FJETOdBp,h7sbFDA
SELECT COUNT(*) FROM completedatasetregistration WHERE sourceid IN (populationFormSOU1=‘${populationFormSOU1}’) AND datasetid = 52 AND periodid = ‘${periodid}’;
The result of above SQLView says that the variables are invalid
···
Seems that the query doesn’t take variables having any special character.
Hi
I am trying to create an SQLView where i am using a variable (populationFormSOU1). The result of this variable is comma separated as :- shvnNIx,1biz5LW,BZuwzHr5,RP4CW,lYFre,n5z2VKrv,5Ut1oxMO,FJETOdBp,h7sbFDA
SELECT COUNT(*) FROM completedatasetregistration WHERE sourceid IN (populationFormSOU1=‘${populationFormSOU1}’) AND datasetid = 52 AND periodid = ‘${periodid}’;
The result of above SQLView says that the variables are invalid
Seems that the query doesn’t take variables having any special character.
This syntax is not supported as you can see from the documentation The variable parameter must contain alphanumeric characters only. The variables must contain alphanumeric, dash, underscore and whitespace characters only.
This might be something which can added, but there could be an increased risk of SQL injection attacks, which these restrictions are meant to try and prevent to some extent. Maybe the developers can say more about this.
Hi
I am trying to create an SQLView where i am using a variable (populationFormSOU1). The result of this variable is comma separated as :- shvnNIx,1biz5LW,BZuwzHr5,RP4CW,lYFre,n5z2VKrv,5Ut1oxMO,FJETOdBp,h7sbFDA
SELECT COUNT(*) FROM completedatasetregistration WHERE sourceid IN (populationFormSOU1=‘${populationFormSOU1}’) AND datasetid = 52 AND periodid = ‘${periodid}’;
The result of above SQLView says that the variables are invalid
Seems that the query doesn’t take variables having any special character.
This syntax is not supported as you can see from the documentation The variable parameter must contain alphanumeric characters only. The variables must contain alphanumeric, dash, underscore and whitespace characters only.
This might be something which can added, but there could be an increased risk of SQL injection attacks, which these restrictions are meant to try and prevent to some extent. Maybe the developers can say more about this.
Hi
I am trying to create an SQLView where i am using a variable (populationFormSOU1). The result of this variable is comma separated as :- shvnNIx,1biz5LW,BZuwzHr5,RP4CW,lYFre,n5z2VKrv,5Ut1oxMO,FJETOdBp,h7sbFDA
SELECT COUNT(*) FROM completedatasetregistration WHERE sourceid IN (populationFormSOU1=‘${populationFormSOU1}’) AND datasetid = 52 AND periodid = ‘${periodid}’;
The result of above SQLView says that the variables are invalid
Seems that the query doesn’t take variables having any special character.