dhis2-devs team mailing list archive

[Priyanka Bawa <priyankabawa609@xxxxxxxxx>]

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 [image:
Inline image 1]
Seems that the query doesn't take variables having any special character.
Any help will be appreciated.

Regards
Priyanka