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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp