dhis2-devs team mailing list archive

[chathura widanage <chathurawidanage@xxxxxxxxx>]

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&attribute=izuwkaOUgFg&attribute=C8DBAo2wEYN&attribute=BZEpuufLyDE&attribute=WqdldQpOIxm

In our setup,  we have 5 orgUnitLevels and above query works fine for
superuser who has just one orgUnit assigned which is of level 1.

There are other users who has multiple level 4 and 5 orgUnits assigned.
Above API call fails for those users giving a 500 error code. Basically
this doesn't work for any user who has multiple orgUnits.

The cause for the issue seems to be a SQL syntax error.

Please find the link to the stack trace below.

https://dl.dropboxusercontent.com/u/81780569/stack.txt

The issue was visible in DHIS2 v2.23 and v2.24.

Have I done something wrong in the above API call or is this a bug in the
DHIS2. Is there any walk around for this issue?

Thanks
-- 
Best Regards,

*Chathura Widanage,*
Undergraduate,
Department of Computer Science and Engineering,
University of Moratuwa,
Sri Lanka
<https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profile>
  <http://facebook.com/chathura.widanage>
<https://plus.google.com/u/0/109418781686423002025>
<https://github.com/chathurawidanage>