dhis2-devs team mailing list archive

[Priyanka Bawa <priyankabawa609@xxxxxxxxx>]

This error comes in version 2.20.

Regards
Priyanka

On Fri, May 27, 2016 at 11:36 AM, Priyanka Bawa <priyankabawa609@xxxxxxxxx>
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
>