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
