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

[Dayo Adeyomoye]

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 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, as it contains several great features and performance improvements. 
Also, we will eventually require this version and so going directly to version 
10 will avoid multiple successive upgrades.

best regards,
Lars


Lars Helge Øverland
Technical lead, DHIS 2University of oslol...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to    : dhis2-us...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help  : https://help.launchpad.net/ListHelp
  
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-us...@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp
___
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] postgresql version 9.6 required for dhis version 2.31

[Lars Helge Øverland]

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, as it contains several great features and performance
improvements. Also, we will eventually require this version and so going
directly to version 10 will avoid multiple successive upgrades.


best regards,

Lars



Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
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] Help needed: Checking a string with single quote in program rule...

[M.Selvaraaj Prabu]

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 appreciated.

Thanks and regards.

MSP
___
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] Generating sequential numbers in program rule

[M.Selvaraaj Prabu]

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/master/en/user/html/working-with-textpattern.html

Hope this helps.

Thanks and regards

MSP


On Tue, Oct 30, 2018 at 4:56 PM Terence Scott <
terence.sc...@rabiesalliance.org> wrote:

> 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{enrollment_date}, '-', V{orgunit_code}, '-')
>
> This is currently working and generating the UID, but of course, without
> the sequential numbers. I have attempted the following combinations to try
> include the sequential numbers to no avail:
> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-',
> SEQUENTIAL(###))
> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-',
> Sequential(###))
> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-',
> V{Sequential(###)})
> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-',
> V{sequential(###)})
> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-',
> V{sequential###})
> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-',
> 'SEQUENTIAL(###)') - this one simply added the text in (as suspected).
> d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-') +
> SEQUENTIAL(###)
>
> None of these combinations have worked thus far. Clearly I am
> misunderstanding something or missing something and would appreciate any
> help.
>
> Kind regards,
> Terence
>
>
> 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 Wed, Oct 10, 2018 at 3:06 PM Zubair Asghar Raja 
> wrote:
>
>> Hi Terence,
>> There could be many reasons for that.
>> Have you tried implementing what Nick suggested? The only limitation is
>> that the TextPattern option is only available for TEAttribute and not to
>> DataElement.
>>
>>
>> Zubair Asghar
>> DHIS-2 Developer
>> University of Oslo
>> zub...@dhis2.org 
>> https://www.dhis2.org
>>
>>
>> On Wed, Oct 10, 2018 at 2:48 PM Terence Scott <
>> terence.sc...@rabiesalliance.org> wrote:
>>
>>> Dear Zubair
>>>
>>> Thank you for your rapid response. I have attempted to do this without
>>> success. I think I am misunderstanding.
>>>
>>> 1) I created the program variable "auto-increment' as suggested
>>> 2) In this step - is this a new program rule? I created a program rule
>>> as follows: "d2:hasValue #UID", Assign "#auto-increment + 1" to field
>>> "auto-increment". I then set this as priority 2.
>>> 3) I created my UID program rule as with the following action:
>>> "d2:concatenate( V{enrollment_date}, '-', A{Closest Health Center},
>>> #{auto-increment})" assigned to the attribute for UID. This is set as
>>> priority 1.
>>>
>>> Unfortunately, this does not create the sequential number, but the
>>> concatenated sequence is showing in the UID Attribute.
>>>
>>> Do I have my priorities incorrect or have I done something else
>>> incorrectly?
>>>
>>> Kind regards,
>>> Terence
>>>
>>> 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 Wed, Oct 10, 2018 at 2:01 PM Zubair Asghar Raja 
>>> wrote:
>>>
 Hi Terence,
 Should be possible using CALCULATED_VALUE.
 Program rule variable having source type as CALCULATED_VALUE will get
 its value assigned by some other program rule. Try these steps
 1. create program rule variable of source type CALCULATED_VALUE // Let
 say "auto-increment"
 2. create program rule with Program Rule Action as Assign Value and
 select variable created in step 1 and assign it "#{auto-increment} + 1"
 3. Use it in your program rule where ever needed for example
 v{current-date}-#{orgunit}-#{auto-increment}

 In order to use CALCULATED_CALUE make sure you are correctly setting
 rule *priority*.

 Zubair Asghar
 DHIS-2 Developer
 University of Oslo
 zub...@dhis2.org 
 https://www.dhis2.org


 On Wed, Oct 10, 2018 at 1:25 PM Terence Scott <
 terence.sc...@rabiesalliance.org> wrote:

> Dear All
>
> I am creating a program rule to develop a UID for the patient. I have
> currently created a program rule using d2:concatenate to bring various
> attributes and DEs together into the Unique ID (such as date and OrgUnit
> code). 

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

[Terence Scott]

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{enrollment_date}, '-', V{orgunit_code}, '-')

This is currently working and generating the UID, but of course, without
the sequential numbers. I have attempted the following combinations to try
include the sequential numbers to no avail:
d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-',
SEQUENTIAL(###))
d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-',
Sequential(###))
d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-',
V{Sequential(###)})
d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-',
V{sequential(###)})
d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-',
V{sequential###})
d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-',
'SEQUENTIAL(###)') - this one simply added the text in (as suspected).
d2:concatenate( V{enrollment_date}, '-', V{orgunit_code}, '-') +
SEQUENTIAL(###)

None of these combinations have worked thus far. Clearly I am
misunderstanding something or missing something and would appreciate any
help.

Kind regards,
Terence


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 Wed, Oct 10, 2018 at 3:06 PM Zubair Asghar Raja  wrote:

> Hi Terence,
> There could be many reasons for that.
> Have you tried implementing what Nick suggested? The only limitation is
> that the TextPattern option is only available for TEAttribute and not to
> DataElement.
>
>
> Zubair Asghar
> DHIS-2 Developer
> University of Oslo
> zub...@dhis2.org 
> https://www.dhis2.org
>
>
> On Wed, Oct 10, 2018 at 2:48 PM Terence Scott <
> terence.sc...@rabiesalliance.org> wrote:
>
>> Dear Zubair
>>
>> Thank you for your rapid response. I have attempted to do this without
>> success. I think I am misunderstanding.
>>
>> 1) I created the program variable "auto-increment' as suggested
>> 2) In this step - is this a new program rule? I created a program rule as
>> follows: "d2:hasValue #UID", Assign "#auto-increment + 1" to field
>> "auto-increment". I then set this as priority 2.
>> 3) I created my UID program rule as with the following action:
>> "d2:concatenate( V{enrollment_date}, '-', A{Closest Health Center},
>> #{auto-increment})" assigned to the attribute for UID. This is set as
>> priority 1.
>>
>> Unfortunately, this does not create the sequential number, but the
>> concatenated sequence is showing in the UID Attribute.
>>
>> Do I have my priorities incorrect or have I done something else
>> incorrectly?
>>
>> Kind regards,
>> Terence
>>
>> 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 Wed, Oct 10, 2018 at 2:01 PM Zubair Asghar Raja 
>> wrote:
>>
>>> Hi Terence,
>>> Should be possible using CALCULATED_VALUE.
>>> Program rule variable having source type as CALCULATED_VALUE will get
>>> its value assigned by some other program rule. Try these steps
>>> 1. create program rule variable of source type CALCULATED_VALUE // Let
>>> say "auto-increment"
>>> 2. create program rule with Program Rule Action as Assign Value and
>>> select variable created in step 1 and assign it "#{auto-increment} + 1"
>>> 3. Use it in your program rule where ever needed for example
>>> v{current-date}-#{orgunit}-#{auto-increment}
>>>
>>> In order to use CALCULATED_CALUE make sure you are correctly setting
>>> rule *priority*.
>>>
>>> Zubair Asghar
>>> DHIS-2 Developer
>>> University of Oslo
>>> zub...@dhis2.org 
>>> https://www.dhis2.org
>>>
>>>
>>> On Wed, Oct 10, 2018 at 1:25 PM Terence Scott <
>>> terence.sc...@rabiesalliance.org> wrote:
>>>
 Dear All

 I am creating a program rule to develop a UID for the patient. I have
 currently created a program rule using d2:concatenate to bring various
 attributes and DEs together into the Unique ID (such as date and OrgUnit
 code). However, I would also like to include sequential numbering after
 this to ensure that more than 1 case can be registered on a single day.

 I have looked through all of the documentation and am unable to find
 anything along these lines. Is it possible?

 Example:
 2018-10-10-OrgUnit code-1;
 2018-10-10-OrgUnit code-2;
 2018-10-10-OrgUnit code-3; etc.  (where 1,2 and 3 are the sequential
 numbers generated).

 I have also looked at Program Rule variables and am unsure as to what
 the "Calculated value" source type is, as in the documentation it is listed
 as "TBA" with no further 

[Dhis2-devs] Help needed: Instance not starting after cloning...

[M.Selvaraaj Prabu]

Hi all,

Kindly note I cloned our production instance using the following steps:

   1. Created an instance (dhis2-create-instance -p 9095 my_ins)
   2. Copied and adjusted the hibernate.properties file from production.
   3. Cloned the production instance (dhis2-clone source my_ins)
   4. Started the new instance (dhis2-startup my_ins).

But, the new instance is not working and displaying the following error:

[image: image.png]
When I checked dhis2-logtail, I see some error as below:

   - SEVERE: The web application [/my_ins] created a ThreadLocal with key
   of type [com.google.inject.internal.InjectorImpl$1] (value
   [com.google.inject.internal.InjectorImpl$1@629c8cf2]) and a value of
   type [java.lang.Object[]] (value [[Ljava.lang.Object;@31b3486b]) but
   failed to remove it when the web application was stopped. Threads are going
   to be renewed over time to try and avoid a probable memory leak.

And I checked "netstat -ln" and the port 9095 is listening.

Any assistance is highly appreciated.

Thanks and regards

MSP
___
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] Use of square brackets [] in metadata field filter

[Vladimer Shioshvili]

We faced the same issue, and I have brought it to Lars' attention, and he
is aware of the issue. According to him, DHIS2 will be addressing this by
changing square brackets in the long term, but in the short term solution
you can make square brackets be exempted on the tomcat side by using
relaxedQueryChars="[]" in the Tomcat connector configuration.


On Tue, Oct 30, 2018 at 6:57 AM Jasper Timm 
wrote:

> Hi DHIS2 devs,
>
> I faced an issue recently with using (unencoded) square brackets in
> requests to the DHIS2 API. It turns out it was related to a new version of
> tomcat (7.0.90). I've spoken to the tomcat devs and they've said that they
> will now consider unencoded square brackets in a request to be an error.
>
> According to the docs:
> https://docs.dhis2.org/master/en/developer/html/webapi_metadata_field_filter.html
>  square
> brackets are used to indicate a subfield, when using the field query
> parameter.
>
> Might it be worth considering changing the symbol used for this? At the
> very least it should be made clear that the requests using it will need to
> be URL encoded.
>
> There are even requests in the DHIS2 frontend (I'm running v2.27) which
> have unencoded square brackets. The approvals page in the report view fails
> with the new version of tomcat for this reason. It would be worth ensuring
> all frontend requests are properly encoded.
>
> Cheers,
>
> - Jasper
> --
>
> Jasper Timm
>
> Lead Software Developer
>
> 
>
> eHealth Africa
> 4A Renner Drive
> Off Wilkinson Road (behind Monoprix Supermarket)
> Freetown, Sierra Leone
>
> mobile +232 99891119
>
> --
>
> 
> 
> 
> 
> 
> ___
> 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
>
___
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] [Dhis2-users] Help needed: Assigning current date to a data element...

[M.Selvaraaj Prabu]

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 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  *
>
> From what I am aware, these variables are applicable to past versions also
> (therefore should work for 2.29 and 2.28 as I have used them in 2.28).
>
> I hope this helps.
>
> Kind regards,
> Terence
>
> 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 12:11 PM M.Selvaraaj Prabu 
> wrote:
>
>> 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 data element "Data entered on" as
>> "Date" type. Now I want to assign the current date and time automatically
>> to this field when the form is opened. Unfortunately, I am failing to set
>> this up through a program rule. I could not find a function or system
>> variable to use for this purpose.
>>
>> Any help is highly appreciated.
>>
>> Thanks and regards
>>
>> MSP
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
___
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] Duplicate Key Error

[gerald thomas]

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)=(1969, 9498235, 326, 13, 13) already exists.
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476)

Please i need to know why are we getting these error messages and how can i
fix them.
Thanks in advance for your help.


-- 
Regards,

Gerald
___
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] [Dhis2-users] Help needed: Assigning current date to a data element...

[Terence Scott]

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 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 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  *
>>
>> From what I am aware, these variables are applicable to past versions
>> also (therefore should work for 2.29 and 2.28 as I have used them in 2.28).
>>
>> I hope this helps.
>>
>> Kind regards,
>> Terence
>>
>> 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 12:11 PM M.Selvaraaj Prabu 
>> wrote:
>>
>>> 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 data element "Data entered on" as
>>> "Date" type. Now I want to assign the current date and time automatically
>>> to this field when the form is opened. Unfortunately, I am failing to set
>>> this up through a program rule. I could not find a function or system
>>> variable to use for this purpose.
>>>
>>> Any help is highly appreciated.
>>>
>>> Thanks and regards
>>>
>>> MSP
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-us...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
___
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] Use of square brackets [] in metadata field filter

[Jasper Timm]

Hi DHIS2 devs,

I faced an issue recently with using (unencoded) square brackets in
requests to the DHIS2 API. It turns out it was related to a new version of
tomcat (7.0.90). I've spoken to the tomcat devs and they've said that they
will now consider unencoded square brackets in a request to be an error.

According to the docs:
https://docs.dhis2.org/master/en/developer/html/webapi_metadata_field_filter.html
square
brackets are used to indicate a subfield, when using the field query
parameter.

Might it be worth considering changing the symbol used for this? At the
very least it should be made clear that the requests using it will need to
be URL encoded.

There are even requests in the DHIS2 frontend (I'm running v2.27) which
have unencoded square brackets. The approvals page in the report view fails
with the new version of tomcat for this reason. It would be worth ensuring
all frontend requests are properly encoded.

Cheers,

- Jasper
-- 

Jasper Timm

Lead Software Developer



eHealth Africa
4A Renner Drive
Off Wilkinson Road (behind Monoprix Supermarket)
Freetown, Sierra Leone

mobile +232 99891119

--






___
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] [Dhis2-users] Help needed: Assigning current date to a data element...

[Terence Scott]

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  *

>From what I am aware, these variables are applicable to past versions also
(therefore should work for 2.29 and 2.28 as I have used them in 2.28).

I hope this helps.

Kind regards,
Terence

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 12:11 PM M.Selvaraaj Prabu 
wrote:

> 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 data element "Data entered on" as
> "Date" type. Now I want to assign the current date and time automatically
> to this field when the form is opened. Unfortunately, I am failing to set
> this up through a program rule. I could not find a function or system
> variable to use for this purpose.
>
> Any help is highly appreciated.
>
> Thanks and regards
>
> MSP
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
___
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] FW: events report through API

[Bernard Sadaka (IM Advisor)]

I sent the bellow few days ago to the users mailing list, but I believe the
developers would be able to help more.

Thank you in advance for your help.

All the best,

Bernard

 




Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib@pu-ami.org   

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.premiere-urgence.org/ 

 

 

From: Bernard Sadaka (IM Advisor) [mailto:lib@pu-ami.org] 
Sent: 26 October 2018 16:49
To: 'dhis2-us...@lists.launchpad.net' 
Subject: events report through API

 

Dear All,

I’m trying to get events report data through API and so far failing, here is
what I am doing:

· The report is saved and I can see it in the web browser

· I’m opening favorites and then get link:



· I’m taking the open in web api url:



· I try to get it using curl, postman or any other method (using
basic authentication), it give me nothing: {}

· I try to get another TEI report through the API:
/api/28/trackedEntityInstances.json?ou=H6GHIV7zcTD=DESCENDANTS It
works perfectly and gives all the data

· I’m using  Version: 2.28 Build revision: a5da35f Build date:
2018-08-02 06:23

 

Your help is very much appreciated.

Looking forward to hearing from you.

All the best,

Bernard

 




Bernard Sadaka

Information Management Advisor

Première Urgence - Aide Médicale Internationale

Nehmeh Building, Sanine Street, Chiyah, 3rd Floor

Ain el Remmaneh, Beirut, Lebanon

E-mail: lib@pu-ami.org   

Cell: +961 71 004 881 (208)

Skype: imapuami

Website: https://www.premiere-urgence.org/ 

 

 

___
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