dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #15937
Missing orderby clause in TrackedEntityInstance Ids query
Hi DHIS team,
We are hitting the below API to fetch TrackedEntityInstance(TEI) Ids
http://<domain>/api/25/trackedEntityInstances?eventEndDate=2018-06-03&eventStartDate=2018-03-18&fields=trackedEntityInstance&ou=a2620f76786&ouMode=DESCENDANTS&page=1&pageSize=1000&totalPages=true
<http://localhost:8080/api/25/trackedEntityInstances?eventEndDate=2018-06-03&eventStartDate=2018-03-18&fields=trackedEntityInstance&ou=a2620f71996&ouMode=DESCENDANTS&page=1&pageSize=1000&totalPages=true>
The above API call will give first 1000 TEI ids because the call is
paginated with pagesize=1000. Like that we are making calls for other pages
to fetch all the TEI Ids.
DHIS is using the below query to get the TEI ids
select distinct tei from TrackedEntityInstance tei left join
tei.trackedEntityAttributeValues where ( tei.organisationUnit.path LIKE
'/a2cf79e8g34/a1c343a3w24%') and tei.deleted is false;
In this query we couldn't find any order by clause. Is there any chance
that few of the TEI ids which are returned in some page are going to be
repeated in another page also.
Is this query going to be executed every time for each paginated API call?
--
Rajeswari Gottipati
Sr Consultant
Email rajeswag@xxxxxxxxxxxxxxxx
Telephone +91 9949292931 <+91%209949292931>
[image: ThoughtWorks]
<http://www.thoughtworks.com/?utm_campaign=rajeswari-gottipati-signature&utm_medium=email&utm_source=thoughtworks-email-signature-generator>
Follow ups