[Dhis2-devs] Event report is showing data after deleting all events also
Hi DHIS Team, We have deleted all events for specific orgunit, ran analytics and cleared browser cache. Observed that there is no data in Event Capture app. But still we are seeing numbers in Event Reports app as below We have observed the same for other Orgunits also. Could you please let us know why event report still showing numbers. -- Rajeswari Gottipati Sr Consultant Email rajes...@thoughtworks.com 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> ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Event report is showing data after deleting all events also
Hi Markus, We are using DHIS 2.27. We will perform the action items what ever you mentioned and will update you soon. On Tue, Jun 5, 2018 at 12:20 PM, Markus Bekken wrote: > Hey there, > which version are you using? This seems to be a bug. Can you try and > delete the analytics tables called analytics_event_*, then run analytics > again? Alternatively, try to add one event for 2016, run analytics again > and see if the number of events in the event report goes down from 149 to 1. > > Best regards > Markus > > 5. jun. 2018 kl. 08:27 skrev Rajeswari Gottipati < > rajes...@thoughtworks.com>: > > Hi DHIS Team, > > We have deleted all events for specific orgunit, ran analytics and cleared > browser cache. Observed that there is no data in Event Capture app. > > > > But still we are seeing numbers in Event Reports app as below > > > > > We have observed the same for other Orgunits also. Could you please let us > know why event report still showing numbers. > > -- > Rajeswari Gottipati > Sr Consultant > Email rajes...@thoughtworks.com > 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> > ___ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > > -- Rajeswari Gottipati Sr Consultant Email rajes...@thoughtworks.com 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> ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Event report is showing data after deleting all events also
Hi Markus, We have tried alternative i.e created a case in 2016 and ran analytics. Now in Event Reports we are able to see 1 case under 2016. We will try the first option also and let you know the result soon. On Tue, Jun 5, 2018 at 12:38 PM, Rajeswari Gottipati < rajes...@thoughtworks.com> wrote: > Hi Markus, > > We are using DHIS 2.27. We will perform the action items what ever you > mentioned and will update you soon. > > On Tue, Jun 5, 2018 at 12:20 PM, Markus Bekken > wrote: > >> Hey there, >> which version are you using? This seems to be a bug. Can you try and >> delete the analytics tables called analytics_event_*, then run analytics >> again? Alternatively, try to add one event for 2016, run analytics again >> and see if the number of events in the event report goes down from 149 to 1. >> >> Best regards >> Markus >> >> 5. jun. 2018 kl. 08:27 skrev Rajeswari Gottipati < >> rajes...@thoughtworks.com>: >> >> Hi DHIS Team, >> >> We have deleted all events for specific orgunit, ran analytics and >> cleared browser cache. Observed that there is no data in Event Capture app. >> >> >> >> But still we are seeing numbers in Event Reports app as below >> >> >> >> >> We have observed the same for other Orgunits also. Could you please let >> us know why event report still showing numbers. >> >> -- >> Rajeswari Gottipati >> Sr Consultant >> Email rajes...@thoughtworks.com >> 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> >> _______ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> >> > > > -- > Rajeswari Gottipati > Sr Consultant > Email rajes...@thoughtworks.com > 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> > -- Rajeswari Gottipati Sr Consultant Email rajes...@thoughtworks.com 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> ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Event report is showing data after deleting all events also
Hi Markus, Do you think it is an issue in DHIS? On Tue, Jun 5, 2018 at 2:43 PM, Rajeswari Gottipati < rajes...@thoughtworks.com> wrote: > Hi Markus, > > We have tried alternative i.e created a case in 2016 and ran analytics. > Now in Event Reports we are able to see 1 case under 2016. We will try the > first option also and let you know the result soon. > > On Tue, Jun 5, 2018 at 12:38 PM, Rajeswari Gottipati < > rajes...@thoughtworks.com> wrote: > >> Hi Markus, >> >> We are using DHIS 2.27. We will perform the action items what ever you >> mentioned and will update you soon. >> >> On Tue, Jun 5, 2018 at 12:20 PM, Markus Bekken >> wrote: >> >>> Hey there, >>> which version are you using? This seems to be a bug. Can you try and >>> delete the analytics tables called analytics_event_*, then run analytics >>> again? Alternatively, try to add one event for 2016, run analytics again >>> and see if the number of events in the event report goes down from 149 to 1. >>> >>> Best regards >>> Markus >>> >>> 5. jun. 2018 kl. 08:27 skrev Rajeswari Gottipati < >>> rajes...@thoughtworks.com>: >>> >>> Hi DHIS Team, >>> >>> We have deleted all events for specific orgunit, ran analytics and >>> cleared browser cache. Observed that there is no data in Event Capture app. >>> >>> >>> >>> But still we are seeing numbers in Event Reports app as below >>> >>> >>> >>> >>> We have observed the same for other Orgunits also. Could you please let >>> us know why event report still showing numbers. >>> >>> -- >>> Rajeswari Gottipati >>> Sr Consultant >>> Email rajes...@thoughtworks.com >>> 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> >>> ___ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-devs@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >>> >> >> >> -- >> Rajeswari Gottipati >> Sr Consultant >> Email rajes...@thoughtworks.com >> 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> >> > > > > -- > Rajeswari Gottipati > Sr Consultant > Email rajes...@thoughtworks.com > 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> > -- Rajeswari Gottipati Sr Consultant Email rajes...@thoughtworks.com 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> ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Event report is showing data after deleting all events also
Yes I was able to reproduce this in different browsers and in incognito mode also. On Tue, Jun 5, 2018 at 5:08 PM, Jason Pickering wrote: > Do you have any server caching active? > > Were you able to reproduce this in incognito mode? > > Regards, > Jason > > > On Tue, Jun 5, 2018 at 12:52 PM, Rajeswari Gottipati < > rajes...@thoughtworks.com> wrote: > >> Hi Markus, >> >> Do you think it is an issue in DHIS? >> >> On Tue, Jun 5, 2018 at 2:43 PM, Rajeswari Gottipati < >> rajes...@thoughtworks.com> wrote: >> >>> Hi Markus, >>> >>> We have tried alternative i.e created a case in 2016 and ran analytics. >>> Now in Event Reports we are able to see 1 case under 2016. We will try the >>> first option also and let you know the result soon. >>> >>> On Tue, Jun 5, 2018 at 12:38 PM, Rajeswari Gottipati < >>> rajes...@thoughtworks.com> wrote: >>> >>>> Hi Markus, >>>> >>>> We are using DHIS 2.27. We will perform the action items what ever you >>>> mentioned and will update you soon. >>>> >>>> On Tue, Jun 5, 2018 at 12:20 PM, Markus Bekken >>> > wrote: >>>> >>>>> Hey there, >>>>> which version are you using? This seems to be a bug. Can you try and >>>>> delete the analytics tables called analytics_event_*, then run analytics >>>>> again? Alternatively, try to add one event for 2016, run analytics again >>>>> and see if the number of events in the event report goes down from 149 to >>>>> 1. >>>>> >>>>> Best regards >>>>> Markus >>>>> >>>>> 5. jun. 2018 kl. 08:27 skrev Rajeswari Gottipati < >>>>> rajes...@thoughtworks.com>: >>>>> >>>>> Hi DHIS Team, >>>>> >>>>> We have deleted all events for specific orgunit, ran analytics and >>>>> cleared browser cache. Observed that there is no data in Event Capture >>>>> app. >>>>> >>>>> >>>>> >>>>> But still we are seeing numbers in Event Reports app as below >>>>> >>>>> >>>>> >>>>> >>>>> We have observed the same for other Orgunits also. Could you please >>>>> let us know why event report still showing numbers. >>>>> >>>>> -- >>>>> Rajeswari Gottipati >>>>> Sr Consultant >>>>> Email rajes...@thoughtworks.com >>>>> 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> >>>>> ___ >>>>> Mailing list: https://launchpad.net/~dhis2-devs >>>>> Post to : dhis2-devs@lists.launchpad.net >>>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> Rajeswari Gottipati >>>> Sr Consultant >>>> Email rajes...@thoughtworks.com >>>> 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> >>>> >>> >>> >>> >>> -- >>> Rajeswari Gottipati >>> Sr Consultant >>> Email rajes...@thoughtworks.com >>> 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> >>> >> >> >> >> -- >> Rajeswari Gottipati >> Sr Consultant >> Email rajes...@thoughtworks.com >> 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> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+46764147049 > -- Rajeswari Gottipati Sr Consultant Email rajes...@thoughtworks.com 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> ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Event report is showing data after deleting all events also
Thanks Markus. I have raised Jira ticket <https://jira.dhis2.org/browse/DHIS2-3927> for this issue. On Tue, Jun 5, 2018 at 7:07 PM, Markus Bekken wrote: > Hi, > based on the behavior you see, my guess is that when you have no rows in > the database for one year, we are not clearing out the analytics table for > that event and year as part of the analytics run. We should have cleared > out analytics tables that would be empty at this stage. I will guess that > deleting the analytics_event_* tables will be a workaround for you. > > This seems like a bug, it is great if you can file a Jira issue for it. > > Markus > > 5. jun. 2018 kl. 13:45 skrev Rajeswari Gottipati < > rajes...@thoughtworks.com>: > > Yes I was able to reproduce this in different browsers and in incognito > mode also. > > On Tue, Jun 5, 2018 at 5:08 PM, Jason Pickering gmail.com> wrote: > >> Do you have any server caching active? >> >> Were you able to reproduce this in incognito mode? >> >> Regards, >> Jason >> >> >> On Tue, Jun 5, 2018 at 12:52 PM, Rajeswari Gottipati > thoughtworks.com> wrote: >> >>> Hi Markus, >>> >>> Do you think it is an issue in DHIS? >>> >>> On Tue, Jun 5, 2018 at 2:43 PM, Rajeswari Gottipati >> thoughtworks.com> wrote: >>> >>>> Hi Markus, >>>> >>>> We have tried alternative i.e created a case in 2016 and ran analytics. >>>> Now in Event Reports we are able to see 1 case under 2016. We will try the >>>> first option also and let you know the result soon. >>>> >>>> On Tue, Jun 5, 2018 at 12:38 PM, Rajeswari Gottipati >>> thoughtworks.com> wrote: >>>> >>>>> Hi Markus, >>>>> >>>>> We are using DHIS 2.27. We will perform the action items what ever you >>>>> mentioned and will update you soon. >>>>> >>>>> On Tue, Jun 5, 2018 at 12:20 PM, Markus Bekken >>>> no> wrote: >>>>> >>>>>> Hey there, >>>>>> which version are you using? This seems to be a bug. Can you try and >>>>>> delete the analytics tables called analytics_event_*, then run analytics >>>>>> again? Alternatively, try to add one event for 2016, run analytics again >>>>>> and see if the number of events in the event report goes down from 149 >>>>>> to 1. >>>>>> >>>>>> Best regards >>>>>> Markus >>>>>> >>>>>> 5. jun. 2018 kl. 08:27 skrev Rajeswari Gottipati < >>>>>> rajes...@thoughtworks.com>: >>>>>> >>>>>> Hi DHIS Team, >>>>>> >>>>>> We have deleted all events for specific orgunit, ran analytics and >>>>>> cleared browser cache. Observed that there is no data in Event Capture >>>>>> app. >>>>>> >>>>>> >>>>>> >>>>>> But still we are seeing numbers in Event Reports app as below >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> We have observed the same for other Orgunits also. Could you please >>>>>> let us know why event report still showing numbers. >>>>>> >>>>>> -- >>>>>> Rajeswari Gottipati >>>>>> Sr Consultant >>>>>> Email rajes...@thoughtworks.com >>>>>> 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> >>>>>> ___ >>>>>> Mailing list: https://launchpad.net/~dhis2-devs >>>>>> Post to : dhis2-devs@lists.launchpad.net >>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>>>> More help : https://help.launchpad.net/ListHelp >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Rajeswari Gottipati >>>>> Sr Consultant >>>>> Email rajes...@thoughtworks.com >>>>> Telephone +91 9949292931 <+91%209949292931> >>>>> [image: ThoughtWorks] >>>>> <http://www.thoughtworks.com/?utm_campaign=rajeswari-gotti
[Dhis2-devs] Missing orderby clause in TrackedEntityInstance Ids query
Hi DHIS team, We are hitting the below API to fetch TrackedEntityInstance(TEI) Ids http:///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 rajes...@thoughtworks.com 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> ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Missing orderby clause in TrackedEntityInstance Ids query
Hi Morten, Thanks for your inputs. Can you help us understanding how paginated API calls are going to be handled in DHIS side. For example, If we make an API call to get first 1000 results i.e page1 -- DHIS will hit the DB with some query and gives the results (please correct me if I am wrong here). Will it store the DB query results in-memory? Subsequently if we make the same API call but for second 1000 i.e page2 -- How DHIS returns the data this time. Will it hit the database again to get the data or will it get from in-memory? If we want to add an additional "orderby" clause, is there any parameter in API to perform sorting or we have to add "orderby" clause in DHIS query. Thanks, Rajeswari. On Thu, Jun 7, 2018 at 12:50 PM, Morten Olav Hansen wrote: > Hi > > Postgres should return the results in row-order if no order by clause is > specified, so it should be OK. You can always specify additional ordering > if you need it. > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Thu, Jun 7, 2018 at 8:54 AM, Rajeswari Gottipati < > rajes...@thoughtworks.com> wrote: > >> Hi DHIS team, >> >> We are hitting the below API to fetch TrackedEntityInstance(TEI) Ids >> >> http:///api/25/trackedEntityInstances?eventEndDate=2 >> 018-06-03&eventStartDate=2018-03-18&fields=trackedEntityInst >> ance&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 rajes...@thoughtworks.com >> 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> >> >> ___ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > -- Rajeswari Gottipati Sr Consultant Email rajes...@thoughtworks.com 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> ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] TrackedEntityInstances API call is taking lot of time in DHIS 2.29
Hi All, We are upgrading from DHIS 2.27 to DHIS 2.29. We are making the below call to get the trackedentityinstance ids. http:// /api/trackedEntityInstances.json?eventEndDate=2018-07-08&eventStartDate=2018-04-22&fields=trackedEntityInstance&ou=&ouMode=DESCENDANTS&page=2&pageSize=1000&program=&totalPages=true The thing what we observed is this call is taking 1 or 2 secs with DHIS 2.27 but it is taking around 25 secs with DHIS 2.29. Could you please help us understand why it is taking this much time in DHIS 2.29. Also, Is there any plan to optimize this in near future? Thanks, Rajeswari & Gaurav. ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] TrackedEntityInstances API call is taking lot of time in DHIS 2.29
Hi Morten / Lars, We are upgrading from DHIS 2.27 to DHIS 2.29. We are making the below call to get the trackedentityinstance ids. http:///api/trackedEntityInstances.json? eventEndDate=2018-07-08&eventStartDate=2018-04-22& fields=trackedEntityInstance&ou=&ouMode= DESCENDANTS&page=2&pageSize=1000&program=&totalPages=true The thing what we observed is this call is taking 1 or 2 secs with DHIS 2.27 but it is taking around 25 secs with DHIS 2.29. Could you please help us understand why it is taking this much time in DHIS 2.29. Also, Is there any plan to optimize this in near future? Thanks, Rajeswari & Gaurav. ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] License information for HighCharts
Hi DHIS Team, We are planning to use HighCharts in our web application and we found that HighCharts library is available under different licenses depending on whether it is intended for commercial/government use, or for a personal or non-profit project. As DHIS is already using highcharts, we want to know how DHIS got the access to HighCharts and which kind of license it is using? Thanks, Rajeswari, Gaurav ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] Query around OAuth implicit grant
Hi DHIS, We have gone through DHIS OAuth documentation and found that DHIS has implemented Authorization code grant. We are planning to use DHIS OAuth in our application and our application is pure java script based. As our application is SPA (single page application) hence we are looking for implicit grant OAuth. Are there any plans to implement this in near future. Thanks, Rajeswari & Gaurav. ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] Need help to identify proper authorities to make API calls in DHIS
Hi DHIS Team,
We are planning to use DHIS OAuth in our application.
We want to make API calls to view/add/update/delete the events, programs,
dataSets, dataValues etc. For this we want to figure out minimum list of
authorities so that access token generated from the user's login detail
should be able to make api calls.
*Requirement* :
We require a user login that can make api calls to fetch data, but they
should not be able to update data directly through DHIS.
*What we tried : *
We tried to assign selective authorities to the particular user role and we
have following observation :
1. When we assign no authorities to the user role, and make api call for
events we got below response
*{"pager":{"page":1,"pageCount":2,"total":1365,"pageSize":1000},"events":[]}%*
NO events came in the response json in spite of events present in the
system.
2. When we assign all authorities except '*ALL*' to the user role, and make
api call for events we got the same response as above.
*{"pager":{"page":1,"pageCount":2,"total":1365,"pageSize":1000},"events":[]}%*
3. When we assign the authority '*ALL*' to the user role, and make api call
for events we were able to get all the events. This also enables the user
to make update data directly from DHIS.
Could you please help us to figure out the minimum authority to make API
calls?
Thanks,
Rajeswari & Gaurav.
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Need help to identify proper authorities to make API calls in DHIS
Hi DHIS Team,
Can you please respond to our query.
On Mon, Aug 13, 2018 at 3:31 PM, Rajeswari Gottipati <
rajes...@thoughtworks.com> wrote:
> Hi DHIS Team,
>
> We are planning to use DHIS OAuth in our application.
> We want to make API calls to view/add/update/delete the events, programs,
> dataSets, dataValues etc. For this we want to figure out minimum list of
> authorities so that access token generated from the user's login detail
> should be able to make api calls.
>
> *Requirement* :
> We require a user login that can make api calls to fetch data, but they
> should not be able to update data directly through DHIS.
>
> *What we tried : *
> We tried to assign selective authorities to the particular user role and
> we have following observation :
> 1. When we assign no authorities to the user role, and make api call for
> events we got below response
>
>
> *{"pager":{"page":1,"pageCount":2,"total":1365,"pageSize":1000},"events":[]}%*
>
> NO events came in the response json in spite of events present in the
> system.
>
> 2. When we assign all authorities except '*ALL*' to the user role, and
> make api call for events we got the same response as above.
>
>
> *{"pager":{"page":1,"pageCount":2,"total":1365,"pageSize":1000},"events":[]}%*
>
> 3. When we assign the authority '*ALL*' to the user role, and make api
> call for events we were able to get all the events. This also enables the
> user to make update data directly from DHIS.
>
> Could you please help us to figure out the minimum authority to make API
> calls?
>
> Thanks,
> Rajeswari & Gaurav.
>
--
Rajeswari Gottipati
Sr Consultant
Email rajes...@thoughtworks.com
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>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Need help to identify proper authorities to make API calls in DHIS
Hi Morten,
Thanks for your reply. We have raised jira ticket
<https://jira.dhis2.org/browse/DHIS2-4418>. Please have a look.
On Thu, Aug 16, 2018 at 1:36 PM, Morten Olav Hansen
wrote:
> Hi
>
> This sounds like a bug to me (seems we are not properly filtering the
> paging component of the result). Would you mind filing a issue at
> jira.dhis2.org ? (if you have already, please let me know the issue
> number)
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> Team Integration Lead
> University of Oslo
> http://www.dhis2.org
>
>
> On Thu, Aug 16, 2018 at 2:15 PM Rajeswari Gottipati <
> rajes...@thoughtworks.com> wrote:
>
>> Hi DHIS Team,
>>
>> Can you please respond to our query.
>>
>> On Mon, Aug 13, 2018 at 3:31 PM, Rajeswari Gottipati <
>> rajes...@thoughtworks.com> wrote:
>>
>>> Hi DHIS Team,
>>>
>>> We are planning to use DHIS OAuth in our application.
>>> We want to make API calls to view/add/update/delete the events,
>>> programs, dataSets, dataValues etc. For this we want to figure out minimum
>>> list of authorities so that access token generated from the user's login
>>> detail should be able to make api calls.
>>>
>>> *Requirement* :
>>> We require a user login that can make api calls to fetch data, but they
>>> should not be able to update data directly through DHIS.
>>>
>>> *What we tried : *
>>> We tried to assign selective authorities to the particular user role and
>>> we have following observation :
>>> 1. When we assign no authorities to the user role, and make api call for
>>> events we got below response
>>>
>>>
>>> *{"pager":{"page":1,"pageCount":2,"total":1365,"pageSize":1000},"events":[]}%*
>>>
>>> NO events came in the response json in spite of events present in the
>>> system.
>>>
>>> 2. When we assign all authorities except '*ALL*' to the user role, and
>>> make api call for events we got the same response as above.
>>>
>>>
>>> *{"pager":{"page":1,"pageCount":2,"total":1365,"pageSize":1000},"events":[]}%*
>>>
>>> 3. When we assign the authority '*ALL*' to the user role, and make api
>>> call for events we were able to get all the events. This also enables the
>>> user to make update data directly from DHIS.
>>>
>>> Could you please help us to figure out the minimum authority to make API
>>> calls?
>>>
>>> Thanks,
>>> Rajeswari & Gaurav.
>>>
>>
>>
>>
>> --
>> Rajeswari Gottipati
>> Sr Consultant
>> Email rajes...@thoughtworks.com
>> 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>
>>
>
--
Rajeswari Gottipati
Sr Consultant
Email rajes...@thoughtworks.com
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>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] TEI and Enrollments API GET calls are not considering date range
Hi DHIS Team, We are using below API calls to get the TrackedEntityInstance Ids and Enrollment Ids. *https:///api/trackedEntityInstances?lastUpdatedStartDate=2018-06-17&lastUpdatedEndDate=2018-09-02&fields=trackedEntityInstance&ou=&ouMode=DESCENDANTS&page=5&pageSize=1000&program=&totalPages=true* *http:///api/enrollments?programEndDate=2018-08-05&programStartDate=2018-05-20&fields=enrollment&ou=&ouMode=DESCENDANTS&page=1&pageSize=1000&totalPages=true&program=* The above API calls returning the total number of ids but not returning any ids. Could you please help us to identify what we have done incorrect. Thanks, Rajeswari & Gaurav. ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] Custom attribute value is downloading incorrectly in DHIS 2.29
Hi DHIS Team,
We were using DHIS 2.27. We have one option with name "Procedures" and its
code is "procedure". This option is assigned to one of the option set and
this set is assigned to one of the custom attribute.
We had set this custom attribute to "Procedures" for few data elements. Now
we migrated to DHIS 2.29 and created new data elements and set this custom
attribute value "Procedures".
If we query for these data elements (old and new) we are seeing different
results for this custom attribute value (code) as below
Existing Data Element:
"attributeValues": *[*
*{*
"value": "*procedures*",
"attribute": *{*
"code": "xxx",
"name": "xx",
"id": "RKB9aA9Ndg"
*}*
*}*
*]*
New Data Element:
"attributeValues": *[*
*{*
"value": "*procedure*",
"attribute": *{*
"code": "xxx",
"name": "xx",
"id": "RKB9aA9Ndg"
*}*
*}*
*]*
One more thing we observed is when we make API call for this option we are
seeing correct results as per metadata setup
{"code": "procedure","name": "Procedures","id": "bICEZ89454","translations
": []}
Could you please help us why DHIS is returning different results for same
custom attribute?
--
Rajeswari Gottipati
Sr Consultant
Email rajes...@thoughtworks.com
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>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Unapproved data is visible for users not assigned the "View Unapproved Data" permission
Hi DHIS team, Could you please provide an update for the above reported issue. On Wed, Sep 12, 2018 at 4:14 PM, Preeti Ajgaonkar wrote: > Hi team, > > Recently we have been noticing that users who have not been assigned with > the "View unapproved data" permission are able to see unapproved data in > reporting apps i.e. Pivot tables, Data Visualizers and event reports. We > have been seeing this since DHIS 2.27 onwards. Could you please let us know > if this could be a bug or if there is any resolution to this? > > -- > Thanks > Preeti Ajgaonkar > -- Rajeswari Gottipati Sr Consultant Email rajes...@thoughtworks.com 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> ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Custom attribute value is downloading incorrectly in DHIS 2.29
Hi DHIS Team,
Regarding this issue we have raised JIRA
<https://jira.dhis2.org/browse/DHIS2-4764> ticket as well. As it is
production issue and high priority, could you please have a look.
On Thu, Sep 20, 2018 at 2:51 PM Rajeswari Gottipati <
rajes...@thoughtworks.com> wrote:
> Hi DHIS Team,
>
> We were using DHIS 2.27. We have one option with name "Procedures" and its
> code is "procedure". This option is assigned to one of the option set and
> this set is assigned to one of the custom attribute.
>
> We had set this custom attribute to "Procedures" for few data elements.
> Now we migrated to DHIS 2.29 and created new data elements and set this
> custom attribute value "Procedures".
>
> If we query for these data elements (old and new) we are seeing different
> results for this custom attribute value (code) as below
>
> Existing Data Element:
>
> "attributeValues": *[*
>
> *{*
>
> "value": "*procedures*",
>
>
> "attribute": *{*
>
> "code": "xxx",
>
> "name": "xx",
>
> "id": "RKB9aA9Ndg"
>
> *}*
>
> *}*
>
> *]*
>
>
> New Data Element:
>
> "attributeValues": *[*
>
> *{*
>
> "value": "*procedure*",
>
>
> "attribute": *{*
>
> "code": "xxx",
>
> "name": "xx",
>
> "id": "RKB9aA9Ndg"
>
> *}*
>
> *}*
>
> *]*
>
> One more thing we observed is when we make API call for this option we are
> seeing correct results as per metadata setup
>
>
> {"code": "procedure","name": "Procedures","id": "bICEZ89454","translations
> ": []}
>
>
> Could you please help us why DHIS is returning different results for same
> custom attribute?
>
> --
> Rajeswari Gottipati
> Sr Consultant
> Email rajes...@thoughtworks.com
> 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>
>
--
Rajeswari Gottipati
Sr Consultant
Email rajes...@thoughtworks.com
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>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
