This error comes in version 2.20.
Regards
Priyanka
On Fri, May 27, 2016 at 11:36 AM, Priyanka Bawa <priyankabawa...@gmail.com>
wrote:
> 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
