Re: [Dhis2-devs] SQL View Doesn't work for comma seperated variables

Hi Priyanka, I had asked a related question recently about the ability to support "IN" clauses, you can view the thread here: https://lists.launchpad.net/dhis2-devs/msg44763.html Lorill On Thu, May 26, 2016 at 11:34 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi there. > >

Re: [Dhis2-devs] SQL View Doesn't work for comma seperated variables

Hi there. This syntax is not supported as you can see from the documentation *The variable parameter must contain alphanumeric characters only. The variables must contain alphanumeric, dash, underscore and whitespace

Re: [Dhis2-devs] SQL View Doesn't work for comma seperated variables

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

[Dhis2-devs] SQL View Doesn't work for comma seperated variables

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