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>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp

