Re: [Dhis2-devs] Tracked Entity Instances Query - SQL syntax error

Hi Morten, We found a problem in the SQL Views as well. SQLView/{id}/data endpoint is not working in v2.24 (23583,2016-08-25 07:50) and we can't even define new SQL views from the Data Administration app. stack trace : https://dl.dropboxusercontent.com/u/81780569/sql_stack_trace.txt Same sql

Re: [Dhis2-devs] Tracked Entity Instances Query - SQL syntax error

Thank you Morten. On 25 Aug 2016 13:00, "Pamod Amarakoon" wrote: > Thank you Morten. > > On Thu, Aug 25, 2016 at 12:50 PM, Morten Olav Hansen > wrote: > >> Give our servers about 1 hour, and you can download the fix for 2.23, >> 2.24 and trunk >> >> -- >>

Re: [Dhis2-devs] Tracked Entity Instances Query - SQL syntax error

Thank you Morten. On Thu, Aug 25, 2016 at 12:50 PM, Morten Olav Hansen wrote: > Give our servers about 1 hour, and you can download the fix for 2.23, 2.24 > and trunk > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Thu,

Re: [Dhis2-devs] Tracked Entity Instances Query - SQL syntax error

Give our servers about 1 hour, and you can download the fix for 2.23, 2.24 and trunk -- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org On Thu, Aug 25, 2016 at 2:02 PM, Morten Olav Hansen wrote: > Looking into it now Pamod, sorry for the

Re: [Dhis2-devs] Tracked Entity Instances Query - SQL syntax error

Looking into it now Pamod, sorry for the delay.. I have recreated the bug locally and working on a fix -- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org On Wed, Aug 24, 2016 at 12:33 PM, Pamod Amarakoon wrote: > Hi Morten, > > Just

Re: [Dhis2-devs] Tracked Entity Instances Query - SQL syntax error

Hi Morten, Just wondering whether this has been fixed. Thank you On Wed, Aug 17, 2016 at 7:24 PM, Pamod Amarakoon wrote: > Thank you Morten. > > On Wed, Aug 17, 2016 at 7:10 PM, Morten Olav Hansen > wrote: > >> Seems like a bug yes, I will look into it >>

Re: [Dhis2-devs] Tracked Entity Instances Query - SQL syntax error

Thank you Morten. On Wed, Aug 17, 2016 at 7:10 PM, Morten Olav Hansen wrote: > Seems like a bug yes, I will look into it > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Mon, Aug 15, 2016 at 10:34 AM, chathura widanage <

Re: [Dhis2-devs] Tracked Entity Instances Query - SQL syntax error

Seems like a bug yes, I will look into it -- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org On Mon, Aug 15, 2016 at 10:34 AM, chathura widanage < chathurawidan...@gmail.com> wrote: > Hi all, > > I am using below API call to query all the TEIs which are

[Dhis2-devs] Tracked Entity Instances Query - SQL syntax error

Hi all, I am using below API call to query all the TEIs which are accessible by the current user. /api/trackedEntityInstances/query.json?ouMode=ACCESSIBLE=izuwkaOUgFg=C8DBAo2wEYN=BZEpuufLyDE=WqdldQpOIxm In our setup, we have 5 orgUnitLevels and above query works fine for superuser who has just