Re: [Dhis2-devs] trackedEntityInstances date and time filter

Hi, Yes, expected behavior. -- Abyot A. Gizaw. Senior Engineer, DHIS2 University of Oslo http://www.dhis2.org On Wed, Oct 31, 2018 at 1:29 PM Tomas Sala wrote: > Hi, > > > > We are using the endpoint trackedEntityInstances and we want to filter by > date and time using

Re: [Dhis2-devs] [Dhis2-users] Help needed: Checking a string with single quote in program rule...

Thank you very much Terence and Markus, for your valuable suggestions. I am not sure whether the first suggestion can be implemented since we have already migrated 1000's data with these values. The second suggestion, using the code sounds good for me. Let me check the design and see what I can

Re: [Dhis2-devs] trackedEntityInstances date and time filter

Hi, Is it possible to filter by the lastUpdated (date and time) of the trackedEntityInstances using the endpoint trackedEntityInstances? Thanks! De: Dhis2-devs [mailto:dhis2-devs-bounces+tomas.sala=barcelona.msf@lists.launchpad.net] En nombre de Tomas Sala Enviado el: 31 October

[Dhis2-devs] trackedEntityInstances date and time filter

Hi, We are using the endpoint trackedEntityInstances and we want to filter by date and time using lastUpdatedStartDate=2018-10-30T18:05:00 but it doesn't take into account the time, only the date. Is this the expected behaviour? Thank you! Tomàs Sala Camarena Ehealth Technician, eHealth Team

Re: [Dhis2-devs] trackedEntityInstances date and time filter

Hi, So far, time is not considered for filtering everywhere. It is a little complicated to deal with timestamp / timezone. There is internal discussion about it ... a solution is yet to come. -- Abyot A. Gizaw. Senior Engineer, DHIS2 University of Oslo http://www.dhis2.org On Wed, Oct 31, 2018

Re: [Dhis2-devs] trackedEntityInstances date and time filter

Hi, Ok, thanks! De: Abyot Asalefew Gizaw [mailto:ab...@dhis2.org] Enviado el: 31 October 2018 13:31 Para: Tomas Sala CC: dhis2-devs Asunto: Re: [Dhis2-devs] trackedEntityInstances date and time filter Hi, Yes, expected behavior. -- Abyot A. Gizaw. Senior Engineer, DHIS2 University of Oslo

[Dhis2-devs] introducing Discourse for discussions and communications

Hi all *TL;DR* We are moving to Discourse for discussions and communications, Launchpad is going away! https://community.dhis2.org/ During the last Experts Academy, we introduced the DHIS2 Community of Practice (CoP). The CoP is a

Re: [Dhis2-devs] [Dhis2-users] introducing Discourse for discussions and communications

This is really good. Especially because of the features highlighted.  Good move.  Sent from Yahoo Mail on Android On Wed, 31 Oct 2018 at 15:11, Lars Helge Øverland wrote: Hi all TL;DR We are moving to Discourse for discussions and communications, Launchpad is going away! 

Re: [Dhis2-devs] Generating sequential numbers in program rule

Hi Terence This textpattern applies to generating unique tracked entity attributes. So if you make the attribute unique and then system generated you can enter the pattern accordingly: [image: image.png] On Wed, Oct 31, 2018 at 5:58 PM Terence Scott < terence.sc...@rabiesalliance.org> wrote: >

Re: [Dhis2-devs] [Dhis2-users] Help needed: Checking a string with single quote in program rule...

Hey MSP - escaping single quotes is not supported as of now, it would be great if you create a feature request for it. As Terence says, there might be workarounds - one suggested below. If "don't know" is one of the options in an option set, I am guessing that there is a code for this option

Re: [Dhis2-devs] Clear analytics tables

Hi Moses, are you talking about aggregate data? If so, the table is *datavalue*. regards, Lars On Wed, 31 Oct 2018 at 08:52, moses mwale wrote: > I have a test database which every time I import and connect a dhis2 > instance automatically starts analytics and loads data. I don’t need that

Re: [Dhis2-devs] [Dhis2-users] postgresql version 9.6 required for dhis version 2.31

Thanks Lars. Just to be clear, Is that the minimum requirements for PostgreSQL? Sent from my HTC - Reply message - From: "Lars Helge Øverland" To: "DHIS 2 Users list" , "DHIS 2 Developers list" Subject: [Dhis2-users] postgresql version 9.6 required for dhis version 2.31 Date: Tue,

Re: [Dhis2-devs] [Dhis2-users] postgresql version 9.6 required for dhis version 2.31

Hi, PostGIS requirement is 2.2 or later. AFAIK, this will still be the case for 2.31. Regards, Bjørn -- Bjørn Sandvik GIS developer, DHIS 2 University of Oslo www.dhis2.org On Wed, Oct 31, 2018 at 8:18 AM Calle Hedberg wrote: > Hi, > > With regard to minimum pg requirements: Bjorn, what is

Re: [Dhis2-devs] [Dhis2-users] postgresql version 9.6 required for dhis version 2.31

On Wed, 31 Oct 2018 at 08:15, Calle Hedberg wrote: > Lars, > > With postgresql version 11 out - are there any specific reasons for NOT > using pg 11? Many of the key features introduced in 10 - like table > partitioning - have been further enhanced in 11. > > No reason that I am aware of and it

Re: [Dhis2-devs] [Dhis2-users] postgresql version 9.6 required for dhis version 2.31

On Wed, 31 Oct 2018 at 09:00, moses mwale wrote: > Sorry just to interject, so dhis2 does not work with Postgres 9.5? > PostgreSQL 9.5 will work up to DHIS 2 version 2.30. For DHIS 2.31 you will need PostgreSQL 9.6 or higher. regards, Lars > On Wed, 31 Oct 2018 at 9:58 AM, Bjørn Sandvik

Re: [Dhis2-devs] [Dhis2-users] postgresql version 9.6 required for dhis version 2.31

On Wed, 31 Oct 2018 at 07:03, stepho...@gmail.com wrote: > Thanks Lars. > > Just to be clear, Is that the minimum requirements for PostgreSQL? > > Correct. Version 9.6 or higher. regards, Lars > Sent from my HTC > > - Reply message - > From: "Lars Helge Øverland" > To: "DHIS 2

Re: [Dhis2-devs] [Dhis2-users] postgresql version 9.6 required for dhis version 2.31

Lars, With postgresql version 11 out - are there any specific reasons for NOT using pg 11? Many of the key features introduced in 10 - like table partitioning - have been further enhanced in 11. Regards Calle On Wed, 31 Oct 2018 at 08:04, stepho...@gmail.com wrote: > Thanks Lars. > > Just to

Re: [Dhis2-devs] [Dhis2-users] postgresql version 9.6 required for dhis version 2.31

Hi, With regard to minimum pg requirements: Bjorn, what is the minimum version requirement for Postgis, and what is the recommended version? Again, postGIS 2.5 was released recently, so if people need to upgrade anyhow it makes sense to upgrade to the latest, tested version... Regards Calle On

Re: [Dhis2-devs] Generating sequential numbers in program rule

Hi MSP Thank you for the suggestion. I have also attempted this and was unable to have any success. I tried to create a new rule with simply having "Sequential(###)" alone, and did not have any success either. Therefore, I assumed that there would be some sort of additional text that is required

[Dhis2-devs] Clear analytics tables

I have a test database which every time I import and connect a dhis2 instance automatically starts analytics and loads data. I don’t need that data it’s old, how do I clear this data from the database? Which table hold a that data I want to clear it. -- developer_lusaka_systems

Re: [Dhis2-devs] [Dhis2-users] postgresql version 9.6 required for dhis version 2.31

Sorry just to interject, so dhis2 does not work with Postgres 9.5? On Wed, 31 Oct 2018 at 9:58 AM, Bjørn Sandvik wrote: > Hi, > > PostGIS requirement is 2.2 or later. > AFAIK, this will still be the case for 2.31. > > Regards, > Bjørn > > -- > Bjørn Sandvik > GIS developer, DHIS 2 > University

Re: [Dhis2-devs] Use of square brackets [] in metadata field filter

Hi there, Vlad is right on the above. Longer term we will work on replacing the use of square brackets with a URL safe character (there are not many left) and/or perhaps a POST-with-JSON-payload based solution. In the short term we will ensure all web API requests are encoded. As Vlad say, the

Re: [Dhis2-devs] Use of square brackets [] in metadata field filter

Thanks guys. @Lars - (This is v2.27) On the Reports page, if you go to Data Approvals (i.e. dhis-web-reporting/showDataApprovalForm.action), I see a request to the following URL: api/dataSets.json?fields=id,displayName,periodType,workflow,categoryCombo[id,displayName]=false Cheers, - Jasper On

Re: [Dhis2-devs] [Dhis2-users] postgresql version 9.6 required for dhis version 2.31

Version 2.31 will not On Wed, 31 Oct 2018, 09:00 moses mwale, wrote: > Sorry just to interject, so dhis2 does not work with Postgres 9.5? > > On Wed, 31 Oct 2018 at 9:58 AM, Bjørn Sandvik wrote: > >> Hi, >> >> PostGIS requirement is 2.2 or later. >> AFAIK, this will still be the case for 2.31.

Re: [Dhis2-devs] [Dhis2-users] Help needed: Checking a string with single quote in program rule...

Hi MSP I am not sure how to rectify the problem directly, but several easy solutions would be to simply reword the response to: 'Unsure', 'unknown', 'not known' or similar. Kind regards, Terence Terence Scott Global Alliance for Rabies Control (GARC) Pan-African Rabies Control Network