Re: [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 (PARACON)

Re: [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, Oct

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

Beautiful. Many thanks for sharing. Kindest regards, Adedayo Sent from Yahoo Mail on Android On Tue, 30 Oct 2018 at 22:34, Lars Helge Øverland wrote: Hi all, heads up: for DHIS 2 version 2.31 we will require PostgreSQL version 9.6. This is in order to take advantage of certain SQL features

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

Hi all, heads up: for DHIS 2 version 2.31 we will require PostgreSQL version 9.6. This is in order to take advantage of certain SQL features introduced in that version. The current required version is 9.4. If you plan to upgrade your PostgreSQL version we recommend going straight to version 10,

Re: [Dhis2-users] Text in Pivot Tables

Hi Damien, Thanks for sharing. We recently experienced the same behavior. It seems the text values are present in the datavaluesets and the analytics tables, they just don't show up in the Pivot App itself. A bit frustrating for the end user because this worked up until quite recently. I need to g

Re: [Dhis2-users] Text in Pivot Tables

Hi Kate, Unsure if anyone else has replied but we tested a Data Element to capture ‘Comments’ in Data Sets & found out it is displayed only when exported to an Excel file in the Pivot Table app/section - an extract is attached. If anyone knows of an update/fix/better alternative please share.

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

Hi all. Kindly assist me to resolve this issue. I want to check a single quoted string in a program rule such as "variable == 'Don't know'". I tried using two single quotes (Don''t know) and escaped with a backward slash (Don\'t know) but it doesn't work. Any suggestions? Your help is very much

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

Hi Terrance, Sometime back I read about this. I think you need to use the expression like - ORG_UNIT_CODE(…) + "-" + CURRENT_DATE(ww) + "-" + SEQUENTIAL(#) Instead of using the function concatenate. Please refer the below link for more details: - https://docs.dhis2.org/mas

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

Dear Zubair, Nick I have upgraded the instance to 2.30 now and am attempting to once again implement the sequential numbering using the TextPattern option. I am using it on a TEAttribute, but have not had any success. Thus far, my Defined program rule action looks as follows: d2:concatenate( V{e

Re: [Dhis2-users] Help needed: Assigning current date to a data element...

Glad to hear it! Terence Scott Global Alliance for Rabies Control (GARC) Pan-African Rabies Control Network (PARACON) Steering Committee terence.sc...@rabiesalliance.org https://paracon.rabiesalliance.org Skype: tpscott1987 On Tue, Oct 30, 2018 at 1:03 PM M.Selvaraaj Prabu wrote: > Thank yo

[Dhis2-users] Duplicate Key Error

Dear All, It had been awhile now that we had been noticing this error in our log: Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "datavalue_pkey" Detail: Key (dataelementid, periodid, sourceid, categoryoptioncomboid, attributeoptioncomboid)=(1

Re: [Dhis2-users] Help needed: Assigning current date to a data element...

Thank you very much Mr.Terence🙏 for pointing to the right direction. It worked.😁 Thanks and regards MSP On Tue, Oct 30, 2018 at 12:39 PM Terence Scott < terence.sc...@rabiesalliance.org> wrote: > Dear MSP > > I am not sure if you are aware, but see the following documentation for > the codes u

Re: [Dhis2-users] Help needed: Assigning current date to a data element...

Dear MSP I am not sure if you are aware, but see the following documentation for the codes used to create the "current date" in the program rule. https://docs.dhis2.org/2.30/en/user/html/configure_program_rule.html Please see *Table 21.14. Standard variables to use in program rule expressions *

[Dhis2-users] Help needed: Assigning current date to a data element...

Hi all, I am Selvaraj Muthusamy from PCI, Botswana. We have customised DHIS2 (2.29) to manage our OVC database. We are using Tracker App to capture the individual case management. We have a field (data element) called "Data entered on" and this has to be the current date and time. I created a dat