Re: [Dhis2-devs] [Dhis2-users] Tracker capture: Complete button performance decreased since 2.30

[Markus Bekken]

Thanks!
The performance fixes two weeks ago was mainly on the rendering speed and not 
specifically on the rules which was perfomant in our test enviroment. We will 
look into the issue linked by ignacio below.

Markus

> 27. nov. 2018 kl. 10:42 skrev Ignacio Foche  <mailto:nacho.fo...@gmail.com>>:
> 
> Hi Eric & Markus,
> 
> We're also experiencing the same performance issue, plus others related to 
> the program rules. Please see here the Jira issue that we created for this:
> https://jira.dhis2.org/browse/DHIS2-5259 
> <https://jira.dhis2.org/browse/DHIS2-5259> 
> 
> (BTW, we've also tested with yesterday build from Jenkins that improved a bit 
> but still far from what we had in 2.28)
> 
> Thank you in advance for your help.
> 
> Best regards
> 
> Le mar. 27 nov. 2018 à 09:29, Eric Barreda Prades  <mailto:ericbarre...@gmail.com>> a écrit :
> Hi Markus,
>  
> Thanks a lot for your quick response. Our build is quite updated:
>  
> Build revision:
> 47460e8
> Build date:
> 2018-11-19 10:54
>  
> However to be fair I think that the process has speed up a little bit from 
> our last build. Let me update our version to the latest build and see how is 
> it going.
>  
> Yours,
> 
> Eric 
> 
> 
> El lun., 26 nov. 2018 a las 21:40, Markus Bekken ( <mailto:mar...@dhis2.org>>) escribió:
> Hi there Eric!
> Is your 2.30 build more than 14 days old? We did some tracker client 
> performance fixes on nov 14 and nov 16. 
> 
> Markus
> 
> 26. nov. 2018 kl. 18:05 skrev Eric Barreda Prades  <mailto:ericbarre...@gmail.com>>:
> 
>> Dear users,
>> 
>> Since we have upgraded our system to version 2.30 we have observed that 
>> after clicking on the Complete button in an event it takes longer to 
>> actually complete that event that it used to (it might take about 5 to 10 
>> seconds from the moment we click the Complete button and the values actually 
>> turning to grey). I have tested it in DHIS2 2.30 play version but I see no 
>> disruption on performance. I was wondering if someone in here has ever 
>> experienced something similar.
>> 
>> Also simulated through command line (example for play server but also done 
>> in our instance):
>> 
>> curl -X PUT -H "Content-Type: application/json"  
>> https://play.dhis2.org/2.29/api/29/events/tAg4jQEL8Qv 
>> <https://play.dhis2.org/2.29/api/29/events/tAg4jQEL8Qv> 
>> 
>> The payload size in localinstance is quite similar to the one sending in 
>> play server (both attached). However while our TTFB is (for instance) over 
>> 6000ms in our local server, the play server is almost immediate. No 
>> different results observed after emptying our datavalue tables.
>> 
>> Any advice in terms of infrastucture is more than welcome. 
>> 
>> Thanks,
>> 
>> Eric
>> 
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-us...@lists.launchpad.net 
>> <mailto:dhis2-us...@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp 
>> <https://help.launchpad.net/ListHelp>
> ___
> Mailing list: https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> Post to : dhis2-us...@lists.launchpad.net 
> <mailto:dhis2-us...@lists.launchpad.net>
> Unsubscribe : https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> More help   : https://help.launchpad.net/ListHelp 
> <https://help.launchpad.net/ListHelp>
> -- 
> Ignacio Foche Pérez

___
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] Tracker capture: Complete button performance decreased since 2.30

[Markus Bekken]

Hi there Eric!
Is your 2.30 build more than 14 days old? We did some tracker client 
performance fixes on nov 14 and nov 16. 

Markus

> 26. nov. 2018 kl. 18:05 skrev Eric Barreda Prades :
> 
> Dear users,
> 
> Since we have upgraded our system to version 2.30 we have observed that after 
> clicking on the Complete button in an event it takes longer to actually 
> complete that event that it used to (it might take about 5 to 10 seconds from 
> the moment we click the Complete button and the values actually turning to 
> grey). I have tested it in DHIS2 2.30 play version but I see no disruption on 
> performance. I was wondering if someone in here has ever experienced 
> something similar.
> 
> Also simulated through command line (example for play server but also done in 
> our instance):
> 
> curl -X PUT -H "Content-Type: application/json"  
> https://play.dhis2.org/2.29/api/29/events/tAg4jQEL8Qv 
> 
> The payload size in localinstance is quite similar to the one sending in play 
> server (both attached). However while our TTFB is (for instance) over 6000ms 
> in our local server, the play server is almost immediate. No different 
> results observed after emptying our datavalue tables.
> 
> Any advice in terms of infrastucture is more than welcome. 
> 
> Thanks,
> 
> Eric
> 
> 
> ___
> 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

Re: [Dhis2-devs] [Dhis2-users]Data set not showing from user end

[Markus Bekken]

Hi there Mahbubul,
In 2.29 and later, you have to also share the data set with the user groups 
that should have access to the data set - giving them the "Data: Can capture 
data" access level.

If you haven't already, take a look at this: 
https://docs.dhis2.org/master/en/user/html/data-sharing-and-access-control.html#data-sharing-for-data-sets
 


Markus

> 26. nov. 2018 kl. 08:18 skrev Mahbubul Alam  >:
> 
> Dear All,
> Recently we upgrade our dhis2 with version 2.29..
> All things are working nicely from admin end.But from user end data set is 
> not showing.
> If i assign ALL from user role (for data entry user), then its work.But i 
> don't want to assign ALL authorities to users.
> 
> 
> Need some help.
> Thanks 
> 
> -- 
> 
> Thanks
> Mahbubul Alam | "IT Consultant" (GHSA Project)
> Msc in CSE, Bsc in CSc. Associate Member of BCS.
> 
> Institute of Epidemiology Disease Control & Research (IEDCR)
> www.iedcr.gov.bd 
> Mohakhali Dhaka.
> ___
> 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] Relationships - relationship link not showing on TE #2

[Markus Bekken]

Hey Terence,
It would be great if you put this into a jira bug. The relationship you send a 
screenshot of below is a TEI-TEI relationship, which should be supported. In 
the preliminary investigation it also seems that nonsupported relationship is 
not always gracefully handled in the tracker.

Thanks for reporting. We will get back to you if we see any possible 
workarounds in the investigation.

Markus

> 14. nov. 2018 kl. 11:36 skrev Terence Scott  <mailto:terence.sc...@rabiesalliance.org>>:
> 
> Dear Markus
> 
> Thanks for the response. I will create any new conversations in the community 
> forum as mentioned. 
> 
> Relating to my current issue, we are creating relationships between two 
> different enrollments in 2 different programs (One program for a suspect 
> animal and the other for an exposed human). I would like to link the "exposed 
> animal" to the "exposed human" (each a relationship type). Therefore, for the 
> "Exposed person" relationship type, I have the "Exposed Animal" linked with 
> the Suspect animal program, followed by the second TE type being the exposed 
> person linked with the Exposed human program. The "From constraint" is "TE 
> instance". 
> 
> I tried to do the same with the "Exposed animal" Relationship type, but this 
> resulted in some other errors which I thought were attributed to redundancy. 
> Therefore, for the moment, I only have the "Exposed person" relationship type 
> set up. 
> 
> Under each of the programs themselves, I have also selected the relevant TE 
> type. Under "Related program" I selected the sister program (i.e. for the 
> Suspect animal program, I selected exposed human and visa versa).
> 
> I hope I managed to explain this clearly. I have attached a screenshot of how 
> I set up the relationship type for your reference. 
> 
> Kind regards,
> Terence
> 
>   
> Terence Scott
> 
> Global Alliance for Rabies Control (GARC)
> Pan-African Rabies Control Network (PARACON) Steering Committee
> terence.sc...@rabiesalliance.org <mailto:terence.sc...@rabiesalliance.org>
> https://paracon.rabiesalliance.org <https://paracon.rabiesalliance.org/>
> Skype: tpscott1987
> 
> 
> 
> On Wed, Nov 14, 2018 at 10:56 AM Markus Bekken  <mailto:mar...@dhis2.org>> wrote:
> Hey Terence,
> you mention programs are you making relations from one enrollment to another? 
> How is your relationship type set up? The only relationship type that is 
> supported in the tracker clients is tracked entity instance to tracked entity 
> instance. The rich possibilities in the new relationship model is starting to 
> be consumed in the new capture app first, and is per now  not scheduled to be 
> implemented in the current generation of tracker app.
> 
> Markus
> 
> P.S. we are moving these topics to the community.dhis2.org 
> <http://community.dhis2.org/> - a great tool for collaborating, discussing in 
> threads and building a searchable knowledge base at the same time.
> 
>> 13. nov. 2018 kl. 13:42 skrev Terence Scott 
>> mailto:terence.sc...@rabiesalliance.org>>:
>> 
>> Dear Community
>> 
>> I have been working on creating relationships between two programs. I have 
>> managed to create a relationship from 1 program to the other. However, on 
>> the enrollment screen for the 2nd TE (TE#2), no program is selected. I then 
>> select the appropriate program, but the relationship to the original TE 
>> (TE#1) is lost.
>> 
>> I assume that there is something that I am missing here? I have specified 
>> the referred and original programs for the Tracked Entity Type, yet this 
>> does not work. 
>> 
>> I also get the following reference error: 
>> 
>> 
>> 
>> I am running v2.30. 
>> 
>> Any help or guidance would be appreciated. 
>> 
>> Kind regards,
>> Terence
>> 
>>  
>> Terence Scott
>> 
>> Global Alliance for Rabies Control (GARC)
>> Pan-African Rabies Control Network (PARACON) Steering Committee
>> terence.sc...@rabiesalliance.org <mailto:terence.sc...@rabiesalliance.org>
>> https://paracon.rabiesalliance.org <https://paracon.rabiesalliance.org/>
>> Skype: tpscott1987
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> Post to : dhis2-devs@lists.launchpad.net 
>> <mailto:dhis2-devs@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp 
>> <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] Relationships - relationship link not showing on TE #2

[Markus Bekken]

Hey Terence,
you mention programs are you making relations from one enrollment to another? 
How is your relationship type set up? The only relationship type that is 
supported in the tracker clients is tracked entity instance to tracked entity 
instance. The rich possibilities in the new relationship model is starting to 
be consumed in the new capture app first, and is per now  not scheduled to be 
implemented in the current generation of tracker app.

Markus

P.S. we are moving these topics to the community.dhis2.org 
 - a great tool for collaborating, discussing in 
threads and building a searchable knowledge base at the same time.

> 13. nov. 2018 kl. 13:42 skrev Terence Scott 
> :
> 
> Dear Community
> 
> I have been working on creating relationships between two programs. I have 
> managed to create a relationship from 1 program to the other. However, on the 
> enrollment screen for the 2nd TE (TE#2), no program is selected. I then 
> select the appropriate program, but the relationship to the original TE 
> (TE#1) is lost.
> 
> I assume that there is something that I am missing here? I have specified the 
> referred and original programs for the Tracked Entity Type, yet this does not 
> work. 
> 
> I also get the following reference error: 
> 
> 
> 
> I am running v2.30. 
> 
> Any help or guidance would be appreciated. 
> 
> 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
> 
> ___
> 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] Program Rule conditions not evaluating

[Markus Bekken]

Hey Cha!
You are doing some pretty advanced expressions here, but it seems you got the 
syntax all correct. We are making better tools for syntax and integrity 
checking in the coming DHIS2 versions, I can imagine you had to do some 
counting to check that you got the right amount of parenthesis here :)

From the warning in the console it seems that the value not getting populated 
into the expression is the #{f6a_pr_edd_final}. How is this variable 
configured? Is it linked to one of the data elements? And is this data element 
filled in? Perhaps you could make one more condition to avoid triggering the 
rule at all if #{f6a_pr_edd_final} does not have a value?

Markus

P.S. it would be great if you can post this as a topic on community.dhis2.org 
 - and we can continue there.

> 2. nov. 2018 kl. 16:59 skrev Warancha Tumtaweetikul  >:
> 
> Hi Markus,
>  
> I’m having a problem getting a few program rules to work. 
>  
> We have a long condition where: 
> (40-d2:weeksBetween(V{event_date},#{f6a_pr_edd_final}))>=16 && 
> (40-d2:weeksBetween(V{event_date},#{f6a_pr_edd_final}))<=36 && 
> ((40-d2:weeksBetween(V{event_date},#{f6a_pr_edd_final}))-#{f6a_pr_as_sfh})<=2
>  
> However, the console (please see image below) keeps on showing that the 
> program rule variables are not getting evaluated even though those fields are 
> populated and assigned the values from the other variables.
> The second problem is we’re getting several “Could not perform background 
> update of…” errors even though it seems the data has been saved to the 
> database. We have several program rules to assign the value of one variable 
> to three other variables (ex. Changing the date of a data element would 
> change another data element with the new calculated date) in the order of its 
> priority. I’ve tried deleting the program rule conditions one at a time, and 
> the errors did disappear, and reappeared once I put the conditions back in. 
> For example, this UiD: IH7Nnis3UMd is a data element, that gets assigned a 
> value using program rule action by two program rules with different 
> priorities. We’re trying to troubleshoot, but still have yet to figure out 
> the solution.
>  
> Hope this makes sense!
>  
> Thank you.
>  
> Sincerely,
> Cha
>  
> 

___
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] 404 response from the API when using Event Capture

[Markus Bekken]

Hey Carlos and Kevin,
The eventCaptureGridColumns call is likely not the problem - this error is just 
a bit of log noise that comes in the console for everyone that has never 
rearranged the columns in the event capture. 

Have you tried clearing the cache with the cache cleaner app? Is there any 
other calls failing during the startup that seems to fail? I tried reproducing 
in 2.29 play but the app seems to be working there.

Markus

P.S. we are welcoming you all to join community.dhis2.org 
 for support and discussions on DHIS2.

> 2. nov. 2018 kl. 13:21 skrev Kevin Bolger  >:
> 
> Hi Carlos,
> 
> Thanks for your response. Any idea what the correct format might be?
> 
> Thanks,
> Kevin
> 
> On Fri, Nov 2, 2018 at 1:59 AM Carlos Nyembwe  > wrote:
> Hi Kevin,
> 
> be sure on your API Url, I think It's not well
> 
> Regards
> 
> On Fri, Nov 2, 2018 at 4:54 AM Kevin Bolger  > wrote:
>     This message is eligible for Automatic 
> Cleanup! (kevin.bol...@gmail.com ) Add cleanup 
> rule 
> 
>  | More info 
> 
>  
> Hi Folks,
> 
> I've deployed 2.29 build e1c949f (full About details below) on an aws ec2 
> instance running Ubuntu 16.04.5 LTS (GNU/Linux 4.4.0-1070-aws x86_64).
> 
> When trying to use the Event Capture app to record a single event the page 
> load stalls. 
> In response to the api call;
> 8080/api/28/userDataStore/gridColumns/eventCaptureGridColumns
> the debugging console in chrome shows the following error; 
> {"httpStatus":"Not 
> Found","httpStatusCode":404,"status":"ERROR","message":"The key 
> 'eventCaptureGridColumns' was not found in the namespace 'gridColumns'."}
>  
> The catalina.out logs don't show any warning or error when the issue occurs 
> or anything referencing an obviously related issue during the ROOT.war 
> deployment. Any suggestions on how to further troubleshoot would be greatly 
> appreciated.
> 
> Best,
> Kevin
>  
> Current user:
> admin
> Version:
> 2.29
> Build revision:
> e1c949f
> Build date:
> 2018-11-02 02:21
> Jasper reports version:
> 6.3.1
> User agent:
> Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, 
> like Gecko) Chrome/70.0.3538.77 Safari/537.36
> Server date:
> 2018-11-02 03:20
> Last analytics table generation:
> Time since last analytics table generation:
> Last analytics table runtime:
> Environment variable:
> DHIS2_HOME
> External configuration directory:
> /home/dhis/config
> File store provider:
> filesystem
> Node ID:
> Cache provider:
> ehcache
> Database type:
> DhisPostgres
> Database name:
> dhis2
> Database user:
> dhis
> Read replica count:
> 0
> Java opts:
> -Xmx768m -Xms512m -Djdk.tls.ephemeralDHKeySize=2048 
> -Djava.protocol.handler.pkgs=org.apache.catalina.webresources 
> -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
> Java version:
> 1.8.0_181
> Java vendor:
> Oracle Corporation
> OS name:
> Linux
> OS architecture:
> amd64
> OS version:
> 4.4.0-1070-aws
> Server memory:
> Mem Total in JVM: 744 Free in JVM: 451 Max Limit: 744
> CPU cores:
> 2
> ___
> 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 
> 
> 
> 
> -- 
> Carlos Nyembwe
> I'm just a Computer Scientist
> 
> Skype: carloscnk1
> Cell: (+243)813166381
> Find me in: | Google Plus  | Linkedin 
>  | Facebook 
>  | Twitter 
>  |
> ___
> 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] Request

[Markus Bekken]

Hi there Pradeep,
can you give some more details on the indicator you want to make, and how you 
want to evaluate the date? Its great if you provide the details in a new post 
in community.dhis2.org 

Markus

> 2. nov. 2018 kl. 14:12 skrev Pradeep Kumar Thakur :
> 
> Hi,
>  
> I want to develop program indicators based on date (calendar) elements of 
> Tracker Capture version 2.9. Please suggest me the steps.
>  
> Regards,
> Pradeep
> ___
> 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

Re: [Dhis2-devs] Default event report Date on DHIS2 Version 2.28

[Markus Bekken]

Hey there Isabane :)

We do not support configuring this at the moment, and you are welcome to 
register a jira feature request explaining your use case: jira.dhis2.org 
.

Do you expect most events to be back-entry you might also make a program rule 
that informs the user if she creates an event that has the current date as 
event date. This can be done with a warning, an error or information in the 
feedback widget. Happy to discuss options further on: 
https://community.dhis2.org/ 

Best regards,
Markus


> 1. nov. 2018 kl. 09:45 skrev Isabane Janvier  >:
> 
> Hello everyone,
> 
> My name is ISABANE Janvier from HISP – Rwanda. We are currently working on 
> tracker program and we would like to know if there is a way of not prompting 
> current date (Leave It empty) on reporting date while creating a new event.
> The reason is that “People tend to leave it as it is (Current Date) shows up 
> by default even when historical date entered ”
> for instance I want to capture event happened last week and by adding the new 
> event on stage, reporting date comes by current date by default. Users by 
> mistake leave it as it is.
> 
> 
> we are using DHIS2 Version 2.28
> 
> 
> 
> Best Regards,
>  
> -
> ISABANE Janvier 
> Junior Programmer
> HISP Rwanda.
> Mobile: +250 788 286 107, 
> address: KG 113 St, Kigali - Rwanda
> website: hisprwanda.org  
> e-mail: isabane.janv...@hisprwanda.org 
>  / isaba...@gmail.com 
> 
> 
> ___
> 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: Checking a string with single quote in program rule...

[Markus Bekken]

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 value - hopefully the code is without a quotation mark. If 
this is the case, open the program rule variable in maintenance and select "use 
code for option set":

When this is checked, you can possibly rewrite your rule to check for the 
option instead:

#{variable} == 'OPT_DONT_KNOW_CODE'

Markus

> 31. okt. 2018 kl. 07:55 skrev Terence Scott  >:
> 
> 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) Steering Committee
> terence.sc...@rabiesalliance.org 
> https://paracon.rabiesalliance.org 
> Skype: tpscott1987
> 
> 
> 
> On Tue, Oct 30, 2018 at 10:26 PM M.Selvaraaj Prabu  > wrote:
> 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-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

Re: [Dhis2-devs] upgrade to 2.29

[Markus Bekken]

Dear Houssam, 

after upgrading there might be data or files cached in your web browser that is 
not compatible with the new version of the app. Please try using the "Cache 
cleaner" app and clear the data.

Markus

> 24. sep. 2018 kl. 09:02 skrev Houssam Chammaa :
> 
> Dear All
> 
> Please note that i have upgraded our DHIS2 server from 2.28 to 2.29 (Build 
> revision 923ff34) by running the script and loading the DHIS.war file
> It was totally successful
> 
> But while running Tracker capture i got this error:
> 
> FAILED TO LOAD METADATA
> 
> Kindly advise
> 
> 
> 
> ___
> 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] delete program manually cause error!

[Markus Bekken]

Hi Lin!
When updating data in the database in a running server, there might be a 
mismatch between cached data and the actual content of the database. I suggest 
you restart the dhis instance, and expect that this will fix your problem.

Markus

> 13. sep. 2018 kl. 15:05 skrev 林晓东 :
> 
> HI,all,
>  I can't delete the program from maintains, so, do using sql: 
> 
> delete from programinstance where programid='103926124'
> delete from dashboard_items where dashboarditemid in (select dashboarditemid 
> from dashboarditem where eventreport in (select eventreportid from 
> eventreport where programid='103926124'))
> delete from dashboarditem where eventreport in (select eventreportid from 
> eventreport where programid='103926124')
> delete from  eventreport_columns where eventreportid in (select eventreportid 
> from eventreport where programid='103926124')
> delete from  eventreport_dataelementdimensions where eventreportid in (select 
> eventreportid from eventreport where programid='103926124')
> delete from  eventreport_organisationunits where eventreportid in (select 
> eventreportid from eventreport where programid='103926124')
> delete from  eventreport_periods where eventreportid in (select eventreportid 
> from eventreport where programid='103926124')
> 
> delete from eventreport where programid='103926124'
> delete from program_organisationunits where programid='103926124'
> delete from  programstagesection_dataelements where programstagesectionid in 
> (select programstagesectionid from programstagesection where programstageid 
> in ( select programstageid from programstage where programid='103926124'))
> 
> delete from programstagesection where programstageid in (select 
> programstageid from programstage where programid='103926124')
> --
> delete from trackedentitydatavalue where   programstageinstanceid in (select 
> programstageinstanceid from programstageinstance a,programinstance b  where 
> a.programinstanceid=b.programinstanceid and b.programid='103926124' )
> 
> delete from programstagedataelement where programstageid in (select 
> programstageid from programstage where programid='103926124')
> 
> delete from programstage where programid='103926124'
> 
> delete from program  where programid='103926124'  
> 
> but , can't open dhis2:
>http://--/dhis/api/programs  :  
> {"httpStatus":"Internal Server 
> Error","httpStatusCode":500,"status":"ERROR","message":"No row with the given 
> identifier exists: [org.hisp.dhis.program.Program#103926124]"}
> 
> how?
> 
> 
> 
> 
> --
> 此致
> 
>林晓东
> 
> 莫愁前路无知己，天下谁人不识君。
> 
> 
>  
> ___
> 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] Event Sync Error From Dhis2 Mobile App V2.29

[Markus Bekken]

Hey Calle, Sourabh, others. Thanks for reporting, we are looking at this on 
priority.

You can follow the progress in Jira here: 
https://jira.dhis2.org/browse/DHIS2-4480 


> 24. aug. 2018 kl. 11:12 skrev Calle Hedberg  >:
> 
> Sourabh,
> 
> This bug affects the browser too, blocking data capture. Viet is 
> investigating the issue, according to Markus. No other info yet.
> 
> Regards
> calle
> 
> On Thu, 23 Aug 2018 at 15:07, Sourabh Bhardwaj  > wrote:
> Hi All,
> 
> We have recently upgrade Dhis2 from version 2.27 to 2.29. While trying to 
> sync enrollment/events from android app , I am able to sync enrollment but 
> following response is coming for event sync: 
> 
> Failed to lazily initialize a collection of 
> role:org.hisp.dhis.dataelement.DataelementCategoryOptionCombo.categoryOptions,
>  could not initialize proxy: no sessions
> 
> However I am able to sync events successfully using the 'superuser' access. 
> Is there any role related to CategoryOptionCombo which I am missing on if 
> so,I am using tracker module only not the aggregated. 
> 
> I have attached the screenshot below with this email:
> 
> Thanks & Regards,
> Sourabh Bhardwaj
> HISP India
> 
> 
> 
> 
>  
> ___
> 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 
> 
> 
> 
> -- 
> *** <>
> Calle Hedberg
> 
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
> 
> Tel/fax (home): +27-21-685-6472
> 
> Cell: +27-82-853-5352
> 
> Iridium SatPhone: +8816-315-19119
> 
> Email: calle.hedb...@gmail.com 
> Skype: calle_hedberg
> 
> ***
> 
> 
> ___
> 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] HOW TO DOWNLOAD TEI'S FROM 2.29 TRACKER CAPTURE

[Markus Bekken]

Stanley, try this URL:
https://fhi360mal.baosystems.com/api/trackedEntityInstances/query.csv 
<https://fhi360mal.baosystems.com/api/trackedEntityInstances/query.csv>

> 22. aug. 2018 kl. 12:14 skrev Morten Olav Hansen :
> 
> I mean the name of your actual .war file, not the version of DHIS2... since 
> you are getting a 404, it means you are pointing to an invalid URL, and that 
> error is coming from tomcat and not dhis2.. which means you are probably not 
> pointing to the right path on your tomcat server.
> 
> -- 
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> Team Integration Lead
> University of Oslo
> http://www.dhis2.org
>  <http://www.dhis2.org/>
> 
> On Wed, Aug 22, 2018 at 2:42 PM Stanley Kalyati  <mailto:skaly...@gmail.com>> wrote:
> Dear Morten,
> 
> Yes it is 2.29.
> 
> 
> 
> On Wed, Aug 22, 2018 at 9:29 AM Morten Olav Hansen  <mailto:mor...@dhis2.org>> wrote:
> Hi
> 
> Is your war file named 2.29? if not the start of that path is wrong (we have 
> 2.29 2.28 etc on your play server to be able to have multiple instances..)
> 
> -- 
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> Team Integration Lead
> University of Oslo
> http://www.dhis2.org
>  <http://www.dhis2.org/>
> 
> On Wed, Aug 22, 2018 at 2:13 PM Markus Bekken  <mailto:markus.bek...@gmail.com>> wrote:
> Hey again!
> Can you send me the full link you are trying, and also the link to the login 
> page of your dhis instance?
> 
> Markus
> 
>> 22. aug. 2018 kl. 08:57 skrev Stanley Kalyati > <mailto:skaly...@gmail.com>>:
>> 
>> Hi Markus,
>> 
>> I have tried wgoing directly to the API but i keep getting this error
>> What could be the problem.I am using version 2.29
>> HTTP Status 404 - /2.29/api/29/trackedEntityInstances/query.csv
>> 
>> 
>> On Thu, Jul 5, 2018 at 9:32 AM Markus Bekken > <mailto:mar...@dhis2.org>> wrote:
>> Hey Stanley,
>> thanks for the feedback.
>> 
>> You can go directly to the API and get the CSV:
>> https://play.dhis2.org/2.28/api/28/trackedEntityInstances/query.csv?ou=ImspTQPwCqd&ouMode=DESCENDANTS&program=WSGAb5XwJ3Y
>>  
>> <https://play.dhis2.org/2.28/api/28/trackedEntityInstances/query.csv?ou=ImspTQPwCqd&ouMode=DESCENDANTS&program=WSGAb5XwJ3Y>
>> 
>> - ou would be the UID of your top/root organization unit. 
>> - program would be the uid of the program you want to download TEIs for.
>> 
>> You can perhaps create a "external resource" and put this link on a 
>> dashboard for use of your end users.
>> 
>> Let me know if this helps :)
>> 
>> Markus
>> 
>>> 5. jul. 2018 kl. 10:18 skrev Stanley Kalyati >> <mailto:skaly...@gmail.com>>:
>>> 
>>> Hey Markus,
>>> 
>>> This makes alot of sense though.
>>> 
>>> However,my issue is when i want to download the entire list of TEI's into 
>>> an excel or CV for other analysis outside DHIS2,i can not do so.Initially i 
>>> would simply List All and download the list of TEI's.
>>> 
>>> If there is a way i can do that,then thats fine.
>>> 
>>> Thank you
>>> 
>>> Stanley
>>> 
>>> On Thu, Jul 5, 2018 at 9:06 AM Markus Bekken >> <mailto:mar...@dhis2.org>> wrote:
>>> Hey Stanley,
>>> You are right - the "List all" button is no longer there in the reworked UI 
>>> of 2.29. We are actively working on making the Tracker data more secure, 
>>> and the use case for the list all function was perhaps not understood 
>>> properly by us when we designed 2.29. Can you let us know a bit about your 
>>> use case? Will the end user click the button to list all TEIs in the entire 
>>> system and start paging through the list?
>>> 
>>> Best regards,
>>> Markus
>>> 
>>> 
>>>> 4. jul. 2018 kl. 17:25 skrev Stanley Kalyati >>> <mailto:skaly...@gmail.com>>:
>>>> 
>>>> Hi Marta,
>>>> 
>>>> Actually when i select an OU i am able to see the TEI's but to display all 
>>>> TEI's across all OU's like we used to in versions 2.28 below where we 
>>>> could select 'List All' and all TEI's could be displayed,i dont see it in 
>>>> 2.29.
>>>> 
>>>> Any ideas
>>>> 
>>>> On Wed, Jul 4, 2018 at 4:18 PM Marta Vila >>> <mailto:martav...@gmail.com>> wrote:
>>>> Hi Stanley,
>>>> 
>

Re: [Dhis2-devs] [Dhis2-users] HOW TO DOWNLOAD TEI'S FROM 2.29 TRACKER CAPTURE

[Markus Bekken]

Hey again!
Can you send me the full link you are trying, and also the link to the login 
page of your dhis instance?

Markus

> 22. aug. 2018 kl. 08:57 skrev Stanley Kalyati  <mailto:skaly...@gmail.com>>:
> 
> Hi Markus,
> 
> I have tried wgoing directly to the API but i keep getting this error
> What could be the problem.I am using version 2.29
> HTTP Status 404 - /2.29/api/29/trackedEntityInstances/query.csv
> 
> 
> On Thu, Jul 5, 2018 at 9:32 AM Markus Bekken  <mailto:mar...@dhis2.org>> wrote:
> Hey Stanley,
> thanks for the feedback.
> 
> You can go directly to the API and get the CSV:
> https://play.dhis2.org/2.28/api/28/trackedEntityInstances/query.csv?ou=ImspTQPwCqd&ouMode=DESCENDANTS&program=WSGAb5XwJ3Y
>  
> <https://play.dhis2.org/2.28/api/28/trackedEntityInstances/query.csv?ou=ImspTQPwCqd&ouMode=DESCENDANTS&program=WSGAb5XwJ3Y>
> 
> - ou would be the UID of your top/root organization unit. 
> - program would be the uid of the program you want to download TEIs for.
> 
> You can perhaps create a "external resource" and put this link on a dashboard 
> for use of your end users.
> 
> Let me know if this helps :)
> 
> Markus
> 
>> 5. jul. 2018 kl. 10:18 skrev Stanley Kalyati > <mailto:skaly...@gmail.com>>:
>> 
>> Hey Markus,
>> 
>> This makes alot of sense though.
>> 
>> However,my issue is when i want to download the entire list of TEI's into an 
>> excel or CV for other analysis outside DHIS2,i can not do so.Initially i 
>> would simply List All and download the list of TEI's.
>> 
>> If there is a way i can do that,then thats fine.
>> 
>> Thank you
>> 
>> Stanley
>> 
>> On Thu, Jul 5, 2018 at 9:06 AM Markus Bekken > <mailto:mar...@dhis2.org>> wrote:
>> Hey Stanley,
>> You are right - the "List all" button is no longer there in the reworked UI 
>> of 2.29. We are actively working on making the Tracker data more secure, and 
>> the use case for the list all function was perhaps not understood properly 
>> by us when we designed 2.29. Can you let us know a bit about your use case? 
>> Will the end user click the button to list all TEIs in the entire system and 
>> start paging through the list?
>> 
>> Best regards,
>> Markus
>> 
>> 
>>> 4. jul. 2018 kl. 17:25 skrev Stanley Kalyati >> <mailto:skaly...@gmail.com>>:
>>> 
>>> Hi Marta,
>>> 
>>> Actually when i select an OU i am able to see the TEI's but to display all 
>>> TEI's across all OU's like we used to in versions 2.28 below where we could 
>>> select 'List All' and all TEI's could be displayed,i dont see it in 2.29.
>>> 
>>> Any ideas
>>> 
>>> On Wed, Jul 4, 2018 at 4:18 PM Marta Vila >> <mailto:martav...@gmail.com>> wrote:
>>> Hi Stanley,
>>> 
>>> not seeing yout TEI's could be caused by the "Display front page list" 
>>> parameter not being marked. 
>>> It is in the program details step when you create or edit your program.
>>> 
>>> Cheers,
>>> Marta
>>> 
>>> On 4 July 2018 at 16:11, Stanley Kalyati >> <mailto:skaly...@gmail.com>> wrote:
>>> Anyone to assist here?
>>> 
>>> On Fri, Jun 29, 2018 at 11:56 AM Stanley Kalyati >> <mailto:skaly...@gmail.com>> wrote:
>>> With other versions of DHIS2,i would simply click on List All and all TEI 
>>> regardless of OU registered from,they would all appear and i would download 
>>> and review i may.
>>> 
>>> How can i do this in 2.29?
>>> 
>>> Thanks
>>> 
>>> Stanley
>>> 
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs 
>>> <https://launchpad.net/~dhis2-devs>
>>> Post to : dhis2-devs@lists.launchpad.net 
>>> <mailto:dhis2-devs@lists.launchpad.net>
>>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>>> <https://launchpad.net/~dhis2-devs>
>>> More help   : https://help.launchpad.net/ListHelp 
>>> <https://help.launchpad.net/ListHelp>
>>> 
>>> 
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users 
>>> <https://launchpad.net/~dhis2-users>
>>> Post to : dhis2-us...@lists.launchpad.net 
>>> <mailto:dhis2-us...@lists.launchpad.net>
>>> Unsubscribe : https://launchpad.net/~dhis2-users 
>>> <https://launchpad.net/~dhis2-users>
>>> More help   : https://help.launchpad.net/ListHelp 
>>> <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] Program rule Assign

[Markus Bekken]

Hey Riddy - If I follow you correctly, the (1) in your image is assigned by a 
program rule, and works as expected: "(checkmark)Yes" is the way we display a 
Yes/No data element where"Yes" is selected and the mode is read only.

Markus

> 23. jul. 2018 kl. 10:48 skrev riddy ndoma  <mailto:riddynd...@gmail.com>>:
> 
> Hi, Marius I had done this test before I made this email, the display was not 
> always good so much that I did not know the value that will actually be 
> stored.
> The image shows the difference of (1) and (2) 
> 
> ​
> 
> 2018-07-23 9:21 GMT+02:00 Markus Bekken  <mailto:mar...@dhis2.org>>:
> Hey Riddy - program rules use the values true and false for yes/no data 
> elements. Try assigning  true instead of 1.
> 
> The display format indicates that the field is read only. Any assigned field 
> is shown as a read only field by the data entry widget. 
> 
> Markus
> 
> 23. jul. 2018 kl. 05:21 skrev riddy ndoma  <mailto:riddynd...@gmail.com>>:
> 
>> Hello,
>> I would like to tick Yes / No auautomatically after confirming that 4 
>> previous data elements have values that respect a certain range. 
>> My condition is respected and the program rule works but I have a small 
>> concern for the level of value to put in the expression so that "Yes" is 
>> checked in GUI. I put 1 in the expression to assign, the display does not 
>> check "Yes" but it shows me "No" with a funny format (see picture )
>> 
>> ​
>> Cheers,
>> 
>> -- 
>> Riddy NDOMA 
>> Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
>> Twitter: riddyndoma, LinkedIn: riddy ndoma
>> Blog: http://riddyndoma.blogspot.com/ <http://riddyndoma.blogspot.com/>
>> Vous servir est mon désire (Serving you is my desire)
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-us...@lists.launchpad.net 
>> <mailto:dhis2-us...@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp 
>> <https://help.launchpad.net/ListHelp>
> 
> 
> 
> -- 
> Riddy NDOMA 
> Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
> Twitter: riddyndoma, LinkedIn: riddy ndoma
> Blog: http://riddyndoma.blogspot.com/ <http://riddyndoma.blogspot.com/>
> Vous servir est mon désire (Serving you is my desire)

___
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] Program rule Assign

[Markus Bekken]

Hey Riddy - program rules use the values true and false for yes/no data 
elements. Try assigning  true instead of 1.

The display format indicates that the field is read only. Any assigned field is 
shown as a read only field by the data entry widget. 

Markus

> 23. jul. 2018 kl. 05:21 skrev riddy ndoma :
> 
> Hello,
> I would like to tick Yes / No auautomatically after confirming that 4 
> previous data elements have values that respect a certain range. 
> My condition is respected and the program rule works but I have a small 
> concern for the level of value to put in the expression so that "Yes" is 
> checked in GUI. I put 1 in the expression to assign, the display does not 
> check "Yes" but it shows me "No" with a funny format (see picture )
> 
> ​
> Cheers,
> 
> -- 
> Riddy NDOMA 
> Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
> Twitter: riddyndoma, LinkedIn: riddy ndoma
> Blog: http://riddyndoma.blogspot.com/
> Vous servir est mon désire (Serving you is my desire)
> ___
> 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

Re: [Dhis2-devs] Error while adding Relationship in tracker capture v27

[Markus Bekken]

Hey Wasib, please report a Jira bug on this.

Markus

> 17. jul. 2018 kl. 12:38 skrev Wasib Tariq  >:
> 
> Hi All,
> 
> I am trying to add a relationship in tracker capture v27 while saving it 
> throws an error. I've attached the screenshot of the error.
> 
> I've also tried it on (https://play.dhis2.org/2.27/ 
> ).
> 
> Version:
> 2.27
> Build revision:
> 6c1c3ab
> 
> Any help will be appreciated.
> 
> -- 
> Best Regards
>  Wasib
> HISP India
>  screenshot.PNG>___
> 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] HOW TO DOWNLOAD TEI'S FROM 2.29 TRACKER CAPTURE

[Markus Bekken]

Hey Stanley,
thanks for the feedback.

You can go directly to the API and get the CSV:
https://play.dhis2.org/2.28/api/28/trackedEntityInstances/query.csv?ou=ImspTQPwCqd&ouMode=DESCENDANTS&program=WSGAb5XwJ3Y
 
<https://play.dhis2.org/2.28/api/28/trackedEntityInstances/query.csv?ou=ImspTQPwCqd&ouMode=DESCENDANTS&program=WSGAb5XwJ3Y>

- ou would be the UID of your top/root organization unit. 
- program would be the uid of the program you want to download TEIs for.

You can perhaps create a "external resource" and put this link on a dashboard 
for use of your end users.

Let me know if this helps :)

Markus

> 5. jul. 2018 kl. 10:18 skrev Stanley Kalyati :
> 
> Hey Markus,
> 
> This makes alot of sense though.
> 
> However,my issue is when i want to download the entire list of TEI's into an 
> excel or CV for other analysis outside DHIS2,i can not do so.Initially i 
> would simply List All and download the list of TEI's.
> 
> If there is a way i can do that,then thats fine.
> 
> Thank you
> 
> Stanley
> 
> On Thu, Jul 5, 2018 at 9:06 AM Markus Bekken  <mailto:mar...@dhis2.org>> wrote:
> Hey Stanley,
> You are right - the "List all" button is no longer there in the reworked UI 
> of 2.29. We are actively working on making the Tracker data more secure, and 
> the use case for the list all function was perhaps not understood properly by 
> us when we designed 2.29. Can you let us know a bit about your use case? Will 
> the end user click the button to list all TEIs in the entire system and start 
> paging through the list?
> 
> Best regards,
> Markus
> 
> 
>> 4. jul. 2018 kl. 17:25 skrev Stanley Kalyati > <mailto:skaly...@gmail.com>>:
>> 
>> Hi Marta,
>> 
>> Actually when i select an OU i am able to see the TEI's but to display all 
>> TEI's across all OU's like we used to in versions 2.28 below where we could 
>> select 'List All' and all TEI's could be displayed,i dont see it in 2.29.
>> 
>> Any ideas
>> 
>> On Wed, Jul 4, 2018 at 4:18 PM Marta Vila > <mailto:martav...@gmail.com>> wrote:
>> Hi Stanley,
>> 
>> not seeing yout TEI's could be caused by the "Display front page list" 
>> parameter not being marked. 
>> It is in the program details step when you create or edit your program.
>> 
>> Cheers,
>> Marta
>> 
>> On 4 July 2018 at 16:11, Stanley Kalyati > <mailto:skaly...@gmail.com>> wrote:
>> Anyone to assist here?
>> 
>> On Fri, Jun 29, 2018 at 11:56 AM Stanley Kalyati > <mailto:skaly...@gmail.com>> wrote:
>> With other versions of DHIS2,i would simply click on List All and all TEI 
>> regardless of OU registered from,they would all appear and i would download 
>> and review i may.
>> 
>> How can i do this in 2.29?
>> 
>> Thanks
>> 
>> Stanley
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> Post to : dhis2-devs@lists.launchpad.net 
>> <mailto:dhis2-devs@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp 
>> <https://help.launchpad.net/ListHelp>
>> 
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-us...@lists.launchpad.net 
>> <mailto:dhis2-us...@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp 
>> <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] HOW TO DOWNLOAD TEI'S FROM 2.29 TRACKER CAPTURE

[Markus Bekken]

Hey Stanley,
You are right - the "List all" button is no longer there in the reworked UI of 
2.29. We are actively working on making the Tracker data more secure, and the 
use case for the list all function was perhaps not understood properly by us 
when we designed 2.29. Can you let us know a bit about your use case? Will the 
end user click the button to list all TEIs in the entire system and start 
paging through the list?

Best regards,
Markus


> 4. jul. 2018 kl. 17:25 skrev Stanley Kalyati  >:
> 
> Hi Marta,
> 
> Actually when i select an OU i am able to see the TEI's but to display all 
> TEI's across all OU's like we used to in versions 2.28 below where we could 
> select 'List All' and all TEI's could be displayed,i dont see it in 2.29.
> 
> Any ideas
> 
> On Wed, Jul 4, 2018 at 4:18 PM Marta Vila  > wrote:
> Hi Stanley,
> 
> not seeing yout TEI's could be caused by the "Display front page list" 
> parameter not being marked. 
> It is in the program details step when you create or edit your program.
> 
> Cheers,
> Marta
> 
> On 4 July 2018 at 16:11, Stanley Kalyati  > wrote:
> Anyone to assist here?
> 
> On Fri, Jun 29, 2018 at 11:56 AM Stanley Kalyati  > wrote:
> With other versions of DHIS2,i would simply click on List All and all TEI 
> regardless of OU registered from,they would all appear and i would download 
> and review i may.
> 
> How can i do this in 2.29?
> 
> Thanks
> 
> Stanley
> 
> ___
> 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-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

Re: [Dhis2-devs] Retrieving the CODE for organisation units and ASSIGN them to a Tracked Entity Attribute

[Markus Bekken]

Hey Calle,
The variable V{orgunit_code} can be used in a ASSIGN program rule action.

See 21.4.5. Reference information: Functions, variables and operators to
use in program indicator expressions and filters
<https://docs.dhis2.org/master/en/user/html/dhis2_user_manual_en_full.html#program_indicator_functions_variables_operators>
- Table
21.14. Standard variables to use in program rule expressions.

Markus

On Thu, May 24, 2018 at 7:27 PM, Calle Hedberg 
wrote:

> Hi,
>
> Is there a way I can retrieve the organisation unit CODE and ASSIGN it to
> a Tracked Entity Attribute (presumably using a Program Rule)???
>
> Regards
> Calle
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>
> ___
> 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
>
>


-- 
--
Markus Bekken
Software developer
University of Oslo
http://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

Re: [Dhis2-devs] [URGENT] fix for production issue on 2.26

[Markus Bekken]

Hey, Shrikanth! 
We will investigate your issue shortly. Today is a national holiday for most of 
the team. 

Markus

> 17. mai 2018 kl. 07:42 skrev Srikanth Katta :
> 
> Hi Team,
> 
> We have raised the pull request for event capture app regarding the jira ref: 
> https://jira.dhis2.org/browse/DHIS2-2548. Can you please merge that pull 
> request to the 2.26 of event capture app. It's a critical issue on production 
> and we are having a release last week of May.
> 
> Kind Regards,
> 
> Srikanth Katta
> Application Developer
> Email srika...@thoughtworks.com
> Telephone +91-9666837099
> 
> ___
> 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] Tracked entity attributes Yes/No type, the program rule is semi-reactive

[Markus Bekken]

Hey Bridget and Sele - please post a Jira bug for this.

Markus

> 14. mai 2018 kl. 08:53 skrev Bridget Magoba :
> 
> Hi Ally,
> I have also experienced that in version 2.29. Probably we could consider 
> filling a Jira issue.
>  
> From: Dhis2-users 
> [mailto:dhis2-users-bounces+bridgetmagoba=mifumi@lists.launchpad.net] On 
> Behalf Of Seleman Ally
> Sent: Monday, May 14, 2018 9:45 AM
> To: DHIS 2 Users List; DHIS 2 Developers List
> Subject: [Dhis2-users] Tracked entity attributes Yes/No type, the program 
> rule is semi-reactive
>  
> Dear Team,
> 
> I am having a small challenge with Program Rule on latest version 2.29. For 
> the tracked entity attributes Yes/No type, the program rule is semi-reactive. 
> What I mean is, once you select the respective question with command say if 
> != true hide A,B and C tracked entity attributes, it doesn't respond 
> instantly. You may need to click other field of tracked entity attributes 
> before the particular program rule to respond.
> 
> I remember we had similar problem in one of 2.25 revision, I think the 
> Challenge has come back again.
> 
> Best Regards
> 
> Sele
> 
>  
> 
>   Virus-free. www.avast.com
> ___
> 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] Reserving unique Case ID attributes in Tracker - duplicates encountered when reserving via Android

[Markus Bekken]

Hey Calle, 
we haven't really documented how this behaves when you do manual inserts of 
reseved values. Assuming the db insert did the same as a API reservation would 
have done, and that no caching is interfering what hibernate sees - the 100 new 
reserved values should not be among those preexisting in the 
TrackedEntityAttributeReservedValues. 

Markus 

> 19. apr. 2018 kl. 13:26 skrev Calle Hedberg :
> 
> Hi,
> 
> In 2.28. the table "TrackedEntityAttributeReservedValues" is storing unique 
> ID values that have been reserved. When a request is coming from e.g. an 
> Android device running Tracker Capture, the API will trigger the reservation 
> of 100 values and return these to the device while also storing the reserved 
> values in the above table.
> 
> Yesterday, I inserted a list of such reserved values into that table in order 
> to "protect" a section of numbers that will be used for importing legacy 
> data. 
> 
> I then decided to verify that those case IDs WERE now actually reserved.
> 
> 1. 
> when using the normal browser Tracker Capture, it clearly worked - no case 
> IDs coming up were in the reserved range
> 
> 2.
> But when I fired up Android Tracker Capture and logged in afresh, the system 
> did reserve 100 more values BUT a number of those were values already in the 
> TrackedEntityAttributeReservedValues table.
> 
> Or in other words, it seems like a request for reserved values from Tracker 
> Capture via the API will generate reserved values without checking if those 
> values are reserved already - is that correct?
> 
> Regards
> Calle
> 
> -- 
> *** <>
> Calle Hedberg
> 
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
> 
> Tel/fax (home): +27-21-685-6472
> 
> Cell: +27-82-853-5352
> 
> Iridium SatPhone: +8816-315-19119
> 
> Email: calle.hedb...@gmail.com 
> Skype: calle_hedberg
> 
> ***
> 
> 
> ___
> 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] data level sharing and access control in 2.29

[Markus Bekken]

Hi there!
To capture data for a given organization unit in the tree a user will need to 
have access to capture data for the organization or a parent, and you would 
also need Can capture data authority for the program, program stage or data 
set. The new data sharing levels work much the same as the old user role based 
program/dataset access, but provides more fine-grained options for giving 
access only to parts of a program. Hope this answers your question - let us 
know how well the new sharing levels fit your use case!

Markus

> 16. apr. 2018 kl. 13:09 skrev arungatom65 :
> 
> Halo Lars and Team
> Thanks alot for this update hopefully it will enhance access and control 
> rights to information sharing. Will it work within the cascade of hierarchy 
> of orgunits or pegged on the level of user roles?
> Thanks
> 
> 
> 
> Sent from my Samsung Galaxy smartphone.
>  Original message 
> From: Lars Helge Øverland mailto:l...@dhis2.org>> 
> Date: 16/04/2018 11:52 (GMT+03:00)
> To: DHIS 2 Users list  >, DHIS 2 Developers list 
> mailto:dhis2-devs@lists.launchpad.net>> 
> Subject: [Dhis2-users] data level sharing and access control in 2.29
> 
> 
> Hi all,
> 
> in 2.29 we introduced a significant change in the access control solution in 
> DHIS 2.
> 
> In essence, two new levels within the sharing solution were introduced: Can 
> capture data and Can view data. These levels applies to capturing data/events 
> and viewing data/events in analytics, and complements the two existing levels 
> so that we now have:
> 
> Metadata
> --
> 1. Can edit and view metadata
> 2. Can view metadata
> 
> Data/events
> --
> 3. Can capture and view data
> 4. Can view data
> 
> 
> This means that you can now control who can capture data for data sets, 
> programs and program stages through the sharing solution. Previous to 2.29 
> this was done through user roles, where data sets and programs were 
> associated with user roles.
> 
> You can also control who can see data in analytics for programs and category 
> options through the new "can view data" sharing level.
> 
> 
> We have updated the sharing user documentation to reflect this:
> 
> https://docs.dhis2.org/master/en/user/html/sharing.html 
> 
> 
> 
> We have also have some excellent new videos which elaborates on this topic - 
> look for "Data level sharing":
> 
> https://www.dhis2.org/spotlight 
> 
> 
> The motivation behind this change in the access control model is:
> 
> - It provides a single place to control access to DHIS 2 objects. The user 
> role associations to data sets and programs have been removed and replaced by 
> the mentioned sharing levels.
> 
> - It opens for more flexibility in access control. Going forward we plan to 
> introduce more fine-grained data level sharing and include support for 
> entities like data elements and tracked entity attributes.
> 
> - It allows better control over who can view data in analytics, in particular 
> for program and tracker data.
> 
> 
> The 2.29 upgrade script will create a user group per user role and share 
> those groups with the appropriate data sets and programs. You can of course 
> opt not to run this part of the script and instead do the upgrade manually.
> 
> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-229.sql
>  
> 
> 
> 
> best regards,
> 
> Lars
> 
> 
> PS. thanks Nick Dutta for excellent videos.
> 
> 
> -- 
> Lars Helge Øverland
> Technical lead, DHIS 2
> University of Oslo
> l...@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-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] Cohort and referrals

[Markus Bekken]

Hi there Sakibou!
You are correct. When permanently referring a patient, this will update the 
enrolling orgunit of the current enrollment. Each enrollment can only be 
counted in one orgunit, and your enrollment program indicator would now 
consider this enrollment part of facility B. 
There is however some points to mention:
- All events that occurred in facility A will stay there. So any event program 
indicator would evaluate events as part of their orgiginal org unit.
- All previous enrollments will remain unchanged. Only the active enrollment at 
the time of the referral will be updated.

Markus

> 11. apr. 2018 kl. 13:52 skrev Sakibou Alassani :
> 
> Hi
> Please I would like to understand well how referral is managed in DHIS2 
> database management wise. In case of referral the enrollment organisation 
> unit change in the database right?
>  If yes how is cohort going to be managed in the health facility where the 
> patient has been referred from before the transfer.
> For instance if a patient is enrolled in January 2016 in health Facility A. 
> In the calculation of the cohort this patient should be alright counted.
> If in 2017 the patient is referred to Facility B, when testing the program 
> indicators for 2016.This patient is no more counted for facility A. 
> 
> -- 
> 
> Sakibou 
> 
> ___
> 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

Re: [Dhis2-devs] [Dhis2-users] Using age-type attributes in program indicator calculations

[Markus Bekken]

Hey Seleman,
The issue you are referring to here asks for a change in how the Age data type 
functions. I think the behavior you want should already be supported, but with 
the syntax that Nick provided below.

One strength of calculating the age using the d2:yearsBetween() is that you 
would explicitly state the point in time where you want the calculation to be 
based on. If you look at an Age data element in the user interface, the 
calculation is done based on the current date - but this is not always what you 
want when writing program indicators. Nicks example below was calculating based 
on event date for example.

Markus

> 3. apr. 2018 kl. 08:52 skrev Seleman Ally :
> 
> Hi Markus and the team, 
> 
> I think the issue is already created on JIRA since last year. May be we 
> should push for it because this is stopping community from benefiting with 
> this useful feature. The Jira link to the link is
> 
> https://jira.dhis2.org/browse/DHIS2-1309?jql=text%20~%20%22Age%22 
> <https://jira.dhis2.org/browse/DHIS2-1309?jql=text%20~%20%22Age%22>
> 
> Issue Navigator - DHIS 2 JIRA 
> <https://jira.dhis2.org/browse/DHIS2-1309?jql=text%20~%20%22Age%22>
> 
> 
> Issue Navigator - DHIS 2 JIRA
>  <https://jira.dhis2.org/browse/DHIS2-1309?jql=text%20~%20%22Age%22>
> 
> 
> Regards
> 
> Sele
> On Tuesday, April 3, 2018, 9:30:31 AM GMT+3, Markus Bekken  
> wrote:
> 
> 
> Nayeem, thanks for the workaround.
> 
> Nick, the proposed usage should have worked. Age should be treated as a 
> normal date data type in the program indicators. Can you create a bug in jira?
> 
> Markus
> 
>> 3. apr. 2018 kl. 03:41 skrev Nayeem Al Mifthah > <mailto:n.mift...@gmail.com>>:
>> 
>> Hi Nick
>> I have also notice the same problem. Later created a data element in program 
>> stage and assign age in year as a calculative value from program attribute 
>> 'age'.
>> 
>> It works! 
>> 
>> Regards,
>> Nayeem Al Mifthah
>> Consultant for HSS, HMIS, M&E, GIS and Surveillance
>> 
>> Kindly ignore typos.
>> 
>> On Mon, 2 Apr 2018, 23:07 Shurajit Dutta, > <mailto:shurajitdu...@gmail.com>> wrote:
>> Hi
>> 
>> I am trying to figure out the best method to use age-type attributes in 
>> program indicator calculations. As a simple example, let us say I want a 
>> program indicator which displays the age in years of a person. From what I 
>> can see, the age-type attribute stores its value as a date, according to the 
>> date of birth either selected or estimated based on what is entered in the 
>> years, weeks and months fields respectively during registration. If I want 
>> to use this date in a program indicator however it seems to not work 
>> correctly.
>> 
>> ie d2:yearsBetween(age, event_date) when used as an expressions as an 
>> example would not give me the correct age in years. Is there another way in 
>> which to make these types of program indicators work with the age-type 
>> attribute?
>> 
>> Thanks,
>> Nick
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-us...@lists.launchpad.net 
>> <mailto:dhis2-us...@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp 
>> <https://help.launchpad.net/ListHelp>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-us...@lists.launchpad.net 
>> <mailto:dhis2-us...@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp 
>> <https://help.launchpad.net/ListHelp>
> 
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> Post to: dhis2-us...@lists.launchpad.net 
> <mailto:dhis2-us...@lists.launchpad.net>
> Unsubscribe : https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> More help  : https://help.launchpad.net/ListHelp 
> <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] how about the performance for dhis2 tracker to manage large number of entity data?

[Markus Bekken]

Hi Lin!
There is a few tracker implementations in this size range. These numbers of 
tracked entity instances should not be a problem in itself, but requires a 
well-maintained database and application server.

Generally, newer versions of DHIS2 will perform stronger than older versions. 
In 2.30 and upcoming releases we are maintaining tracker performance as a top 
priority.

Best regards,
Markus

> 19. mar. 2018 kl. 01:55 skrev 林晓东 :
> 
> Hi,all,
> 
>Is there some info or infer on performance for DHIS2 managing more than 
> 10,000,000 entity  tracker data?
> 
>Thanks.
> 
> 
> --
> 此致
> 
>林晓东
> 
> 莫愁前路无知己，天下谁人不识君。
> 
> 
>  
> ___
> 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] ACCESS TO DATA FROM MULTIPLE STAGES IN EVENT REPORTS

[Markus Bekken]

Hi Stanley,
this is currently not possible. It is however something that is being 
requested, and we have created these epics to capture the functional area: 
- https://jira.dhis2.org/browse/DHIS2-3140
- https://jira.dhis2.org/browse/DHIS2-2106

Can you please have a look at the epics and possibly add more about your use 
case in the comments?

Markus

> 10. mar. 2018 kl. 10:10 skrev Stanley Kalyati :
> 
> Has anyone got experience with running an event report that merges data from 
> multiple stages? For example connecting the unique identifier to HIV Test 
> results and then ART Initiation Status? Three different sources of data.
> 
> Your assistance is appreciated always
> 
> Stanley
> 
> ___
> 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] 2.29 upgrade script error

[Markus Bekken]

Dear Bernard,
You are absolutely right. The program_userroles table is the correct one, and 
the userroleprogram table is a legacy table not used anymore. We just fixed the 
script, please try again with the latest version.

Best regards,
Markus

> 9. mar. 2018 kl. 14:21 skrev Bernard Sadaka (IM Advisor) :
> 
> Dear Markus,
> After a closer look, I found this table:
> public | program_userroles | table | dhis
> Is it the same?
>  
> 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 <mailto:lib@pu-ami.org>
> Cell: +961 71 004 881 (208)
> Skype: imapuami
> Website: https://www.pu-ami.org <https://www.pu-ami.org/>
>  
>  
> From: Dhis2-users 
> [mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net 
> <mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net>] On 
> Behalf Of Bernard Sadaka (IM Advisor)
> Sent: Friday, March 9, 2018 3:17 PM
> To: 'Markus Bekken' mailto:mar...@dhis2.org>>
> Cc: dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@lists.launchpad.net>; 
> 'DHIS 2 Developers list'  <mailto:dhis2-devs@lists.launchpad.net>>
> Subject: Re: [Dhis2-users] [Dhis2-devs] 2.29 upgrade script error
>  
> Hello Markus,
> Unfortunately I don’t have that table:
> dhisdb=# \dt userrole*
>  List of relations
> Schema |   Name| Type  | Owner
> +---+---+---
> public | userrole  | table | dhis
> public | userroleauthorities   | table | dhis
> public | userroledataset   | table | dhis
> public | userrolemembers   | table | dhis
> public | userroletranslations  | table | dhis
> public | userroleuseraccesses  | table | dhis
> public | userroleusergroupaccesses | table | dhis
> (7 rows)
> Is there any maintenance scripts I need to run in order to create that table?
>  
> 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 <mailto:lib@pu-ami.org>
> Cell: +961 71 004 881 (208)
> Skype: imapuami
> Website: https://www.pu-ami.org <https://www.pu-ami.org/>
>  
>  
> From: Markus Bekken [mailto:mar...@dhis2.org <mailto:mar...@dhis2.org>] 
> Sent: Friday, March 9, 2018 2:32 PM
> To: Bernard Sadaka (IM Advisor)  <mailto:lib@pu-ami.org>>
> Cc: dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@lists.launchpad.net>; 
> DHIS 2 Developers list  <mailto:dhis2-devs@lists.launchpad.net>>
> Subject: Re: [Dhis2-devs] 2.29 upgrade script error
>  
> Hi there Bernard,
> that was strange - your 2.28 database should have contained the table 
> userroleprogram.
> Assuming you are running 2.28, can you try running this query on your command 
> line?
> \dt userrole*
> Expecting that one of the lines output is:
> public | userroleprogram   | table | dhis
>  
> 
> Best regards,
> Markus
>  
> 
>> 9. mar. 2018 kl. 10:04 skrev Bernard Sadaka (IM Advisor) > <mailto:lib@pu-ami.org>>:
>>  
>> Dear All,
>> I am trying to migrate from 2.28 (aff610f) to 2.29, by first running the 
>> upgrade script and then updating the .war file.
>> However I am stuck at the upgrade script with this error:
>> 
>> Please advise.
>>  
>> 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 <mailto:lib@pu-ami.org>
>> Cell: +961 71 004 881 (208)
>> Skype: imapuami
>> Website: https://www.pu-ami.org <https://www.pu-ami.org/>
>>  
>>  
>>  
>>  
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon>
>>
>> Virus-free. www.avast.com 
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> Post to : dhis2-devs@lists.launchpad.net 
>> <mailto:dhis2-devs@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp 
>> <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] 2.29 upgrade script error

[Markus Bekken]

Hi Dan!
You are are absolutely right. The script currently triggers a migration of data 
into the programstageusergroupaccesses before this table is created.

To get around the problem right away you need to run the script except for the 
last line, then start the server, and run the last line of the script to do the 
migration:
select migrateRoleToUserGroup();

Looking at a better fix now - to migrate as part of the server startup.

Markus

P.S. This does not look like the same problem that Bernard had for some reason 
- but expecting that Bernard need to do the same workaround.

> 9. mar. 2018 kl. 13:39 skrev Dan Cocos :
> 
> We’ve run into a similar problem when testing from 2.28 to 2.29
> 
> psql:/tmp/229-upgrade.sql:117: ERROR:  relation 
> "programstageusergroupaccesses" does not exist
> LINE 1: insert into programstageusergroupaccesses ( programid, userg…
> 
> When looked deeper into it, that table did not exist. Is it possible these 
> tables don’t exist or weren’t migrated from a previous upgrade if one isn’t 
> using Tracker? 
> 
> Thanks,
> Dan
> 
> Dan Cocos
> Principal, BAO Systems
> dco...@baosystems.com <mailto:dco...@baosystems.com> | 
> http://www.baosystems.com <http://www.baosystems.com/> |  2900 K Street, 
> Suite 406, Washington D.C. 20007
> 
>> On Mar 9, 2018, at 7:31 AM, Markus Bekken > <mailto:mar...@dhis2.org>> wrote:
>> 
>> Hi there Bernard,
>> that was strange - your 2.28 database should have contained the table 
>> userroleprogram.
>> Assuming you are running 2.28, can you try running this query on your 
>> command line?
>> \dt userrole*
>> Expecting that one of the lines output is:
>> public | userroleprogram   | table | dhis
>> 
>> Best regards,
>> Markus
>> 
>>> 9. mar. 2018 kl. 10:04 skrev Bernard Sadaka (IM Advisor) 
>>> mailto:lib@pu-ami.org>>:
>>> 
>>> Dear All,
>>> I am trying to migrate from 2.28 (aff610f) to 2.29, by first running the 
>>> upgrade script and then updating the .war file.
>>> However I am stuck at the upgrade script with this error:
>>> 
>>> Please advise.
>>>  
>>> 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 <mailto:lib@pu-ami.org>
>>> Cell: +961 71 004 881 (208)
>>> Skype: imapuami
>>> Website: https://www.pu-ami.org <https://www.pu-ami.org/>
>>>  
>>>  
>>> 
>>>  
>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon>
>>> Virus-free. www.avast.com 
>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link>
>>>  
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs 
>>> <https://launchpad.net/~dhis2-devs>
>>> Post to : dhis2-devs@lists.launchpad.net 
>>> <mailto:dhis2-devs@lists.launchpad.net>
>>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>>> <https://launchpad.net/~dhis2-devs>
>>> More help   : https://help.launchpad.net/ListHelp 
>>> <https://help.launchpad.net/ListHelp>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> Post to : dhis2-devs@lists.launchpad.net 
>> <mailto:dhis2-devs@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp 
>> <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] 2.29 upgrade script error

[Markus Bekken]

Hi there Bernard,
that was strange - your 2.28 database should have contained the table 
userroleprogram.
Assuming you are running 2.28, can you try running this query on your command 
line?
\dt userrole*
Expecting that one of the lines output is:
public | userroleprogram   | table | dhis

Best regards,
Markus

> 9. mar. 2018 kl. 10:04 skrev Bernard Sadaka (IM Advisor) :
> 
> Dear All,
> I am trying to migrate from 2.28 (aff610f) to 2.29, by first running the 
> upgrade script and then updating the .war file.
> However I am stuck at the upgrade script with this error:
> 
> Please advise.
>  
> 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.pu-ami.org 
>  
>  
> 
>  
> 
>   Virus-free. www.avast.com 
> 
>  
> ___
> 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] Event - report : Range set for program indicator 2.28

[Markus Bekken]

Hi Hakim!
Legends is not available in the event reports for program indicators at the 
moment. Please consider creating a Jira issue asking for this functionality.

Best
Markus

> 8. mar. 2018 kl. 08:56 skrev DJIBRIL Hakim :
> 
> Hi all, 
> Please Does Range set is applicable to program indicator when doing event 
> report on version 2.28. Like range set on Age get program indicator base on 
> date of birth ( tracked instance attribute) and current date ?
> Best
> ___
> 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

Re: [Dhis2-devs] [Dhis2-users] how to refer patient from one site to another in DHIS2 tracker

[Markus Bekken]

Hi there Hakim,
There is currently no way of doing analytics on the referral itself. To achieve 
this in the current solution you would have to capture some data relevant to 
the transfer. One strategy can be to have a separate "Transfer" program stage 
that is used for the purpose of moving a patient from one clinic to another. If 
extra data elements or program stages will not work well with your use case, 
please put the details into a Jira issue.

Markus

> 2. mar. 2018 kl. 11:27 skrev DJIBRIL Hakim :
> 
> Hi all, Any updates/helps on this !!!?
> 
> 2018-02-28 16:01 GMT+00:00 DJIBRIL Hakim  >:
> Thank you Lukas for your answer and bernard for your comments, 
> also a question how get list of patients referrals out and referrals in. I 
> want to know Please if there is a way from frontend or api to calculate 
> indicators based on this referral option.
> 
> 2018-02-28 15:43 GMT+00:00 Bernard Sadaka (IM Advisor)  >:
> Hello Lukas, Hakim and All,
> 
> Allow me to jump in here and ask a related question.
> 
> To be honest I opted out of the referral mechanism because of the bellow bug, 
> but if it works it would be an excellent asset.
> 
>  
> 
> After temporarily or permanently referring a patient from one Org Unit to the 
> other, DHIS2 asks to enroll the patient in the new PHCC and when trying to 
> enroll, I get this error:
> 
> TrackedEntityInstance HrmJMxnoYzE already have an active enrollment in 
> program kel6D4tu0vC
> 
> 
> 
> The error above is only received by a user that has access only to the new 
> OrgUnit and doesn’t have access to the old OrgUnit. And therefore the user of 
> the new OrgUnit who doesn’t have access to the old OrgUnit can not see the 
> enrollment of the patient neither can re-enroll because of the above error.
> 
> In case the user has access to both OrgUnits the above error does not happen.
> 
>  
> 
> So my guess is that the problem is with the user rights concerning the 
> referred patient when the user doesn’t have access rights to the old OrgUnit. 
> The error is also persistent for that user even after browser cache cleaning, 
> logout and even with cookies cleaning/incognito browsing.
> 
>  
> 
> I couldn’t see the above reported in JIRA (only the original feature was done 
> in https://jira.dhis2.org/browse/DHIS2-678 
> 
> Maybe this is a new bug? If so I can create a JIRA entry.
> 
>  
> 
> Let me know.
> 
>  
> 
> 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.pu-ami.org 
>  
> 
>  
> 
> From: Dhis2-users [mailto:dhis2-users-bounces+lib.ima 
> =pu-ami@lists.launchpad.net 
> ] On Behalf Of Lukas Wijgaart-van Dijk
> Sent: Wednesday, February 28, 2018 4:50 PM
> To: DJIBRIL Hakim mailto:djib.ha...@gmail.com>>
> Cc: DHIS 2 Users list  >; DHIS 2 Developers list 
> mailto:dhis2-devs@lists.launchpad.net>>
> Subject: Re: [Dhis2-users] [Dhis2-devs] how to refer patient from one site to 
> another in DHIS2 tracker
> 
>  
> 
> Hi Hakim,
> 
> To refer a patient click the button highlighted in the image. Then in the 
> pop-up select «Program stage», «OrgUnit» and "Report date».
> 
> After that you select if the patient should be referred once (only that 
> event/program stage) or permanently.
> 
> 
> 
>  
> 
> Best regards,
> 
> Lukas Wijgaart van Dijk
> 
>  
> 
> 28. feb. 2018 kl. 15.04 skrev DJIBRIL Hakim  >:
> 
>  
> 
> Hello all,
> 
> I am searching a documentation on how refer patient from one site to another 
> in DHIS2 tracker but not found it.
> 
> Please Can someone explain how doing that?
> 
> ___
> 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 
> 
>  
> 
> 
>  
> 
>   Virus-free. www.avast.com 
> 
>  
> 
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https

Re: [Dhis2-devs] Data Entry Error about Category Combination

[Markus Bekken]

Hey there,
did you backup and restore the entire database, or did you do a metadata export 
and import? If you exported and imported, how did you do the export?

Markus

> 26. feb. 2018 kl. 17:04 skrev gerald thomas :
> 
> Dear All,
> i did a backup and i restored the database to another instance but i am 
> receiving an error about Category combination identifier missing when i am 
> trying to do data entry. It is working on the instance that i get the backup 
> from.
> Please find the attached error. 
> 
> -- 
> Regards,
>  
> Gerald
>  14-20-22.png>___
> 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] ProgramIndicators questions

[Markus Bekken]

Hey Martin!
- You can make composite indicators that consists of other program indicators, 
but program indicators can not be nested within each other directly.
- Yes-  program indicator values are always based on the data in the 
analytics_* tables.

Markus

> 21. feb. 2018 kl. 11:03 skrev Martin Van Aken :
> 
> Hi DHIS2 dev team!
> 
> I'm working on a decently large tracker program, and got some questions 
> regarding ProgramIndicators:
> 
> - It looks like ProgramIndicator can only refer to DataElements, not other 
> ProgramIndicators (like "aggregate" Indicators can) - is there any specific 
> reason for this? Will this constraint be left at some point in the future? 
> Building indicators on top of other indicators is quite handy
> - Are the programIndicator results linked to running the analytics (when 
> viewing them in the Event Manager app)? I tried to test that one, but was not 
> totally sure of my results (as the pivot table & browser are doing a lot of 
> caching too)
> 
> Thanks!
> 
> Martin
> 
> -- 
> Martin Van Aken - Freelance Enthusiast Developer
> 
> Mobile : +32 486 899 652 <> 
> 
> Follow me on Twitter : @martinvanaken 
> Call me on Skype : vanakenm
> Hang out with me : mar...@joyouscoding.com 
> Contact me on LinkedIn : http://www.linkedin.com/in/martinvanaken 
> 
> Company website : www.joyouscoding.com 
> ___
> 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] HOW TO CREATE PROGRAM INDICATOR IN DHIS2 2.27 TO 2.28

[Markus Bekken]

Hi there Stanley,
the program indicators is now located in the maintenance app. The program 
indicator section of the maintenance app contains the same fields as the old 
app did, but the fields are spread out on three pages that is navigated like a 
wizard.

Markus

> 20. feb. 2018 kl. 17:31 skrev Stanley Kalyati :
> 
> Dear All,
> 
> Initially i was using dhis2 2.26 build revision  aaae441 and when creating a 
> program indicator,thats the page i would come and i would easily do it.Now in 
> 2.27 version,everything seems different.Anyone with any documentation please 
> share or advise.This is urgent.
> 
> 
> ___
> 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

Re: [Dhis2-devs] Program Indicator using data from multiple event stages to find TEA

[Markus Bekken]

Hi Martin,
to my knowledge the parenthesis work in general, with the exception of passing 
parenthesis into the d2:condition() function: DHIS2-2813 


You would be able to write parenthesis in program indicators expressions and 
filters. What is not supported is nested d2: function calls. 

Please report if you experience problems with parenthesis outside the known 
issue above.

Markus

> 14. feb. 2018 kl. 08:30 skrev Martin Van Aken :
> 
> Hi everyone.
> 
> Thanks Lars for the answer - we face problems with priorities (hence needing 
> parenthesis) there too. Glad to know this will be solved, but what would be 
> the possible workarounds in the meantime? I wanted to decompose in different 
> indicators, but programIndicators can't use other programIndicators (like the 
> "aggregate" indicators does), correct? Any other way we would apply our 
> proper priorities ?
> 
> Thanks,
> 
> Martin
> 
> On Wed, Feb 14, 2018 at 8:18 AM, Lars Helge Øverland  > wrote:
> HI Aaron,
> 
> that sounds good, glad to hear you got cross-stage calculations to work.
> 
> Unfortunately program indicator expressions do not support nested 
> parentheses/functions - we plan to develop a new version of our program 
> indicator parser which will be more flexible in this regard.
> 
> regards,
> 
> Lars
>  
> 
> On 13 February 2018 at 20:56, Aaron C White  > wrote:
> Thanks, Lars and Preeti.  I checked the indicator formulation and found a 
> problem with a d2:condition() statement using a text option set value.  I 
> converted it to an integer and was able to see the calculated data across 
> stages.  I think it might be related to the parentheses issue inside the 
> condition as a few other recent emails have suggested.  How should the 
> condition be formulated if you also need to check a text option inside that 
> condition?  Using double quotes on the outside of the formulation does not 
> seem to work properly.  i.e. d2:condition("my_de == '3'", true, false)
> 
> Aaron
> 
> 
> --
> Aaron C. White
> 919.522.5585 
> On Mon, Feb 12, 2018 at 1:34 AM, Lars Helge Øverland  > wrote:
> Hi Aaron,
> 
> from your description I think enrollment type program indicators will be 
> appropriate. Can you tell us a bit more about your usecase? I am assuming you 
> want information from two different stages in the same program. Do you have 
> multiple enrollments per person (TEI) in your program? If not I think 
> enrollment indicators will do the job.
> 
> regards,
> 
> Lars
> 
> 
> On 8 February 2018 at 21:49, Aaron C White  > wrote:
> Hi all,
> 
> I'm trying to create a program indicator (or just query to the API directly) 
> that evaluates conditions on data elements from two different event stages 
> and then be used to find a relevant tracked entity attribute.  
> 
> From the docs, it seems that a program indicator type of enrollment would be 
> most appropriate, but this only works at the aggregate level and not at an 
> individual tracked entity instance level.  When I use an event type 
> indicator, I don't receive any values back because the indicator definition 
> contains data from two stages.  
> 
> Am I correct in this assessment?  Any thoughts on how to get around this?
> 
> I've been testing on a v2.28 instance.  A similar reference example from the 
> demo server would be the "Weight gain(in g) between birth and last postnatal 
> for Child Programme" program indicator.  The one change would be that I want 
> to see the weight gain for individual TEIs and view a TEA based on the weight 
> gain amount instead of the average over all tracked entity instances. 
> 
> Thanks in advance,
> 
> Aaron
> 
> --
> Aaron C. White
> 919.522.5585 
> ___
> 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 
> 
> 
> 
> 
> 
> -- 
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org 
> http://www.dhis2.org 
> 
> 
> 
> 
> 
> -- 
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org 
> http://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.launc

Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in Program indicator expressions

[Markus Bekken]

Hi again Bernard,
it seems that the problem you experience might be caused by the presence of 
parenthesis in the expression inside your d2:condition. This is a bug, and can 
be followed up here: https://jira.dhis2.org/browse/DHIS2-2813 
<https://jira.dhis2.org/browse/DHIS2-2813>
If you are able to write your expression without parenthesis, this is a 
workaround that you can use.

The general implementation of new functions in program indicators is followed 
up in jira issues, but there was none covering the mathematical functions you 
need here, so I created one that you can look at: 
https://jira.dhis2.org/browse/DHIS2-2814 
<https://jira.dhis2.org/browse/DHIS2-2814>
Please complement or comment, and consider voting for it :)

Best regards,
Markus

P.S. won't X*100%100 always be 0? 

> 7. feb. 2018 kl. 09:21 skrev Bernard Sadaka (IM Advisor) :
> 
> Hello Markus,
> Thank you for the list and explanation; is there any expected timeline for 
> that? (JIRA issue, I can track?)
>  
> With regards to the number of decimals, even if set to zero at the program 
> indicator and after running the analytics, the “pivot table” still shows the 
> digits.
>  
> Regarding the expression, yes it is true, I’m rounding the constants, because 
> I am actually creating a budget report and applying a discount rate on the 
> individual cost of a specific PHCC activity and aggregating them using sum 
> (so I am using one constant per cost of a PHCC activity and another for 
> discount rate of all activities). I ended up using exact values in the 
> constant instead of a discounted factor; after all, changing a discount 
> factor is easier than changing 200 values individually when the discount rate 
> changes. The reason for all this, is that with a discounted factor there is a 
> need to round the values and disallow them to be cumulated in the sum of the 
> aggregation in order to keep the report error free.
> Hope the above explains my usecase: aggregating the data elements of a TEI 
> and multiplying them by a cost constant and a discount factor. And yes the 
> round functions in this case would be very beneficial.
>  
> Thank you again for your support.
>  
> 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 <mailto:lib@pu-ami.org>
> Cell: +961 71 004 881 (208)
> Skype: imapuami
> Website: https://www.pu-ami.org <https://www.pu-ami.org/>
>  
>  
> From: Markus Bekken [mailto:mar...@dhis2.org] 
> Sent: Wednesday, February 7, 2018 9:52 AM
> To: Bernard Sadaka (IM Advisor) 
> Cc: dhis2-us...@lists.launchpad.net; DHIS 2 developers 
> 
> Subject: Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in 
> Program indicator expressions
>  
> Hi there Bernard,
> We aim to support more and hopefully all the program rule functions in 
> program indicators.
> Unfortunately we are not there yet, and the list of supported functions in 
> program indicators can be found here:
> 19.4.5. Reference information: Functions, variables and operators to use in 
> program indicator expressions and filters 
> <https://docs.dhis2.org/master/en/user/html/dhis2_user_manual_en_full.html#program_indicator_functions_variables_operators>
>  
> Where did you get the wrong number of decimals? In the Pivot or in the 
> Tracker/Event capture?
>  
> One question on your expression below, it seems you are trying to round off a 
> constant from your defined constant values? Your use case I would have 
> guessed is to round off a data element or tracked entity attribute value?
>  
> Best regards
> Markus
> 
> 
>> 6. feb. 2018 kl. 15:31 skrev Bernard Sadaka (IM Advisor) > <mailto:lib@pu-ami.org>>:
>>  
>> I found a similar issue on JIRA (https://jira.dhis2.org/browse/DHIS2-2734 
>> <https://jira.dhis2.org/browse/DHIS2-2734>)
>>  
>> But still doesn’t explain why I can’t use different expressions in program 
>> indicators L
>>  
>> 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 <mailto:lib@pu-ami.org>
>> Cell: +961 71 004 881 (208)
>> Skype: imapuami
>> Website: https://www.pu-ami.org <https://www.pu-ami.org/>
>>  
>>  
>> From: Dhis2-users 
>> [mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net 
>> <

Re: [Dhis2-devs] [Dhis2-users] Using program rule expressions in Program indicator expressions

[Markus Bekken]

Hi there Bernard,
We aim to support more and hopefully all the program rule functions in program 
indicators.
Unfortunately we are not there yet, and the list of supported functions in 
program indicators can be found here:
19.4.5. Reference information: Functions, variables and operators to use in 
program indicator expressions and filters 


Where did you get the wrong number of decimals? In the Pivot or in the 
Tracker/Event capture?

One question on your expression below, it seems you are trying to round off a 
constant from your defined constant values? Your use case I would have guessed 
is to round off a data element or tracked entity attribute value?

Best regards
Markus

> 6. feb. 2018 kl. 15:31 skrev Bernard Sadaka (IM Advisor) :
> 
> I found a similar issue on JIRA (https://jira.dhis2.org/browse/DHIS2-2734 
> )
>  
> But still doesn’t explain why I can’t use different expressions in program 
> indicators L
>  
> 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.pu-ami.org 
>  
>  
> From: Dhis2-users 
> [mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net 
> ] On 
> Behalf Of Bernard Sadaka (IM Advisor)
> Sent: Tuesday, February 6, 2018 3:53 PM
> To: dhis2-us...@lists.launchpad.net ; 
> 'DHIS 2 developers'  >
> Subject: [Dhis2-users] Using program rule expressions in Program indicator 
> expressions
>  
> Can anyone tell me why I can’t use program rule expressions in Program 
> indicator expressions?
> Functions like ceil, floor, round and others are very useful.
>  
> Also I tried to use the “Decimals in data output” in the program indicator 
> details, it didn’t work.
> Also I tried to simulate the round function using conditional modulo 
> subtraction/addition (the pivot table keeps trying to load) :
> C{eB6eQXKY8HA}*C{xGZ2I9aTeXX} -(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 + 
> d2:condition('(C{eB6eQXKY8HA}*C{xGZ2I9aTeXX}*100) % 100 >=50',1,0)
>  
> Thank you in advance.
> Please advise.
>  
> 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.pu-ami.org 
>  
>  
>  
>  
> 
> 
> Virus-free. www.avast.com 
> 
>  
> ___
> 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] Program rules - comparing report date for multiple stages/events

[Markus Bekken]

Hi Olav!
There is currently no way of getting the last event date of a program stage 
directly, but there is a function that might help you.

d2:lastEventDate('variableName') - will give you the event date when the 
underlying data element was entered. Based on how your program stages and data 
elements is structured you might use this function.

Another option that might solve your problem in a simpler way is to use program 
rule variables with the "Data element from previous event". But again - only if 
you have a data element that you can use for validation in the previous events.

You are also most welcome to make a jira issue requesting a function that does 
not rely on the data elements :)

Markus

> 18. jan. 2018 kl. 15.31 skrev Olav Poppe :
> 
> Hi devs, is it possible to compare event dates from different program stages?
> 
> We have some stages that should happen chronologically (treatment start stage 
> should be before treatment outcome stage), and I’d like to ideally have a 
> hard rule preventing this, and if that’s not possible, to at least be able to 
> show a message/warning
> 
> Regards
> Olav
> ___
> 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] Program rule to hide Tracked entity attribute field show a warning in console

[Markus Bekken]

Hi there Rady,
Nicely spotted. Which version of DHIS are you running? This message is noise 
from a runtime validation that is a bit too strict, and can be disregarded for 
the purposes of the users. Log noise is still important to clean up, so it 
would be great if you can submit a Jira with the details.

Regards
Markus

> 12. okt. 2017 kl. 07.24 skrev Rady :
> 
> Dear DHIS2 team,
> 
> I have tried using Program rule to hide Tracked entity attribute field, it 
> works properly. But it shows a warning message "ProgramRuleAction C1pSVKWZ40F 
> is of type HIDEFIELD, bot does not have a dataelement defined" in console 
> (see attached files). However, if I tried the same program rule to hide data 
> element field, it does not show such warning message in console. Does anyone 
> have experience with this?
> 
> Regards,
> Rady
> ___
> 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] Save TEI Dashboard as Default not working

[Markus Bekken]

Hey!
Only users that does not have their own dashboard saved will see the default 
layout. Most changes a user does to her own dashboard will cause such a 
user-specific dashboard to be saved. 

We have created a Jira that will mitigate this problem by allowing the 
administrator to override the user configured dashboards:
DHIS2-687 

Markus

> 14. sep. 2017 kl. 12.31 skrev Immaculate Ayebazibwe :
> 
> Hi All,
> Perhaps am missing something but it seems, the Save Dashboard as default (see 
> image) does not work.
> I have arranged the widgets in a particular way, but still users see 
> something different. Is there a userrole to be assigned or can I stop every 
> one from changing this.
> 
> ​
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> ___
> 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] Disabling Complete for Some Users

[Markus Bekken]

Hi!
The complete enrollment button is disabled if:
- The orgunit is closed
- The current tracked entity instance is inactive
- The current enrollment is active

The only thing that will hide the complete enrollment button is if the current 
enrollment has status cancelled.

Markus

> 14. sep. 2017 kl. 12.25 skrev Immaculate Ayebazibwe :
> 
> Hi All,
> Is there a specific role disabling the complete button (see image) in the 
> enrollment widget for some users?
> ​
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> ___
> 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] Switch enrolling organisation unit

[Markus Bekken]

Hi there Barnabas,
the feature was relatively recently added to 2.27. You possibly need update 
your instance to the latest if your 2.27 war file is more than one month old.

Markus

> 29. aug. 2017 kl. 13.21 skrev Barnabas Akumba :
> 
> Hello Markus,
> 
> I've been trying to use the referral feature on 2.27 but it seems not to be 
> there See attached Screen Shot.
> Is there any setting I need to enable to make it available?
> 
> Your usual prompt response'll be appreciated.
> 
> Regards
> 
> On Mon, Aug 28, 2017 at 1:09 PM, Markus Bekken  <mailto:mar...@dhis2.org>> wrote:
> Hi :)
> Assuming this is on 2.27 - you could open these records in Tracker Capture 
> and use the "Referral" functionality. The button for referral is located 
> below the schedule event button. Select the correct organization unit to move 
> the enrollment to, and select "Move permanently" in the referral dialog.
> 
> Markus
> 
>> 28. aug. 2017 kl. 14.00 skrev Georgi Chakarov > <mailto:geo...@logicaloutcomes.net>>:
>> 
>> Hello!
>>  
>> Is there a quick way to switch enrolling organization units in tracker?
>> We have a handful of enrollments at the wrong level, containing a lot of 
>> data, so I was wondering how to switch to the correct level.
>>  
>> Thanks,
>>  
>> Georgi
>>  
>>   
>> Georgi Chakarov, CIA | geo...@logicaloutcomes.net 
>> <mailto:geo...@logicaloutcomes.net> | +1-647-478-5634 x 104 
>>  | LogicalOutcomes c/o Centre for Social Innovation, 
>> 720 Bathurst Street, Toronto Canada M5S 2R4 | You may unsubscribe from 
>> receiving commercial electronic messages from LogicalOutcomes by emailing 
>> i...@logicaloutcomes.net <mailto:i...@logicaloutcomes.net>
>>  
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-us...@lists.launchpad.net 
>> <mailto:dhis2-us...@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp 
>> <https://help.launchpad.net/ListHelp>
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-devs 
> <https://launchpad.net/~dhis2-devs>
> Post to : dhis2-devs@lists.launchpad.net 
> <mailto:dhis2-devs@lists.launchpad.net>
> Unsubscribe : https://launchpad.net/~dhis2-devs 
> <https://launchpad.net/~dhis2-devs>
> More help   : https://help.launchpad.net/ListHelp 
> <https://help.launchpad.net/ListHelp>
> 
> 
> 
> 
> -- 
>  
> Barnabas AKUMBA
> 
> Mobile: +2348036195778
> Skype: barnabas.akumba
> 

___
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] Showing Identifiers in Relationship box

[Markus Bekken]

The tracked entity attributes would also have to be part of the program that 
the relationship links to. If they are part of the program and also has the 
"display in list without program" checked they should be in the relationship 
table. There should not be a limit.

Assuming the attributes in fact was in the program, and the cache was cleared - 
can you privately give me access to your instance for analysis?

Markus

> 28. aug. 2017 kl. 16.11 skrev Immaculate Ayebazibwe :
> 
> Hi Markus,
> Does this have a limit?
> I have checked like three attributes to display without program but I can 
> only see one.
> 
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> 
> On Mon, Aug 28, 2017 at 12:06 PM, Markus Bekken  <mailto:markus.bek...@gmail.com>> wrote:
> Sorry, I misunderstood your original question.
> 
> To display an attribute in the relationship table, you have to open the 
> tracked entity attribute and select the "display in list without program" 
> option. 
> 
> Markus
> 
>> 27. aug. 2017 kl. 08.48 skrev Immaculate Ayebazibwe > <mailto:ekass...@gmail.com>>:
>> 
>> Hi Everyone,
>> I am working with relationships from program A to B in tracker capture.
>> I want to be able to show some identifiers details from B after I have 
>> created a relationship in A while this is possible in demo, I am not sure 
>> how to accomplish the same on my instance. 
>> Above in my instance
>> 
>> Demo instance
>> ​
>> Would someone please let me help me accomplish the effect of demo instance.
>> I am running 
>> Version:
>> 2.27
>> Build revision:
>> 0303f0d
>> Build date:
>> 2017-08-24 12:02 
>> 
>> 
>> Thank you and Kind Regards
>> Immarcqulate. A (Emma Kassy) 
>> 
>> "You miss 100% of the shots you don't take."
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> Post to : dhis2-devs@lists.launchpad.net 
>> <mailto:dhis2-devs@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp 
>> <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

___
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] Switch enrolling organisation unit

[Markus Bekken]

Thank you for alerting us - we will add the button to the tabular entry. 

In the meantime you can still use the referral function if you temporarily show 
the timeline widget.

Hope this helps.

Markus

> 28. aug. 2017 kl. 15.45 skrev Georgi Chakarov :
> 
> Hi,
>  
> It’s available only in Timeline data entry and we are using Tabular data 
> entry (for a good reason).
> Can the Referral button be added to the Tabular data entry as well?
>  
> Georgi
>  
> From: Markus Bekken [mailto:mar...@dhis2.org] 
> Sent: Monday, August 28, 2017 3:10 PM
> To: Georgi Chakarov 
> Cc: DHIS Users ; DHIS 2 Developers list 
> 
> Subject: Re: [Dhis2-users] Switch enrolling organisation unit
>  
> Hi :)
> Assuming this is on 2.27 - you could open these records in Tracker Capture 
> and use the "Referral" functionality. The button for referral is located 
> below the schedule event button. Select the correct organization unit to move 
> the enrollment to, and select "Move permanently" in the referral dialog.
>  
> Markus
>  
> 28. aug. 2017 kl. 14.00 skrev Georgi Chakarov  <mailto:geo...@logicaloutcomes.net>>:
>  
> Hello!
>  
> Is there a quick way to switch enrolling organization units in tracker?
> We have a handful of enrollments at the wrong level, containing a lot of 
> data, so I was wondering how to switch to the correct level.
>  
> Thanks,
>  
> Georgi
>  
>   
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net 
> <mailto:geo...@logicaloutcomes.net> | +1-647-478-5634 x 104 | LogicalOutcomes 
> c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 
> | You may unsubscribe from receiving commercial electronic messages from 
> LogicalOutcomes by emailing i...@logicaloutcomes.net 
> <mailto:i...@logicaloutcomes.net>
>  
> ___
> Mailing list: https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> Post to : dhis2-us...@lists.launchpad.net 
> <mailto:dhis2-us...@lists.launchpad.net>
> Unsubscribe : https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> More help   : https://help.launchpad.net/ListHelp 
> <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] Switch enrolling organisation unit

[Markus Bekken]

Hi :)
Assuming this is on 2.27 - you could open these records in Tracker Capture and 
use the "Referral" functionality. The button for referral is located below the 
schedule event button. Select the correct organization unit to move the 
enrollment to, and select "Move permanently" in the referral dialog.

Markus

> 28. aug. 2017 kl. 14.00 skrev Georgi Chakarov :
> 
> Hello!
>  
> Is there a quick way to switch enrolling organization units in tracker?
> We have a handful of enrollments at the wrong level, containing a lot of 
> data, so I was wondering how to switch to the correct level.
>  
> Thanks,
>  
> Georgi
>  
>   
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net 
>  | +1-647-478-5634 x 104 | LogicalOutcomes 
> c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 
> | You may unsubscribe from receiving commercial electronic messages from 
> LogicalOutcomes by emailing i...@logicaloutcomes.net 
> 
>  
> ___
> 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

Re: [Dhis2-devs] [Dhis2-users] HELP with program indicator/report

[Markus Bekken]

Hey again Georgi,
this seems like a bug with the d2:hasValue function. Using enrollment 
analytics, the intended outcome for 
d2:hasValue(#{programStageWithNoEvents.dataelement}) is false. Just making sure 
your program indcator was an enrollment program indicator - could you register 
this as a bug?

Markus

> 28. aug. 2017 kl. 12.01 skrev Georgi Chakarov :
> 
> Hi Markus,
>  
> Thanks a lot for putting thoughts into this! I also did.
>  
> I do have a pivotal data element, but regardless of the expression it 
> wouldn’t work. This is because DHIS2 cannot evaluate a data element from an 
> event that hasn’t been created. 
> Let’s assume that my entity is at second stage. This means that I have 
> created events for the first and the second stage (the third stage will have 
> event only when the entity passes at the third stage). 
> In this case the filter would be:
> d2:hasValue(#{stage1.dataelement}) && d2:hasValue(#{stage2.dataelement}) && 
> !d2:hasValue(#{stage3.dataelement}) && !d2:hasValue(#{stage4.dataelement})
>  
> I have tested this, but DHIS2 fails to produce a result because stage 3 and 4 
> do not have events yet, thus the indicator cannot assess whether the pivotal 
> data element in these stages has value or not.
> Is this making sense?
>  
> So, I decided to play with tracked entity attribute values in the profile of 
> my entity.
> Markus, can I assign values to a tracked entity (with an option set), based 
> on a data element value in a current stage?
>  
> Regards,
>  
> Georgi
>  
>  
> From: Markus Bekken [mailto:mar...@dhis2.org] 
> Sent: Monday, August 28, 2017 11:30 AM
> To: Georgi Chakarov 
> Cc: DHIS Users ; DHIS 2 Developers list 
> 
> Subject: Re: [Dhis2-users] HELP with program indicator/report
>  
> Hi there Georgi,
> We do not have a function that does exactly what you asked for, but hopefully 
> we can find a way if we examine the data elements in your stages. Do the 
> stages have a data element that is mandatory, or at least so pivotal that you 
> can sue that data element to determine wether the event should be counted? If 
> so I'd recommend looking at a program indicator with the analytics type 
> enrollment. With this strategy you can make four program indicators that 
> fullfills the explicit requirement for 1, 2, 3 and 4 stages:
> Just first stage:
> d2:hasValue(#{stage1.dataelement}) && !d2:hasValue(#{stage2.dataelement}) && 
> !d2:hasValue(#{stage3.dataelement}) && !d2:hasValue(#{stage4.dataelement})
> Just first and second stage:
> d2:hasValue(#{stage1.dataelement}) && d2:hasValue(#{stage2.dataelement}) && 
> !d2:hasValue(#{stage3.dataelement}) && !d2:hasValue(#{stage4.dataelement})
> ..and so on.
>  
> With the above strategy you would find every tracked entity that has followed 
> the expected sequence of events. If you have any requirements for how to 
> count the possible cases that deviates the normal(just stage 1 and 3 for 
> example), the expressions might look different.
>  
> If there is no data element that you can use to proxy the presence of events, 
> you will need a new function for checking events regardless of data. In that 
> case, please report this as a Jira issue.
>  
> Markus
>  
> 25. aug. 2017 kl. 12.11 skrev Georgi Chakarov  <mailto:geo...@logicaloutcomes.net>>:
>  
> Hello all,
>  
> I have a tracker program with 4 consecutive non-repeatable stages. Each new 
> stage is created after completion of the previous stage.
> I am trying to create a report/program indicator that counts the tracked 
> entities at their latest stage. In other words, I want to know how many 
> tracked entities I have at each stage without double counting.
>  
> For example, I have 10 tracked entities each of them starting at stage I. 2 
> tracked entities progressed at stage II , 2 progressed at stage III and two 
> progressed at stage IV.
> My report should show (program indicator should calculate) that 4 tracked 
> entities are still at stage I, 2 are in stage II, 2 are in stage III and 2 
> are in stage IV.
>  
> Do you have any idea how to build this one?
>  
> Georgi
>  
>   
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net 
> <mailto:geo...@logicaloutcomes.net> | +1-647-478-5634 x 104 | LogicalOutcomes 
> c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 
> | You may unsubscribe from receiving commercial electronic messages from 
> LogicalOutcomes by emailing i...@logicaloutcomes.net 
> <mailto:i...@logicaloutcomes.net>
>  
> ___
> Mailing list: https://launchpad.net/~dhis2-users 
> <https://launchp

Re: [Dhis2-devs] [Dhis2-users] Assign value to a tracked entity attribute with an option set

[Markus Bekken]

Ok, that makes it a bit more tricky. You probably want to assign and save 
tracked entity instance attributes while filling in data in an event. The 
problem with this is that the assignments to tracked entity attributes will be 
triggered when you are in the registration form, or if you open the edit 
profile widget - but generally not when you enter data in program stages.

There has been a few requests to allow assigning TEI attributes from everywhere 
in the program, and we can conceivably support this properly. Please consider 
creating a Jira issue describing your use case.

Is it a possible workaround to make program indicators that would query both 
the data element and the tracked entity attribute?

Markus

> 28. aug. 2017 kl. 13.26 skrev Georgi Chakarov :
> 
> Hi Markus,
>  
> I do mean a “Yes only” data element, not attribute. Basically, at data entry 
> if the data element is ticked off I want a program rule to automatically 
> assign value to a tracked entity attribute (which is an option set). Do you 
> think this is possible and what would be the correct expression for assigning 
> the value?
>  
> On another note, “Yes only” data elements work with both “1” and “true” in 
> expressions.
>  
> Thanks for your input!
>  
> Georgi
>  
> From: Markus Bekken [mailto:mar...@dhis2.org] 
> Sent: Monday, August 28, 2017 11:05 AM
> To: Georgi Chakarov 
> Cc: DHIS Users ; DHIS 2 Developers list 
> 
> Subject: Re: [Dhis2-users] Assign value to a tracked entity attribute with an 
> option set
>  
> Hi there Gorgi!
>  
> You mention a "Yes only" data element, but did you mean a "Yes only" tracked 
> entity attribute? Meaning, is the checkbox and the dropdown both located 
> inside same registration/profile form?
>  
> If they are, you can make a rule in the way you describe below. The correct 
> expression would be:
> A{recLawStage} == true
> (Assuming you make a program rule variable called recLawStage for the "Yes 
> only" question)
>  
> Best regards, 
> Markus
>  
> 25. aug. 2017 kl. 14.03 skrev Georgi Chakarov  <mailto:geo...@logicaloutcomes.net>>:
>  
> Hello,
>  
> Using program rules, can I assign value to a tracked entity attribute with an 
> option set?
> In other words, I want the answer option selected for my tracked entity 
> attribute to be dependent on a data element in the current stage.
>  
> I have a YES_Only data element called “Recommendation progressed at law 
> stage?”. If this data element is ticked off I want my tracked entity 
> attribute to be assigned with ‘Law’ answer option.
> This is the rule I have built, that does not seem to be working.
>  
> 1)  Expression - “Recommendation progressed at law stage?” == 1
>  
>  
> 
>  
>  
> 2)  Assign value – Stage == ‘Law’
>  
>   
> 
>  
>  
> Can anyone tell me what is the correct expression to compose, (if values can 
> be assigned to data elements with option sets at all)?
>  
> Thanks a lot,
>  
> Georgi
>  
> 
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net 
> <mailto:geo...@logicaloutcomes.net> | +1-647-478-5634 x 104 | LogicalOutcomes 
> c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 
> | You may unsubscribe from receiving commercial electronic messages from 
> LogicalOutcomes by emailing i...@logicaloutcomes.net 
> <mailto:i...@logicaloutcomes.net>
>  
> ___
> Mailing list: https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> Post to : dhis2-us...@lists.launchpad.net 
> <mailto:dhis2-us...@lists.launchpad.net>
> Unsubscribe : https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> More help   : https://help.launchpad.net/ListHelp 
> <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] Showing Identifiers in Relationship box

[Markus Bekken]

Sorry, I misunderstood your original question.

To display an attribute in the relationship table, you have to open the tracked 
entity attribute and select the "display in list without program" option. 

Markus

> 27. aug. 2017 kl. 08.48 skrev Immaculate Ayebazibwe :
> 
> Hi Everyone,
> I am working with relationships from program A to B in tracker capture.
> I want to be able to show some identifiers details from B after I have 
> created a relationship in A while this is possible in demo, I am not sure how 
> to accomplish the same on my instance. 
> Above in my instance
> 
> Demo instance
> ​
> Would someone please let me help me accomplish the effect of demo instance.
> I am running 
> Version:
> 2.27
> Build revision:
> 0303f0d
> Build date:
> 2017-08-24 12:02 
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> ___
> 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 with program indicator/report

[Markus Bekken]

Hi there Georgi,
We do not have a function that does exactly what you asked for, but hopefully 
we can find a way if we examine the data elements in your stages. Do the stages 
have a data element that is mandatory, or at least so pivotal that you can sue 
that data element to determine wether the event should be counted? If so I'd 
recommend looking at a program indicator with the analytics type enrollment. 
With this strategy you can make four program indicators that fullfills the 
explicit requirement for 1, 2, 3 and 4 stages:
Just first stage:
d2:hasValue(#{stage1.dataelement}) && !d2:hasValue(#{stage2.dataelement}) && 
!d2:hasValue(#{stage3.dataelement}) && !d2:hasValue(#{stage4.dataelement})
Just first and second stage:
d2:hasValue(#{stage1.dataelement}) && d2:hasValue(#{stage2.dataelement}) && 
!d2:hasValue(#{stage3.dataelement}) && !d2:hasValue(#{stage4.dataelement})
..and so on.

With the above strategy you would find every tracked entity that has followed 
the expected sequence of events. If you have any requirements for how to count 
the possible cases that deviates the normal(just stage 1 and 3 for example), 
the expressions might look different.

If there is no data element that you can use to proxy the presence of events, 
you will need a new function for checking events regardless of data. In that 
case, please report this as a Jira issue.

Markus

> 25. aug. 2017 kl. 12.11 skrev Georgi Chakarov :
> 
> Hello all,
>  
> I have a tracker program with 4 consecutive non-repeatable stages. Each new 
> stage is created after completion of the previous stage.
> I am trying to create a report/program indicator that counts the tracked 
> entities at their latest stage. In other words, I want to know how many 
> tracked entities I have at each stage without double counting.
>  
> For example, I have 10 tracked entities each of them starting at stage I. 2 
> tracked entities progressed at stage II , 2 progressed at stage III and two 
> progressed at stage IV.
> My report should show (program indicator should calculate) that 4 tracked 
> entities are still at stage I, 2 are in stage II, 2 are in stage III and 2 
> are in stage IV.
>  
> Do you have any idea how to build this one?
>  
> Georgi
>  
>   
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net 
>  | +1-647-478-5634 x 104 | LogicalOutcomes 
> c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 
> | You may unsubscribe from receiving commercial electronic messages from 
> LogicalOutcomes by emailing i...@logicaloutcomes.net 
> 
>  
> ___
> 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

Re: [Dhis2-devs] Showing Identifiers in Relationship box

[Markus Bekken]

Thank you,

In the relationships widget you should see one table for each program that is 
represented within the relationships that belongs to your local tracked entity 
attribute. Could you provide some more details on your local setup of 
relationships and programs?

> 28. aug. 2017 kl. 09.49 skrev Immaculate Ayebazibwe :
> 
> ​Hey Markus,
> Thx for the quick response
> Yes it has 
> Version:
> 2.27
> Build revision:
> 0303f0d
> Build date:
> 2017-08-24 12:02 ​
> 
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> 
> On Mon, Aug 28, 2017 at 10:44 AM, Markus Bekken  <mailto:markus.bek...@gmail.com>> wrote:
> Hi Emma,
> splitting the relationship into tables(one for each program) is a pretty new 
> improvement. Have your local instance(assuming it is 2.27) been updated 
> recently?
> 
> Best regards,
> Markus
> 
>> 27. aug. 2017 kl. 08.48 skrev Immaculate Ayebazibwe > <mailto:ekass...@gmail.com>>:
>> 
>> Hi Everyone,
>> I am working with relationships from program A to B in tracker capture.
>> I want to be able to show some identifiers details from B after I have 
>> created a relationship in A while this is possible in demo, I am not sure 
>> how to accomplish the same on my instance. 
>> Above in my instance
>> 
>> Demo instance
>> ​
>> Would someone please let me help me accomplish the effect of demo instance.
>> I am running 
>> Version:
>> 2.27
>> Build revision:
>> 0303f0d
>> Build date:
>> 2017-08-24 12:02 
>> 
>> 
>> Thank you and Kind Regards
>> Immarcqulate. A (Emma Kassy) 
>> 
>> "You miss 100% of the shots you don't take."
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> Post to : dhis2-devs@lists.launchpad.net 
>> <mailto:dhis2-devs@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp 
>> <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] Assign value to a tracked entity attribute with an option set

[Markus Bekken]

Hi there Gorgi!

You mention a "Yes only" data element, but did you mean a "Yes only" tracked 
entity attribute? Meaning, is the checkbox and the dropdown both located inside 
same registration/profile form?

If they are, you can make a rule in the way you describe below. The correct 
expression would be:
A{recLawStage} == true
(Assuming you make a program rule variable called recLawStage for the "Yes 
only" question)

Best regards, 
Markus

> 25. aug. 2017 kl. 14.03 skrev Georgi Chakarov :
> 
> Hello,
>  
> Using program rules, can I assign value to a tracked entity attribute with an 
> option set?
> In other words, I want the answer option selected for my tracked entity 
> attribute to be dependent on a data element in the current stage.
>  
> I have a YES_Only data element called “Recommendation progressed at law 
> stage?”. If this data element is ticked off I want my tracked entity 
> attribute to be assigned with ‘Law’ answer option.
> This is the rule I have built, that does not seem to be working.
>  
> 1)  Expression - “Recommendation progressed at law stage?” == 1
>  
>  
> 
>  
>  
> 2)  Assign value – Stage == ‘Law’
>  
>   
> 
>  
>  
> Can anyone tell me what is the correct expression to compose, (if values can 
> be assigned to data elements with option sets at all)?
>  
> Thanks a lot,
>  
> Georgi
>  
> 
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net 
>  | +1-647-478-5634 x 104 | LogicalOutcomes 
> c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 
> | You may unsubscribe from receiving commercial electronic messages from 
> LogicalOutcomes by emailing i...@logicaloutcomes.net 
> 
>  
> ___
> 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

Re: [Dhis2-devs] Downloading Event Reports and Picot Tables

[Markus Bekken]

Hey there,
seems like a feature you can request in Jira!

Markus

> 27. aug. 2017 kl. 09.20 skrev Immaculate Ayebazibwe :
> 
> Hi All,
> When I download event reports or program indicators in pivot tables under 
> Table Layout as Csv or Microsoft excel they have, the orgUnits and data 
> elements/Indicators UIDs generated. For some users this is hard to comprehend.
> Is this a bug or is there a way to turn it off that I must have missed.
> see images
> 
> 
> ​
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> ___
> 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] Showing Identifiers in Relationship box

[Markus Bekken]

Hi Emma,
splitting the relationship into tables(one for each program) is a pretty new 
improvement. Have your local instance(assuming it is 2.27) been updated 
recently?

Best regards,
Markus

> 27. aug. 2017 kl. 08.48 skrev Immaculate Ayebazibwe :
> 
> Hi Everyone,
> I am working with relationships from program A to B in tracker capture.
> I want to be able to show some identifiers details from B after I have 
> created a relationship in A while this is possible in demo, I am not sure how 
> to accomplish the same on my instance. 
> Above in my instance
> 
> Demo instance
> ​
> Would someone please let me help me accomplish the effect of demo instance.
> I am running 
> Version:
> 2.27
> Build revision:
> 0303f0d
> Build date:
> 2017-08-24 12:02 
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> ___
> 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] Issues with Tracked Entity Attributes and Program Rules when using Relationships

[Markus Bekken]

Hi Emma,
thank you for following up. Both these seem to be bugs, please register them in 
Jira and we will do a full investigation and fix.

Best regards
Markus

> 22. aug. 2017 kl. 17.05 skrev Immaculate Ayebazibwe :
> 
> Hi Markus,
> Any ideas?
> Should I create a Jira issue for this?
> 
> On Aug 19, 2017 9:01 AM, "Immaculate Ayebazibwe"  > wrote:
> Hi All,
> I have 2 programs one parent (A) another child (B),
> 
> I have set some attributes to inherit however
> When I create a relationship between A and B, and go to register client in B, 
> the Date of Enrollment allows future dates but this is not the case when I 
> directly register a client in B. Could this be a bug? (I have tested this on 
> demo)
> 
> Also Program rules are not working in B when accessing B from Relationship 
> link in A but they work with direct registration. Is this also another bug?
> Should I create a Jira issue?
> ​I am running 
> Version:
> 2.27
> Build revision:
> 688e9c9
> Build date:
> 2017-08-15 12:02​
> 
> ​Highly appreciate your help​
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> ___
> 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] Unable to Register TEI from the Relationship link

[Markus Bekken]

Hi Emma!

That can definitively make sense in some use cases. If anyone else has a use 
case where this either does or does not make sense, please chime in.

Markus

> 11. aug. 2017 kl. 11.09 skrev Immaculate Ayebazibwe :
> 
> Hi Markus,
> Thank you, 
> I have seen the fix for the double save buttons on the demo platform.
> I have another concern, when I click the add Child and then be able to 
> register, the link does not automatically load the Child's TEI dashboard but 
> rather stays on the mother's TEI dashboard. Wouldnt it be a good idea to 
> automatically open the child's TEI dashboard after registering the 
> relationship to the child.
> 
> 
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> 
> On Mon, Jul 24, 2017 at 1:08 PM, Immaculate Ayebazibwe  <mailto:ekass...@gmail.com>> wrote:
> Hi Markus,
> They have been added
> https://jira.dhis2.org/browse/DHIS2-1948 
> <https://jira.dhis2.org/browse/DHIS2-1948>
> https://jira.dhis2.org/browse/DHIS2-1949 
> <https://jira.dhis2.org/browse/DHIS2-1949>
> 
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> 
> On Mon, Jul 24, 2017 at 12:18 PM, Markus Bekken  <mailto:markus.bek...@gmail.com>> wrote:
> Hi there Emma, 
> I have not been able to yet, other than confirming the concerns you have - 
> and also observing that the page for registering related TEIs does not 
> trigger program rules in the registration form like it should. Could you 
> perhaps register the additional issues you found as bugs in Jira?
> 
> Markus
> 
> 
>> 24. jul. 2017 kl. 11.12 skrev Immaculate Ayebazibwe > <mailto:ekass...@gmail.com>>:
>> 
>> Hi Markus,
>> I hope you are great!
>> Have you had a chance to look at this?
>> 
>> 
>> 
>> Thank you and Kind Regards
>> Immarcqulate. A (Emma Kassy) 
>> 
>> "You miss 100% of the shots you don't take."
>> 
>> On Thu, Jul 20, 2017 at 5:15 PM, Immaculate Ayebazibwe > <mailto:ekass...@gmail.com>> wrote:
>> Hi Markus,
>> Thanks, the issue for saving TEI is working.
>> I have a few concerns, 
>> 1. There are two sets of save and cancel buttons. These might be confusing 
>> to end users even though one set is disabled.
>> 2. The Incident date is set to LMP date for all the programs I have tested 
>> even when I unchecked the show incident date it still shows when registering 
>> a TEI as LMP date.
>> Please note I am testing on Demo instance. See image attached.
>> 
>> 
>> 
>> Thank you and Kind Regards
>> Immarcqulate. A (Emma Kassy) 
>> 
>> "You miss 100% of the shots you don't take."
>> 
>> On Thu, Jul 20, 2017 at 10:43 AM, Markus Bekken > <mailto:markus.bek...@gmail.com>> wrote:
>> Hi Prosper and Emma,
>> Thanks for registering a bug. It was an easy fix, so a new build is on the 
>> way. 
>> 
>> Markus
>> 
>>> 19. jul. 2017 kl. 12.13 skrev Prosper BT >> <mailto:ptb3...@gmail.com>>:
>>> 
>>> Hi Emma,
>>> 
>>> The jira issue is available review, comment and vote
>>> 
>>> DHIS2-1791 <https://jira.dhis2.org/browse/DHIS2-1791>
>>> 
>>> Regards
>>> 
>>> Prosper Behumbiize, MPH
>>> DHIS2 Implementation| HISP Uganda
>>> pros...@hispuganda.org <mailto:ptb3...@gmail.com> | pros...@dhis2.org 
>>> <mailto:pros...@dhis2.org> | Skype: prospertb
>>> 
>>> On Wed, Jul 19, 2017 at 12:43 PM, Immaculate Ayebazibwe >> <mailto:ekass...@gmail.com>> wrote:
>>> Hi Dev Team, Markus, Abyot,
>>> Any Ideas?
>>> Should I create a JIRA issue?
>>> I will appreciate a response.
>>> 
>>> 
>>> 
>>> Thank you and Kind Regards
>>> Immarcqulate. A (Emma Kassy) 
>>> 
>>> "You miss 100% of the shots you don't take."
>>> 
>>> On Mon, Jul 17, 2017 at 5:26 PM, Immaculate Ayebazibwe >> <mailto:ekass...@gmail.com>> wrote:
>>> Hi All,
>>> I am trying to add a relation between a parent TEI and child TEI but when I 
>>> click the the relationship link and click add to register child TEI, 
>>> nothing happens or new TEI is not registered.
>>> Tested this on Demo using MNCH/PNC Adult woman program and Child Program.
>>> 
>>> Also take a look at image attached
>>&g

Re: [Dhis2-devs] [Dhis2-users] d2: daysbetween AND d2:yearsbetween not working properly in 2.27 build revision b6e8cde

[Markus Bekken]

Hi Georgi!
The age should also have worked fine - the age is in reality just a date being 
displayed in another way. Can you report the bug in Jira please?

One thing to consider if you want to combine this rule with the AGE data type: 
The number of years displayed in the AGE data element is calculated based on 
todays date. The calculation that you are doing the rule is calculating the age 
of the person at the time of enrollment. That means that if you register a 
person 17 years old today, with today as the enrollment date, the AGE 
dataelement would display 17 as the age and your rule would also consider the 
person to be 17. Then if you come back in 1 year, the AGE data element would 
show 18 as the age - but the underlying birthdate and enrollment date would be 
unchanged and therefore the rule would still calculate the age to 17.

Markus

> 9. aug. 2017 kl. 14.24 skrev Georgi Chakarov :
> 
> Hi Markus,
>  
> I was able to test this expression d2:yearsBetween(A{Date of Birth}, V{ 
> enrollment _date})  <18
> The problem was that my Date of Birth attribute was of value type AGE. Once I 
> changed it to DATE the program rule started working.
>  
> Is there anything specific that needs to be taken into consideration when 
> working with Age value type?
>  
> Regards,
>  
> Georgi
>  
> From: Markus Bekken [mailto:mar...@dhis2.org] 
> Sent: Wednesday, August 9, 2017 11:01 AM
> To: Georgi Chakarov 
> Cc: DHIS Users ; DHIS 2 Developers list 
> 
> Subject: Re: [Dhis2-users] FW: d2: daysbetween AND d2:yearsbetween not 
> working properly in 2.27 build revision b6e8cde
>  
> Hi there Georgi!
> The expression
> d2:yearsBetween(A{Date of Birth}, V{ enrollment _date})  <18
> should be the correct one. I would change the V{ enrollment _date} to 
> V{enrollment _date}
>  
> Note that before the birth date is not entered, the expression will evaluate 
> to 0 - which will be less than 18.
>  
> Let me know how it goes.
>  
> Markus
>  
> 9. aug. 2017 kl. 00.41 skrev Georgi Chakarov  <mailto:geo...@logicaloutcomes.net>>:
>  
> Hello all! Any thoughts on my email below from last week?
>  
> Thanks,
>  
> Georgi
>  
> From: Georgi Chakarov 
> Sent: Friday, August 4, 2017 1:01 PM
> To: DHIS Users  <mailto:dhis2-us...@lists.launchpad.net>>; DHIS 2 Developers list 
> mailto:dhis2-devs@lists.launchpad.net>>
> Cc: Sara Gaudon mailto:s...@logicaloutcomes.net>>; 
> Kristiyan Panayotov  <mailto:kristi...@logicaloutcomes.net>>
> Subject: d2: daysbetween AND d2:yearsbetween not working properly in 2.27 
> build revision b6e8cde
>  
> Hello all!
>  
> I am trying to create a program rule based on Date of birth and Enrollment 
> date. Basically, I want to hide one set of data elements if the client is 
> below 18 years old and another set of data elements if the client is above 18 
> years of age.
>  
> This is what I tried:
> 1)  (d2:daysBetween(A{Date of Birth}, V{enrollment_date})/365)  <18   
>   THIS DOES NOT WORK
> 2)  (d2:yearsBetween(A{Date of Birth}, V{ enrollment _date})/365)  <18
>   This actually works(hides the data element I want), but I don’t think 
> it is the correct expression.
> 3)  d2:yearsBetween(A{Date of Birth}, V{ enrollment _date})  <18  
> I think that this is the correct expression, but it is executing 
> the rule (does not hide the data element).
>  
> Do you think that there might be a bug in how these expressions work? If not, 
> can someone guide me to the correct expression?
>  
> Thanks in advance,
>  
> Georgi
>  
>  
>  
>  
>   
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net 
> <mailto:geo...@logicaloutcomes.net> | +1-647-478-5634 x 104 | LogicalOutcomes 
> c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 
> | You may unsubscribe from receiving commercial electronic messages from 
> LogicalOutcomes by emailing i...@logicaloutcomes.net 
> <mailto:i...@logicaloutcomes.net>
>  
> ___
> Mailing list: https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> Post to : dhis2-us...@lists.launchpad.net 
> <mailto:dhis2-us...@lists.launchpad.net>
> Unsubscribe : https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> More help   : https://help.launchpad.net/ListHelp 
> <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] FW: d2: daysbetween AND d2:yearsbetween not working properly in 2.27 build revision b6e8cde

[Markus Bekken]

Hi there Georgi!
The expression
d2:yearsBetween(A{Date of Birth}, V{ enrollment _date})  <18
should be the correct one. I would change the V{ enrollment _date} to 
V{enrollment _date}

Note that before the birth date is not entered, the expression will evaluate to 
0 - which will be less than 18.

Let me know how it goes.

Markus

> 9. aug. 2017 kl. 00.41 skrev Georgi Chakarov :
> 
> Hello all! Any thoughts on my email below from last week?
>  
> Thanks,
>  
> Georgi
>  
> From: Georgi Chakarov 
> Sent: Friday, August 4, 2017 1:01 PM
> To: DHIS Users ; DHIS 2 Developers list 
> 
> Cc: Sara Gaudon ; Kristiyan Panayotov 
> 
> Subject: d2: daysbetween AND d2:yearsbetween not working properly in 2.27 
> build revision b6e8cde
>  
> Hello all!
>  
> I am trying to create a program rule based on Date of birth and Enrollment 
> date. Basically, I want to hide one set of data elements if the client is 
> below 18 years old and another set of data elements if the client is above 18 
> years of age.
>  
> This is what I tried:
> 1)  (d2:daysBetween(A{Date of Birth}, V{enrollment_date})/365)  <18   
>   THIS DOES NOT WORK
> 2)  (d2:yearsBetween(A{Date of Birth}, V{ enrollment _date})/365)  <18
>   This actually works(hides the data element I want), but I don’t think 
> it is the correct expression.
> 3)  d2:yearsBetween(A{Date of Birth}, V{ enrollment _date})  <18  
> I think that this is the correct expression, but it is executing 
> the rule (does not hide the data element).
>  
> Do you think that there might be a bug in how these expressions work? If not, 
> can someone guide me to the correct expression?
>  
> Thanks in advance,
>  
> Georgi
>  
>  
>  
>  
>   
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net 
>  | +1-647-478-5634 x 104 | LogicalOutcomes 
> c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 
> | You may unsubscribe from receiving commercial electronic messages from 
> LogicalOutcomes by emailing i...@logicaloutcomes.net 
> 
>  
> ___
> 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

Re: [Dhis2-devs] [Dhis2-users] Help with a program rule

[Markus Bekken]

Hi there Georgi!
Thanks for the feedback.

It seems you got it almost right except for one little detail on the usage of 
the substring function. 

To get the fifth character you would have to change your expression to:
 d2:substring(A{Client ID}, 5, 6) == '2'

There was an error in the doc, so a small update is on the way here:
19.5.6. Reference information: Operators and functions to use in program rule 
expression 


Hope this helps!

Best regards
Markus

> 4. aug. 2017 kl. 17.58 skrev Georgi Chakarov :
> 
> Hi all (again)! J
>  
> I have a challenging task for whoever is interested. I find it quite 
> difficult working with the functions in program rules expression, especially 
> learning from the user manual.
>  
> I am trying to execute the following rule:
> If the fifth character of Client ID (text attribute) is equal to ‘2’, the Sex 
> (Option set attribute) should be equal to ‘Female’. This is an example of 
> client ID: 2.
>  
> This is what I think:
> 1)  I need to extract the fifth character and evaluate whether it equals 
> ‘2’. I am using d2:substring(text, start-char-num, end-char-num)
> This is my expression d2:substring(A{Client ID}, 5, 5) == '2'
>  
> 2)  I need to push ‘Female’ option to the Sex attribute. I am not sure 
> how to do that from the program rule actions. I tried:
> a)   Assign value to Sex attribute – expression is ‘Female’
> b)  Assign value to Sex attribute – expression is A{Sex} == 'Female'
>  
> None of the combinations 1) + 2a) OR 1) + 2b) worked, regretfully.
>  
> Does any of you know or can figure out how this might work?
>  
> Regards,
>  
> Georgi 
>  
>  
>   
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net 
>  | +1-647-478-5634 x 104 | LogicalOutcomes 
> c/o Centre for Social Innovation, 720 Bathurst Street, Toronto Canada M5S 2R4 
> | You may unsubscribe from receiving commercial electronic messages from 
> LogicalOutcomes by emailing i...@logicaloutcomes.net 
> 
>  
> ___
> 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

Re: [Dhis2-devs] 'Ask user to create new event...' no longer respects hiding of program stages

[Markus Bekken]

Hey Sam,
A fix is just checked in and a build is triggering for 2.27. Please have a look 
and see if your usecase is working better now.

Markus

> 7. aug. 2017 kl. 13.55 skrev Sam Johnson :
> 
> Hi Devs,
>  
> I’ve reported this as DHIS2-2012 .  
> Basically, when users are prompted to create a new event booking, they are 
> now offered the next available program stage – even if it’s supposed to be 
> hidden.  This used to work correctly (ie hidden program stages were skipped, 
> and the user was prompted to create a new event booking in the next available 
> unhidden program stage), but seems to have stopped working in 2.27.  (I 
> haven’t had time to check whether the latest updates have also affected this 
> in older versions of DHIS2.)
>  
> The hiding of program stages works well when users manually add a new event 
> booking, it’s just the ‘Ask user to create new event…’ prompt that’s broken.
>  
> This has broken a Tracker program that we’ve developed, so I’d be very 
> grateful if someone is able to take a quick look.  (I’ve included full 
> instructions in the Jira ticket for reproducing this issue on the Play demo.)
>  
> Many thanks,
>  
> Sam.
>  
> ___
> 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] Unable to Register TEI from the Relationship link

[Markus Bekken]

Hi there Emma, 
I have not been able to yet, other than confirming the concerns you have - and 
also observing that the page for registering related TEIs does not trigger 
program rules in the registration form like it should. Could you perhaps 
register the additional issues you found as bugs in Jira?

Markus

> 24. jul. 2017 kl. 11.12 skrev Immaculate Ayebazibwe :
> 
> Hi Markus,
> I hope you are great!
> Have you had a chance to look at this?
> 
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> 
> On Thu, Jul 20, 2017 at 5:15 PM, Immaculate Ayebazibwe  <mailto:ekass...@gmail.com>> wrote:
> Hi Markus,
> Thanks, the issue for saving TEI is working.
> I have a few concerns, 
> 1. There are two sets of save and cancel buttons. These might be confusing to 
> end users even though one set is disabled.
> 2. The Incident date is set to LMP date for all the programs I have tested 
> even when I unchecked the show incident date it still shows when registering 
> a TEI as LMP date.
> Please note I am testing on Demo instance. See image attached.
> 
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> 
> On Thu, Jul 20, 2017 at 10:43 AM, Markus Bekken  <mailto:markus.bek...@gmail.com>> wrote:
> Hi Prosper and Emma,
> Thanks for registering a bug. It was an easy fix, so a new build is on the 
> way. 
> 
> Markus
> 
>> 19. jul. 2017 kl. 12.13 skrev Prosper BT > <mailto:ptb3...@gmail.com>>:
>> 
>> Hi Emma,
>> 
>> The jira issue is available review, comment and vote
>> 
>> DHIS2-1791 <https://jira.dhis2.org/browse/DHIS2-1791>
>> 
>> Regards
>> 
>> Prosper Behumbiize, MPH
>> DHIS2 Implementation| HISP Uganda
>> pros...@hispuganda.org <mailto:ptb3...@gmail.com> | pros...@dhis2.org 
>> <mailto:pros...@dhis2.org> | Skype: prospertb
>> 
>> On Wed, Jul 19, 2017 at 12:43 PM, Immaculate Ayebazibwe > <mailto:ekass...@gmail.com>> wrote:
>> Hi Dev Team, Markus, Abyot,
>> Any Ideas?
>> Should I create a JIRA issue?
>> I will appreciate a response.
>> 
>> 
>> 
>> Thank you and Kind Regards
>> Immarcqulate. A (Emma Kassy) 
>> 
>> "You miss 100% of the shots you don't take."
>> 
>> On Mon, Jul 17, 2017 at 5:26 PM, Immaculate Ayebazibwe > <mailto:ekass...@gmail.com>> wrote:
>> Hi All,
>> I am trying to add a relation between a parent TEI and child TEI but when I 
>> click the the relationship link and click add to register child TEI, nothing 
>> happens or new TEI is not registered.
>> Tested this on Demo using MNCH/PNC Adult woman program and Child Program.
>> 
>> Also take a look at image attached
>> Console is showing the following error attached:
>> 
>> 
>> 
>> 
>> Thank you and Kind Regards
>> Immarcqulate. A (Emma Kassy) 
>> 
>> "You miss 100% of the shots you don't take."
>> 
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-us...@lists.launchpad.net 
>> <mailto:dhis2-us...@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp 
>> <https://help.launchpad.net/ListHelp>
>> 
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-us...@lists.launchpad.net 
>> <mailto:dhis2-us...@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp 
>> <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] Unable to Register TEI from the Relationship link

[Markus Bekken]

Hi Prosper and Emma,
Thanks for registering a bug. It was an easy fix, so a new build is on the way. 

Markus

> 19. jul. 2017 kl. 12.13 skrev Prosper BT :
> 
> Hi Emma,
> 
> The jira issue is available review, comment and vote
> 
> DHIS2-1791 
> 
> Regards
> 
> Prosper Behumbiize, MPH
> DHIS2 Implementation| HISP Uganda
> pros...@hispuganda.org  | pros...@dhis2.org 
>  | Skype: prospertb
> 
> On Wed, Jul 19, 2017 at 12:43 PM, Immaculate Ayebazibwe  > wrote:
> Hi Dev Team, Markus, Abyot,
> Any Ideas?
> Should I create a JIRA issue?
> I will appreciate a response.
> 
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> 
> On Mon, Jul 17, 2017 at 5:26 PM, Immaculate Ayebazibwe  > wrote:
> Hi All,
> I am trying to add a relation between a parent TEI and child TEI but when I 
> click the the relationship link and click add to register child TEI, nothing 
> happens or new TEI is not registered.
> Tested this on Demo using MNCH/PNC Adult woman program and Child Program.
> 
> Also take a look at image attached
> Console is showing the following error attached:
> 
> 
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> 
> 
> ___
> 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

Re: [Dhis2-devs] [Dhis2-users] Help needed: Show/hide previous DE entry based on a selection

[Markus Bekken]

Dear Jean, 
which version og DHIS are you using?

On 2.27 you can do this with program rules. 
- The easiest way would be to make a rule that triggers a "Display text" or 
"Display key/value pair" to the user in case the user answers Yes on the 
designated data field. These texts can be shown in the "Feedback" or "Program 
indicators" widgets, but not in the data entry form itself. 
- It would also be possible to make a rule that assigns the value from visit 1 
into a data element of visit 2. What makes this option less desirable compared 
to the "Display key/value" or "Display text" option above is that the 
assign-strategy will create a duplication of the data from visit 1 into another 
data element in visit 2.

Based on how your data is modelled it might be possible to achieve on older 
versions of dhis2 using program indicators.

Markus

> 27. jun. 2017 kl. 05.52 skrev Mugisha, Jean F. :
> 
> Dear all,
>  
> We have the following use case and your advice would be greatly appreciated.
>  
> Our use-case needs to show/hide a previous DE entry based on a current Yes/No 
> selection. Below are the few requirements that are needed:
>  
> 1st visit: User enters data.
> 2nd visit: User enters data.
> IF user selects Yes on a data element THEN a text box (message) should show 
> up with the previous (in this case 1st visit) data element information (as a 
> FYI message to the user).  
> IF user selects No on a data element THEN the FYI message is hidden.
>  
> We have created tracker program to get the data, but unfortunately, we have 
> been unable to implement 2.a. in DHIS2. I am sure that we are missing 
> something but I can’t seem to figure it out.
>  
> Any help would be greatly appreciated.
>  
> Regards,
> Jean
> ___
> 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] Tracker capture(v26), services.js trying to read object as a array

[Markus Bekken]

Hi there Chatura!
Thank you for the detailed report.

Please go ahead and send a PR, and I'll test and merge. 

Markus

> Den 8. jul. 2017 kl. 08.54 skrev chathura widanage 
> :
> 
> Hi devs,
> 
> We are currently experiencing an issue in tracker capture (v26) registration 
> process. When we do a new registration, it actually does necessary api calls 
> to persist the registration, but front-end web application stops 
> execution(doesn't show feedback) due to a javascript exception which throws 
> due to reading an object as an array.
> 
> Issue it at line line 1903 services.js branch v26,
> 
> 1902 : var periods = getEventDuePeriod(null, stage, enrollment);
> 1903 : newEvent.dueDate = DateUtils.formatFromUserToApi(periods[0].endDate);
> 
> However, at line 1826 of services.js in branch v26,
> 
> it does following transformation after doing same method 
> call(getEventDuePeriod) which returns an object,
> var prds = getEventDuePeriod(eventsPerStage, programStage, enrollment);
> var periods = prds && prds.availablePeriods && prds.availablePeriods.length ? 
> prds.availablePeriods : [];
> 
> And does periods.length>0 check before accessing periods[0]. So I believe, 
> same should be done at 1903.
> 
> I think this issue was not there in v25, since getEventDuePeriod() was 
> actually returning an array.
> ​
> ​Please find a screenshot taken during the javascript debug attached with 
> this email for further clarification. 
> 
> Kindly let us know if this is an issue in code(services.js), or if this is an 
> issue in our setup. If you can confirm this is a bug, I can send a PR with 
> the fix.
> 
> Thanks & Regards,
> Chathura
> 
> -- 
> Best Regards,
> 
> Chathura Widanage,
> Undergraduate,
> Department of Computer Science and Engineering,
> University of Moratuwa,
> Sri Lanka
>
> 
> ___
> 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] UNABLE TO DOWNLOAD DATA FROM TRACKER CAPTURE STAGE

[Markus Bekken]

Hey again Stanley,
what is the specific error in the downloaded data from your screenshot below? 
Unless told otherwise I would say that the data in your screenshot looks 
correct :)

Markus

> 20. jun. 2017 kl. 16.53 skrev Stanley Kalyati :
> 
> Hi Ocaya,
> 
> I am using google chrome as my browser.
> 
> When i download the stage this is what i get.
> 
> Regards and thank you
> 
> Stanley
> 
> On Tue, Jun 20, 2017 at 3:54 PM, Ocaya Stephen  <mailto:stepho...@gmail.com>> wrote:
> Stanley,
> 
> Just to understand, what browser are you using ?? 
> 
> My friends also had the same issues with download blank excel file while 
> another person is able to load the full data.
> 
> Regards
> 
> On Tue, Jun 20, 2017 at 8:40 AM, Stanley Kalyati  <mailto:skaly...@gmail.com>> wrote:
> Thanks Markus for returning my mail.I am.using version 2.26 and my program 
> has 4 stages.
> 
> I have not reproduced the problem on play
> 
> Thanks
> 
> Stanley
> 
> On Jun 20, 2017 8:35 AM, "Markus Bekken"  <mailto:mar...@dhis2.org>> wrote:
> Hi there Stanley,
> Sorry for the delayed response. 
> I was not able to reproduce the problem on the play dev instance. Which 
> version are you on? Did you try and reproduce the problem in play?
> 
> Best regards,
> Markus
> 
>> 20. jun. 2017 kl. 06.51 skrev Stanley Kalyati > <mailto:skaly...@gmail.com>>:
>> 
>> Any help on this one? No one has come forth to assist.
>> 
>> Thanks
>> Stanley
>> 
>> On Jun 15, 2017 4:17 PM, "Stanley Kalyati" > <mailto:skaly...@gmail.com>> wrote:
>> Hi All,
>> 
>> I am trying to download raw data from Tracker Capture where i have 3 stages 
>> and whenever i select the stage and try to download using CSV,i get blank 
>> CSV file without actual data entered.
>> 
>> Attached herewith the sample of the processes that i took.
>> 
>> How do i extract data from the stages? Urgent please  
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> Post to : dhis2-devs@lists.launchpad.net 
>> <mailto:dhis2-devs@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp 
>> <https://help.launchpad.net/ListHelp>
> 
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-devs 
> <https://launchpad.net/~dhis2-devs>
> Post to : dhis2-devs@lists.launchpad.net 
> <mailto:dhis2-devs@lists.launchpad.net>
> Unsubscribe : https://launchpad.net/~dhis2-devs 
> <https://launchpad.net/~dhis2-devs>
> More help   : https://help.launchpad.net/ListHelp 
> <https://help.launchpad.net/ListHelp>
> 
> 
> 
> 
> -- 
> 
> You can do anything, but not everything.
> 
> 

___
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] UNABLE TO DOWNLOAD DATA FROM TRACKER CAPTURE STAGE

[Markus Bekken]

Hi there Stanley,
Sorry for the delayed response. 
I was not able to reproduce the problem on the play dev instance. Which version 
are you on? Did you try and reproduce the problem in play?

Best regards,
Markus

> 20. jun. 2017 kl. 06.51 skrev Stanley Kalyati :
> 
> Any help on this one? No one has come forth to assist.
> 
> Thanks
> Stanley
> 
> On Jun 15, 2017 4:17 PM, "Stanley Kalyati"  > wrote:
> Hi All,
> 
> I am trying to download raw data from Tracker Capture where i have 3 stages 
> and whenever i select the stage and try to download using CSV,i get blank CSV 
> file without actual data entered.
> 
> Attached herewith the sample of the processes that i took.
> 
> How do i extract data from the stages? Urgent please  
> 
> ___
> 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] Skip-logic on Events with Option Codes - can't seem to get it to work...

[Markus Bekken]

Thanks, just a quick question to rule out possible logical problems: Do the two 
other mentioned rule hide the same field? If one rule wants to hide a field, 
and another one does not - the one rule who wants to hide will take precedence 
and the field will be hidden. 

Markus

> 13. jun. 2017 kl. 09.56 skrev David Hagan :
> 
> Here are the specifics of the skip logic to see if anyone can spot if I've 
> made a mistake.
> 
> The CE-Discharge variable represents a discharge method data element that is 
> an option-set with 4 values.
> 
> Absconded, MODDIS_ABSC
> Transferred, MODDIS_TRANS
> Died, MODDIS_DIED
> Discharged, MODDIS_DISCH
> 
> simple rule is #{CE-Discharge} != 'MODDIS_TRANS' then hide some extra 
> transfer detailed they want to capture.
> 
> there is another similar rule but for the MODDIS_DIED option.
> 
> Let me know if I am missing something.
> 
> 
> 
> On 13 June 2017 at 10:09, David Hagan  <mailto:david.ha...@sagehagan.com>> wrote:
> Thanks Markus,
> 
> Yes, we made sure we set that ... here's the return from the API call... will 
> do some further testing to see if we can figure this out.
> 
> 
> DATAELEMENT_CURRENT_EVENT
> true
> 
> 
> By the way, we had a go with 2.27 last night so we could get access to the 
> new Rules interface ... got to say we love it :-). Had to roll back though 
> because the org tree wasn't displaying in the data entry or event capture 
> screens but would display once we did a 'search' for the root node. Haven't 
> had time to document this or fully test things as we are on a deadline.
> 
> Cheers
> 
> David
> 
> 
> On 13 June 2017 at 09:41, Markus Bekken  <mailto:mar...@dhis2.org>> wrote:
> Hi David!
> There is a flag when you create the source field that lets you control wether 
> the value or code should be used in the comparisons. Unfortunately the source 
> fields is not editable once created until version 2.27 onwards. You can check 
> the settings of your source field in the API:
> 
> https://play.dhis2.org/release1/api/programRuleVariables?paging=none&fields=name,programRuleVariableSourceType,useCodeForOptionSet&filter=name:eq:
>  
> <https://play.dhis2.org/release1/api/programRuleVariables?paging=none&fields=name,programRuleVariableSourceType,useCodeForOptionSet&filter=name:eq:>(sourceFieldName)
> 
> Also - what is the source type of the source field that behaves 
> inconsistently?
> 
> Markus
> 
>> 13. jun. 2017 kl. 08.32 skrev David Hagan > <mailto:david.ha...@sagehagan.com>>:
>> 
>> Hi,
>> 
>> Version: 2.26
>> Build revision: a9c5994
>> Build date: 2017-06-11 06:43
>> 
>> Has anyone else had problems with inconsistency in the execution of 
>> skip-logic rules for Events? Sometimes the rules seems to work on the 
>> 'value' ... sometimes they don't seem to work. But what I really need (since 
>> we are doing this in two languages) is the rule to fire off the Code for an 
>> Option Set (simple drop-down data-element with 4 values).
>> 
>> Any known issues with this?
>> 
>> Cheers
>> 
>> David
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-us...@lists.launchpad.net 
>> <mailto:dhis2-us...@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp 
>> <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] Skip-logic on Events with Option Codes - can't seem to get it to work...

[Markus Bekken]

Hi David!
There is a flag when you create the source field that lets you control wether 
the value or code should be used in the comparisons. Unfortunately the source 
fields is not editable once created until version 2.27 onwards. You can check 
the settings of your source field in the API:

https://play.dhis2.org/release1/api/programRuleVariables?paging=none&fields=name,programRuleVariableSourceType,useCodeForOptionSet&filter=name:eq:(sourceFieldName)

Also - what is the source type of the source field that behaves inconsistently?

Markus

> 13. jun. 2017 kl. 08.32 skrev David Hagan :
> 
> Hi,
> 
> Version: 2.26
> Build revision: a9c5994
> Build date: 2017-06-11 06:43
> 
> Has anyone else had problems with inconsistency in the execution of 
> skip-logic rules for Events? Sometimes the rules seems to work on the 'value' 
> ... sometimes they don't seem to work. But what I really need (since we are 
> doing this in two languages) is the rule to fire off the Code for an Option 
> Set (simple drop-down data-element with 4 values).
> 
> Any known issues with this?
> 
> Cheers
> 
> David
> ___
> 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

Re: [Dhis2-devs] API - event coordinates not getting saved

[Markus Bekken]

Dear Harsh,
can you reproduce in play? Trying to reproduce through the event capture app, 
the only difference I see between the two payloads is the number of decimals in 
the coordinate captured. The apps uses only 6 decimals:
"coordinate":{"latitude":9.394871,"longitude":-11.487579}

Markus

> 12. jun. 2017 kl. 14.53 skrev Harsh Atal :
> 
> Hi
> 
> I am making events through API which include coordinates. But when posting 
> the event everything gets saved except coordinates.
> 
> URL : http://localhost:8090/dhis/api/events/ 
> 
> Pay Load : 
> {
> "coordinate": {"latitude": 13.1707428419558, "longitude": 79.6169626173919},
> "event": "O02d839dd7c",
> "eventDate": "2017-04-05T16:20:00.360+05:30",
> "orgUnit": "ZFMOv30Ab8b",
> "program": "Ml0ZNj9APN0",
> "programStage": "iWcQ5lxmsy4",
> "status": "COMPLETED"
> }
> 
> Import summary is all OK and rest of the data is saved. 
> 
> Version:
> 2.25
> Build revision:
> f20cd15
> Build date:
> 2017-06-12 17:23
> 
> Same happens in 26 and 27 also.
> 
> Regards
> harsh
> ___
> 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] Program Indicator with Period as Condition

[Markus Bekken]

Hey Stanley,
currently thats not possible to do exactly as defined below. When using the 
enrollment analytics type, the repeated events is "flattened", so you can only 
query the newest data value for each data element within each program stage. 
You would have to model your data for the purpose if you want to do something 
like this. For example by splitting into more program stages or by having 
certain data elements that gets filled in at patient status changes.

We are looking at ways to avoid this flattening and letting you query in the 
way you want here, but it is not tagged to a release yet.

Markus

> 6. jun. 2017 kl. 20.54 skrev Stanley Kalyati :
> 
> Hi Markus and All
> 
> thank you for your help with regards to program indicators evaluation between 
> period.i.e
> 
> Finding all patients that is negative and with more than 120 days since the 
> last service can be done in 2.26 and later with the following program 
> indicator:
> Analytic type: Enrollment
> Aggreagation operator: Count
> Expression: V{tei_count}
> Filter: #{DATA ELEMENT FOR DIAGNOSIS} == 'Negative' and 
> d2:daysBetween(V{event_date}, V{current_date}) > 120
> 
> However,how can i evaluate or add a condition of all those tested "negative" 
> 120 days ago but have tested "positive'' within 120 days after the first HIV 
> test?
> 
> Will it look like this?
> 
> Analytic type: Enrollment
> Aggreagation operator: Count
> Expression: V{tei_count}
> Filter: (#{DATA ELEMENT FOR DIAGNOSIS} == 'Negative' and 
> d2:daysBetween(V{event_date}, V{current_date}) > 120) and (#{DATA ELEMENT FOR 
> DIAGNOSIS} == 'Positive' and d2:daysBetween(V{event_date}, 
> V{current_date})<120)
> 
> Kindly assist
> 
> Stanley
> 
> 
> 
> On Fri, Jun 2, 2017 at 8:14 AM, Immaculate Ayebazibwe  <mailto:ekass...@gmail.com>> wrote:
> Thank you Markus,
> Will get back to you.
> 
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> 
> On Thu, Jun 1, 2017 at 1:04 PM, Markus Bekken  <mailto:mar...@dhis2.org>> wrote:
> Hi there Stanley and Emma,
> sorry for the delay.
> 
> For Emmas Question - To count wether someone has received services or not - 
> but avoid counting them twice - you can make the following indicator:
> Analytic type: Event
> Aggregation operator: Count
> Expression: V{tei_count}
> Filter: V{program_stage_uid} == 'THE UID OF YOUR SERVICE PROGRAM STAGE'
> (if you are using 2.25 or older, the last filter is not possible - you would 
> have to make a filter checking one of the mandatory data elements in your 
> program stage(s) used for giving services)
> 
> For the original two issues from Stanley:
> The interval between two events of the same stage is not currently possible 
> to calculate with the current program indicator functionality. We hope to 
> make full support for this in a coming release. To work around this in the 
> current solution, you would have to register the interval since the last 
> event as a data element in the repeating program stage. This data element 
> could be something that the data entry user calculates and enters, or it 
> could be auto assigned by a program rule. The vulnerability with using a 
> helper data element would be the fact that the interval is a part of the 
> data, and if you already have data entered these older events would not have 
> the correct value in this data element. If you change your mind or there is 
> an error in the data, it would be manual work to go through and rectify them.
> 
> Finding all patients that is negative and with more than 120 days since the 
> last service can be done in 2.26 and later with the following program 
> indicator:
> Analytic type: Enrollment
> Aggreagation operator: Count
> Expression: V{tei_count}
> Filter: #{DATA ELEMENT FOR DIAGNOSIS} == 'Negative' and 
> d2:daysBetween(V{event_date}, V{current_date}) > 120
> 
> Hope this helps.
> 
> Best regards
> Markus
> 
> 
>> 1. jun. 2017 kl. 09.43 skrev Stanley Kalyati > <mailto:skaly...@gmail.com>>:
>> 
>> Any update on this?
>> 
>> Eagerly waiting for ideas.
>> 
>> Stanley
>> 
>> On Wed, May 31, 2017 at 2:08 PM, Stanley Kalyati > <mailto:skaly...@gmail.com>> wrote:
>> This another good observation.Let me also benefit from this.
>> 
>> Stanley
>> 
>> On Wed, May 31, 2017 at 1:26 PM, Immaculate Ayebazibwe > <mailto:ekass...@gmail.com>> wrote:
>> Hi Markus,
>> 
>> Stanley, I hope I am not hijacking the conversation.
>> 
>>

Re: [Dhis2-devs] [Dhis2-users] Potential Bug? (skip-logic rules fire on drop-down select but not on radio-button)

[Markus Bekken]

Hey David,

a build is triggering now for 2.26 where this should be fixed.

Markus

> 1. jun. 2017 kl. 14.04 skrev Markus Bekken :
> 
> Hi there David!
> I might also be a bit sleep deprived, but have independently confirmed what 
> you describe below.
> 
> Will fix and get back to you!
> 
> Markus
> 
>> 1. jun. 2017 kl. 12.28 skrev David Hagan > <mailto:david.ha...@sagehagan.com>>:
>> 
>> Hey there community ... 
>> 
>> Someone slap me if I've got this wrong ... 
>> 
>> ... been up nearly 24 hours with crazy travel today  and it doesn't help 
>> that some studious drummers associated with Ramadan rituals are gleefully 
>> banging their drums outside my hotel bedroom window for half an hour at 2AM 
>> every morning since last Saturday 😵
>> 
>> Anyway ... got a simple event capture form with some skip logic to un-hide 
>> some extra fields when certain options are selected. As drop-down lists, the 
>> rules fire, but as radio buttons (the setting you can select for the overall 
>> program), the same rule doesn't fire.
>> 
>> Anyone else experience this or can someone validate or not? 
>> 
>> Version details are: 
>> 
>> Version:
>> 2.26
>> Build revision:
>> 09e4ed6
>> Build date:
>> 2017-05-22 13:50
>> 
>> Cheers
>> 
>> David Hagam
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> Post to : dhis2-devs@lists.launchpad.net 
>> <mailto:dhis2-devs@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp 
>> <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] Potential Bug? (skip-logic rules fire on drop-down select but not on radio-button)

[Markus Bekken]

Hi there David!
I might also be a bit sleep deprived, but have independently confirmed what you 
describe below.

Will fix and get back to you!

Markus

> 1. jun. 2017 kl. 12.28 skrev David Hagan :
> 
> Hey there community ... 
> 
> Someone slap me if I've got this wrong ... 
> 
> ... been up nearly 24 hours with crazy travel today  and it doesn't help that 
> some studious drummers associated with Ramadan rituals are gleefully banging 
> their drums outside my hotel bedroom window for half an hour at 2AM every 
> morning since last Saturday 😵
> 
> Anyway ... got a simple event capture form with some skip logic to un-hide 
> some extra fields when certain options are selected. As drop-down lists, the 
> rules fire, but as radio buttons (the setting you can select for the overall 
> program), the same rule doesn't fire.
> 
> Anyone else experience this or can someone validate or not? 
> 
> Version details are: 
> 
> Version:
> 2.26
> Build revision:
> 09e4ed6
> Build date:
> 2017-05-22 13:50
> 
> Cheers
> 
> David Hagam
> ___
> 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] Program Indicator with Period as Condition

[Markus Bekken]

Hi there Stanley and Emma,
sorry for the delay.

For Emmas Question - To count wether someone has received services or not - but 
avoid counting them twice - you can make the following indicator:
Analytic type: Event
Aggregation operator: Count
Expression: V{tei_count}
Filter: V{program_stage_uid} == 'THE UID OF YOUR SERVICE PROGRAM STAGE'
(if you are using 2.25 or older, the last filter is not possible - you would 
have to make a filter checking one of the mandatory data elements in your 
program stage(s) used for giving services)

For the original two issues from Stanley:
The interval between two events of the same stage is not currently possible to 
calculate with the current program indicator functionality. We hope to make 
full support for this in a coming release. To work around this in the current 
solution, you would have to register the interval since the last event as a 
data element in the repeating program stage. This data element could be 
something that the data entry user calculates and enters, or it could be auto 
assigned by a program rule. The vulnerability with using a helper data element 
would be the fact that the interval is a part of the data, and if you already 
have data entered these older events would not have the correct value in this 
data element. If you change your mind or there is an error in the data, it 
would be manual work to go through and rectify them.

Finding all patients that is negative and with more than 120 days since the 
last service can be done in 2.26 and later with the following program indicator:
Analytic type: Enrollment
Aggreagation operator: Count
Expression: V{tei_count}
Filter: #{DATA ELEMENT FOR DIAGNOSIS} == 'Negative' and 
d2:daysBetween(V{event_date}, V{current_date}) > 120

Hope this helps.

Best regards
Markus


> 1. jun. 2017 kl. 09.43 skrev Stanley Kalyati :
> 
> Any update on this?
> 
> Eagerly waiting for ideas.
> 
> Stanley
> 
> On Wed, May 31, 2017 at 2:08 PM, Stanley Kalyati  <mailto:skaly...@gmail.com>> wrote:
> This another good observation.Let me also benefit from this.
> 
> Stanley
> 
> On Wed, May 31, 2017 at 1:26 PM, Immaculate Ayebazibwe  <mailto:ekass...@gmail.com>> wrote:
> Hi Markus,
> 
> Stanley, I hope I am not hijacking the conversation.
> 
> Is it possible to just count that some one received the HTC services in a 
> given period and not how many times they received this service.
> Like Stanley said, this is a service offered on a daily/weekly basis and in 
> order to avoid double counting I would just want to check if service is 
> provided in a given period despite the number of times.
> How do I accomplish this?
> 
> 
> 
> Thank you and Kind Regards
> Immarcqulate. A (Emma Kassy) 
> 
> "You miss 100% of the shots you don't take."
> 
> On Wed, May 31, 2017 at 12:54 PM, Stanley Kalyati  <mailto:skaly...@gmail.com>> wrote:
> Markus,
> 
> You have just hit the nail on the head.All those conditions are what am 
> looking for.
> 
> Please guide.
> 
> Thanks
> 
> Stanley
> 
> On May 31, 2017 9:50 AM, "Markus Bekken"  <mailto:mar...@dhis2.org>> wrote:
> Hey again,
> Do you want to evaluate the interval _between_ the visits in the HTC stage 
> for negative patients, and classify them depending on wether it was more or 
> less than 120 days since the last visit?
> 
> Or did you mean that you want to count patients currently negative, and where 
> the last HTC visit happened more than 120 days ago? (Patients that should 
> have come in for a repeat test)
> 
> Best 
> Markus
> 
> 
>> 31. mai 2017 kl. 06.54 skrev Stanley Kalyati > <mailto:skaly...@gmail.com>>:
>> 
>> Markus,
>> 
>> Thanks for coming through.
>> 
>> I have a program with 3 stages.HTC,ART,Viral Load.
>> 
>> HTC is set for daily since clients come for testing each day.And we also do 
>> analysis with regards to those that came to access HTC services per week.Now 
>> those that turn negative are supposed to return for a retest every 3 
>> months.So I want the system to able to identify if one was already tested 
>> like 120days ago or more than 120 days.And we call these repeat tests.
>> 
>> I hope this makes sense.
>> 
>> Secondly, if one tested negative,the two stages must be closed.Only those 
>> positive the other stages must be enabled.
>> 
>> 
>> I hope this makes sense.
>> 
>> Stanley
>> On May 30, 2017 10:46 PM, "Markus Bekken" > <mailto:mar...@dhis2.org>> wrote:
>> Hi Stanley,
>> 
>> It would be great if you can give some more specifics on your use case. 
>> Which program stages do you have, and what dates/inte

Re: [Dhis2-devs] Expected "inter-stage" behaviour of ASSIGN program rule action

[Markus Bekken]

Thank you for understanding. The primary focus going forward is to solve these 
usecases on the event aggregation / program indicator side. I would be happy to 
hear the other use cases you mentioned too.

Between the options below I hope you will be able to find a liveable solution.

Markus

> 23. mai 2017 kl. 12.18 skrev Victor Garcia :
> 
> Hi Markus,
> 
> thanks for the response. We suspected that this behavior could be something 
> non-expected, but we really relied on it because it allows us to analyse in a 
> more flexible way.
> 
> For example, one of our use cases is to create a table combining two 
> dataelements in different stages that are defined as optionSets. Let's say we 
> have "Main symptom" at first stage and "Condition at exit" at closure. We 
> need a table that displays the options in "Main symptom" as rows and the 
> options in "Condition at exit" as columns. 
> 
> - Following the first approarch, it would be required to create a program 
> indicator for each combination. We can create some of them (the most 
> important), but the number of combinations could be very large. And it would 
> not allow filtering by other dimensions like patient age or sex.
> 
> - The second approach will work in most of the cases. We could create a 
> helper field in the last stage that copies the value of "Main symptom" and 
> analyse in the last stage. But if somebody modifies the values in the first 
> stage when the last stage has already been registered, the values in the last 
> stage will remain outdated unless they open the last stage to trigger the 
> program rules. It is not usual but could happen sometimes.
> 
> We have a few more use cases where it would be useful to do assignments to 
> other stages. But we also know that this is a behaviour that was not 
> initially thought.
> 
> Thanks,
> 
> Víctor
> 
> On 22 May 2017 at 21:43, Markus Bekken  <mailto:mar...@dhis2.org>> wrote:
> Hi Victor,
> Sorry for the delayed response. 
> 
> The ASSIGN rules is only intended to affect the data that the user sees(the 
> active/current event). This usually means that you can create helper fields, 
> but they rely on the basis for your calculations being in the same event, or 
> in previously registered data. The behavior you describe in 2.25 was not 
> planned, and can be seen as a bug. 
> 
> There is two alternative options that can be pursued:
> - Try creating a program indicator with analytics type 
> "Enrollment"(introduced in 2.26). This will allow you to compare data from 
> the latest event in each program stage across entire enrollments. Possibly 
> this can take away the need for the helper fields.
> - Make a helper field in second program stage, and make an assign rule that 
> assigns "the other way". You will be able to query data from all other 
> program stages when calculating and assigning values to helper fields.
> 
> Best regards,
> Markus
> 
>> 22. mai 2017 kl. 16.32 skrev Victor Garcia > <mailto:vgarcia...@gmail.com>>:
>> 
>> Hi all,
>> 
>> does anyone have any insight about this issue? It is fundamental to 
>> understand the behaviour of ASSIGN program rules in order to design the 
>> programs.
>> 
>> Thanks,
>> 
>> Víctor
>> 
>> On 15 May 2017 at 17:26, Victor Garcia > <mailto:vgarcia...@gmail.com>> wrote:
>> Hi all,
>> 
>> I have a question regarding the behaviour of ASSIGN activity type in program 
>> rules when the program has several stages.
>> 
>> Our context is a program with three stages (opening, consultation, closure). 
>> In analysis we want to show data from opening and closure stages in the same 
>> table. Since currently it is not possible to do this kind of analysis in 
>> Event Report, we have created some ASSIGN program rules to copy values from 
>> closure stage to opening stage so that we have all the information we need 
>> for analysis in the same stage.
>> 
>> In 2.25 we saw that it was possible to assign values to previous stages and 
>> we created a setup relying on this behaviour. But it seems to have changed 
>> in 2.26 and now the ASSIGN action only affects the "active" stage and does 
>> not create any value in previous or following stages...
>> 
>> Since this point is not explicitely detailed in the documentation, we would 
>> like to know what is the expected "inter-stage" behaviour of ASSIGN in order 
>> to think about an strategy that will work in current and future releases. 
>> And if there is a way 

Re: [Dhis2-devs] Expected "inter-stage" behaviour of ASSIGN program rule action

[Markus Bekken]

Hi Victor,
Sorry for the delayed response. 

The ASSIGN rules is only intended to affect the data that the user sees(the 
active/current event). This usually means that you can create helper fields, 
but they rely on the basis for your calculations being in the same event, or in 
previously registered data. The behavior you describe in 2.25 was not planned, 
and can be seen as a bug. 

There is two alternative options that can be pursued:
- Try creating a program indicator with analytics type "Enrollment"(introduced 
in 2.26). This will allow you to compare data from the latest event in each 
program stage across entire enrollments. Possibly this can take away the need 
for the helper fields.
- Make a helper field in second program stage, and make an assign rule that 
assigns "the other way". You will be able to query data from all other program 
stages when calculating and assigning values to helper fields.

Best regards,
Markus

> 22. mai 2017 kl. 16.32 skrev Victor Garcia :
> 
> Hi all,
> 
> does anyone have any insight about this issue? It is fundamental to 
> understand the behaviour of ASSIGN program rules in order to design the 
> programs.
> 
> Thanks,
> 
> Víctor
> 
> On 15 May 2017 at 17:26, Victor Garcia  > wrote:
> Hi all,
> 
> I have a question regarding the behaviour of ASSIGN activity type in program 
> rules when the program has several stages.
> 
> Our context is a program with three stages (opening, consultation, closure). 
> In analysis we want to show data from opening and closure stages in the same 
> table. Since currently it is not possible to do this kind of analysis in 
> Event Report, we have created some ASSIGN program rules to copy values from 
> closure stage to opening stage so that we have all the information we need 
> for analysis in the same stage.
> 
> In 2.25 we saw that it was possible to assign values to previous stages and 
> we created a setup relying on this behaviour. But it seems to have changed in 
> 2.26 and now the ASSIGN action only affects the "active" stage and does not 
> create any value in previous or following stages...
> 
> Since this point is not explicitely detailed in the documentation, we would 
> like to know what is the expected "inter-stage" behaviour of ASSIGN in order 
> to think about an strategy that will work in current and future releases. And 
> if there is a way to do this kind of assignments in 2.26.
> 
> Thank you a lot,
> 
> Víctor
> 
> ___
> 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] Create Program indicator to sum DE across events

[Markus Bekken]

Hi there Joao,
At the moment this is not possible to do within standard DHIS2 functionality. 
We are working on a change that might enable this kind of calculation, but this 
is not detailed and planned to a specific release yet.

It would be possible to make a custom SQL view that retrieves this. This option 
is a bit more advanced.

Best regards,
Markus

> 22. mai 2017 kl. 10.03 skrev Joao Machiana :
> 
> Hi community members
> 
> ​I'm creating a Tracker form, which has 2 stages: one is non-repeatable and 
> the other one is repeatable
> 
> I need to create an Indicator that takes data from a DE from the 
> non-repeatable stage and subtracts the sum of a particular DE from the 
> repeatable stages (all events). Something like this:
> 
> Indicator = {NonRepatableStage.DataElement1} - 
> SUM{RepeatableStage.DataElement2}
> 
> What I'm getting is the Indicator takes the value of the last event, but I 
> actually want the sum of the values of a particular DE of the events 
> (repeatable stages)
> 
> 
> Best regards
> 
> 
> -- 
> João X. Machiana
> Systems Analyst and Programmer
> ___
> 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

Re: [Dhis2-devs] Aggregation type for Tracker Data Elements

[Markus Bekken]

Hi!
Which version of Dhis are you using? Can you reproduce on play.dhis2.org?

Markus

> 16. mai 2017 kl. 20.44 skrev Lorill Crees :
> 
> Hi,
> 
> We have program stage data elements of type integer for year and for month 
> that show up as sums when visualizing in the pivot table. I see that going in 
> to edit the Data Elements, that changing the Aggregation Type is disabled for 
> Data Elements of type Tracker. 
> 
> How can we change the aggregation type to be average, so the year and month 
> will show up properly in the pivot table instead of summed?
> 
> Thanks,
> 
> Lorill
> 
> -- 
> Lorill Crees
> Project Leader / Senior Developer
> 2Paths Solutions Ltd. 
> 
> lcr...@2paths.com 
> skype: lorill2paths
> (604) 689-4123 x 15
> ___
> 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] Error creation new stage on 2.26

[Markus Bekken]

Hi There Pepe,
Are you able to reproduce this issue on the demo server? 
https://play.dhis2.org/demo/

How are you adding the event? The error message you are getting seems to 
indicate that you are trying to create more than one event in non-repeatable 
program stage. This should not be possible in the Tracker Capture user 
Interface, as the Tracker should make sure only one event is added in 
non-repeatable program stages.

Markus 


> 15. mai 2017 kl. 23.23 skrev Pepe Ken Mvulu :
> 
> Hi Dev team,
> I use version 2.26 of the DHIS2. Build 1c9a347
> I use a Tracker program with multiple events. When I want to add a new 
> "Stage", I get this error message.
> Error
> 
> Error in event creation
> One more conflicts encountered, please check import summary.
> 
> Response from the server.
> 
> [{"responseType":"ImportSummary","status":"ERROR","importOptions":{"idSchemes":{},"dryRun":false,"async":false,"importStrategy":"CREATE","mergeMode":"REPLACE","skipExistingCheck":false,"sharing":false,"skipNotifications":false,"datasetAllowsPeriods":false,"strictPeriods":false,"strictCategoryOptionCombos":false,"strictAttributeOptionCombos":false,"strictOrganisationUnits":false,"requireCategoryOptionCombo":false,"requireAttributeOptionCombo":false},"description":"Program
>  stage is not repeatable and an event already 
> exists","importCount":{"imported":0,"updated":0,"ignored":1,"deleted":0}}]
> 
> Does anyone have an idea to help?
> Regards 
>  
> Pepe Ken Mvulu
> Responsable M&E
> Programme Village Assaini
> Direction de l'Hygiène
> Ministère de la Santé Publique/RDC
> Tél: +243 811515878
> Skype: pepe.ken.mvulu
> ___
> 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] d2:validatePattern

[Markus Bekken]

Hi Simon.
The expression below seems all correct. Tested the same in 2.27 snapshot and it 
works. Which version are you on? Do you have other rules working for the same 
variable A{index_id}?

Markus

> 12. mai 2017 kl. 09.28 skrev simon mugisa :
> 
> Hi there evryone,
> 
> has anybody out there been succesful with the d2:validatePattern pattern 
> program rule,
> i impliment it by:   !d2:validatePattern(A{index_id} ,'\\d{6}\/\\d{2}\/\\d')  
> which i coppied from the dhis2 user guide and added my own A{} but i get this 
> error:
> d2:validatePattern was called with the incorrect number of parameters
> 
> my question is how many parameters are required. if they are two can someone 
> give the right format for this.
>  
>  
> Simon Robert Kununka
> DHIS2 implimentor, Analyst and Consultant
> 
> Uganda-Kampala
> Direct: + 256-777-108-323
> E-mail: nomisrmug...@gmail.com 
> 
> 
> "Don't wish it was easier, wish you were better. Don't wish for less 
> problems, wish for more skills. Don't wish for less change , wish for more 
> wisdom."
> 
> This message and its attachments are confidential and solely for the intended 
> recipients. If received in error, please delete them and notify the sender 
> via reply e-mail immediately.
> 
> 
> 
> 
> ___
> 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

Re: [Dhis2-devs] How do filters work in Enrolment program indicators?

[Markus Bekken]

Hi Sam,

your suspicion is correct. In Enrollment program indicators you will always 
evaluate the newest value for each of the data elements within repeatable 
program stages - both for filters and expression. This means that for your use 
case you will have to use the event analyticstype.

I think you can acheive what you seek here by making the following program 
indicator:
AnalyticsType: Event
Aggregation type: Count
Expression: Enrollment count
Filter: Event macthing the test result

This program indicator will first find all events that matches the filter 
criteria, then make sure to count only how many distinct enrollments that is 
represented in this population of events. 

Markus

> 8. mai 2017 kl. 12.09 skrev Sam Johnson :
> 
> Hi devs,
>  
> Just a quick question around the operation of the enrolment indicators.  I’m 
> trying to do a program indicator which searches a repeatable program stage to 
> see if one or more events include a specific data value (a test result).  The 
> catch is that the data value could be in any event, and may even appear 
> multiple times, but I only want to count each enrolment once, regardless of 
> the number of test results.
>  
> I’ve tried using an ‘enrolment’ program indicator with a filter that ensures 
> only events which include my data value are included in the indicator 
> calculation; however, this doesn’t seem to be working as I expected, and the 
> entire enrolment is often being filtered out, even though it contains a 
> positive test result.
>  
> So I’d be grateful if you could clarify when the filter is applied for 
> ‘enrolment’ program indicators:
> · Is it applied at the event level, before the enrolment record takes 
> the ‘latest’ event for each program stage (so I can filter the events that 
> are used to calculate the ‘latest’ event for each enrolment?)
> · Or for Enrolment PIs is it actually an enrolment rather than an 
> event filter, ie it’s applied after the ‘latest’ event has been pulled for 
> each program stage (so the filter is only applied to the ‘latest’ events, not 
> all events)?
>  
> I think the former would be more powerful, but if it’s the latter (which I 
> suspect), is there another way of counting the number of enrolments that have 
> had a particular value recorded during any one of a number of repeatable 
> events?
>  
> Many thanks in advance for any help/thoughts you can share!
>  
> Cheers, Sam.
>  
> ___
> 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] Bug - cannot schedule events in Tracker Capture

[Markus Bekken]

Hi Sam,
for the first part on event scheduling is fixed now. A bad version(without the 
schedule fix) was published inadvertently.

For the generation of the next visit, there seems to be a flag confusion here. 
There is two flags in the program stage config - one called "Display generate 
event box after completed" and another one called "Ask user to create new event 
when stage is complete".

For the moment the tracker only regards the last one - so if you check "Ask 
user to create new event when stage is complete" it should work.

We will clean this up as part of DHIS2-1507, but then you have a workaround. 

Markus

> 1. mai 2017 kl. 13.51 skrev Sam Johnson :
> 
> Hi Markus,
>  
> Although I tested your fix for this when it was released, and it worked well 
> in update 9a5f6d0 (25 April), this bug appears to have returned in the latest 
> update 2e93869 (1 May) of 2.26.  What’s odd is that I can’t see any commits 
> to the origin/v26 branch of tracker-capture-app since you made that change on 
> 25 April – is this now possibly a build error, or perhaps an underlying API 
> issue?
>  
> This bug is very straightforward to reproduce – just use the calendar icon to 
> schedule an event, and it instead creates the event. I’ve updated the 
> existing Jira issue (DHIS2-1438 <https://jira.dhis2.org/browse/DHIS2-1438>) 
> with a comment – would it be possible to also re-open this issue?
>  
> Another bug also appears to have been introduced in both versions: the 
> ‘Display generate event box after completed’ option no longer seems to be 
> working.  This should (for repeatable program stages) prompt the user to 
> schedule a future event at the appropriate interval – but now nothing happens 
> at all.  (You can replicate this on Play Demo in the RMNCH Tracker, by first 
> setting the ‘standard interval days’ of the ‘Antenatal care visit’ program 
> stage, then creating an event and ‘completing’ it – it fails to prompt you to 
> schedule a follow-up ‘Antenatal care visit’.)  I’ve logged this as DHIS2-1507 
> <https://jira.dhis2.org/browse/DHIS2-1507>.
>  
> I’d be very grateful if you’re able to find time to look at this again, as 
> these two bugs have once again broken the Tracker in 2.26.
>  
> Many thanks, Sam.
>  
>  
> From: Markus Bekken 
> Date: Tuesday, 25 April 2017 at 23:21
> To: Sam Johnson 
> Cc: DHIS2 Developers , "absolo...@yahoo.com" 
> , Immaculate Ayebazibwe 
> Subject: Re: [Dhis2-devs] Bug - cannot schedule events in Tracker Capture
>  
> Hey Sam! 
> Thanks for pushing this up the priority list. It was a relatively small fix, 
> new versions of 2.26 and 2.27 snapshot are ready to download.
>  
> Best regards,
> Markus
>  
> 25. apr. 2017 kl. 17.35 skrev Sam Johnson  <mailto:samuel.john...@qebo.co.uk>>:
>  
> Hi devs,
>  
> Just following up on the bug below (DHIS2-1438 
> <https://jira.dhis2.org/browse/DHIS2-1438>).  I realize Abyot is on leave 
> (congratulations! J), but this ticket is still assigned to him – is there 
> anyone else who might be able to pick this up?
>  
> This bug is quite urgent, as it has effectively crippled the Tracker in 2.26. 
>  But I’m guessing that’s it’s just a case of the wrong code being fired, so 
> should hopefully be fairly simple to fix?
>  
> Cheers, Sam.
>  
>  
> From: Dhis2-devs 
>  <mailto:dhis2-devs-bounces+samuel.johnson=qebo.co...@lists.launchpad.net>> on 
> behalf of Sam Johnson  <mailto:samuel.john...@qebo.co.uk>>
> Date: Tuesday, 18 April 2017 at 19:55
> To: Abyot Asalefew Gizaw mailto:ab...@dhis2.org>>, DHIS2 
> Developers  <mailto:dhis2-devs@lists.launchpad.net>>
> Cc: "absolo...@yahoo.com <mailto:absolo...@yahoo.com>"  <mailto:absolo...@yahoo.com>>, Immaculate Ayebazibwe  <mailto:ekass...@gmail.com>>
> Subject: [Dhis2-devs] Bug - cannot schedule events in Tracker Capture
>  
> This sender failed our fraud detection checks and may not be who they appear 
> to be. Learn about spoofing <http://aka.ms/LearnAboutSpoofing>   
> Feedback <http://aka.ms/SafetyTipsFeedback>
> Hi Abyot,
>  
> I’ve come across what looks like a new bug introduced into Tracker Capture in 
> 2.26 – I don’t seem to be able toschedule events.  Although I’ve not used 
> periods in my Tracker programs, I’m wondering if the fix discussed in the 
> thread below has triggered this new bug?
>  
> In 2.26, both the calendar icon and the ‘ask user to create new event when 
> stage is complete’ option now generate an open event instead of a scheduled 
> event.  (In 2.25, both of these correctly create a scheduled event instead of 
> an open event.)  Note that the one thing that still wor

Re: [Dhis2-devs] [Dhis2-users] Enter data for a future date in Event and Tracker Capture

[Markus Bekken]

Hi again Georgi.

We have this Jira issue that would probably help you show the data you want in 
the reporting module if you remodeled your data, but it is planned for a later 
release - so perhaps no good to you now: DHIS2-127 
<https://jira.dhis2.org/browse/DHIS2-127>

Lifting the restriction on registering future event dates is a possibility. The 
restriction only applies in the UI at the moment, the back-end supports future 
event dates. If you create an improvement issue for this in Jira we can discuss 
it there. If we allow it for all programs, the user should probably get a 
visual cue that the event date is in the future to minimize accidental wrong 
dates.

For your second question I honestly dont see why the periods should be within 
the same year as the enrollment. Please register this part as a bug in Jira.

Markus

> 26. apr. 2017 kl. 09.50 skrev Georgi Chakarov :
> 
> Hi Markus,
>  
> I thought about it but then it will be really hard in reporting module to the 
> display the data for the desired period.
>  
> Are you able to comment on the below?:
>  
> When selecting monthly, six-monthly, yearly period for repeatable program 
> stages you can't create a stage for a year different than the year of 
> enrollment.
>  
> Example
>  
> Program stage is six-monthly
>  
> 
>  
>  
> Enrollment date is in 2015
>  
> 
>  
> Current date is 2017
>  
> 
>  
> DHIS2 does not allow to create a six-monthly stages for 2016. Note how the 
> arrow used to go to next period (2016) is inactive. The only possible options 
> are the two six-monthly periods in 2015. 2014 is not active either.
>  
> 
>  
>  
>  
> From: Markus Bekken [mailto:mar...@dhis2.org] 
> Sent: Wednesday, April 26, 2017 10:47 AM
> To: Georgi Chakarov 
> Cc: Shurajit Dutta ; 
> dhis2-us...@lists.launchpad.net; dhis2-devs@lists.launchpad.net
> Subject: Re: [Dhis2-users] Enter data for a future date in Event and Tracker 
> Capture
>  
> Hi Georgi and Nick
>  
> The tracker does not allow allow event dates in the future. This restriction 
> is probably there because most(all so far?) tracker use cases register actual 
> events that already has happened. Knowing nothing about your usecase: Can you 
> model it slightly differently, capturing the future date a data element 
> instead of the event date?
>  
> Markus
>  
>  
>  
>  
>  
>  
> 26. apr. 2017 kl. 09.29 skrev Georgi Chakarov  <mailto:geo...@logicaloutcomes.net>>:
>  
> Hi Nick,
>  
> Thanks for your response!
>  
> See my comments below.
>  
> Regards,
>  
> Georgi
>  
> From: Shurajit Dutta [mailto:shurajitdu...@gmail.com 
> <mailto:shurajitdu...@gmail.com>] 
> Sent: Wednesday, April 26, 2017 6:02 AM
> To: Georgi Chakarov  <mailto:geo...@logicaloutcomes.net>>
> Cc: dhis2-us...@lists.launchpad.net <mailto:dhis2-us...@lists.launchpad.net>; 
> dhis2-devs@lists.launchpad.net <mailto:dhis2-devs@lists.launchpad.net>
> Subject: Re: [Dhis2-users] Enter data for a future date in Event and Tracker 
> Capture
>  
> Hi Georgi,
>  
> 1. You can select "Date in future" for attributes/data elements within a 
> program to enter future dates
>  
> 
>  
> I need program stage date/Event reporting date to be future dates. You know 
> how in Data Entry app you can allow for entering data in the future, so from 
> the period drop-down you can select to enter data for 2018 for example, 
> regardless that it is 2017 now. I need the same for Events and Tracker 
> capture stages.
>  
>  
> 2. Does the use of program indicators not solve this issue? You could select 
> those months as the period of interest during analysis.
>  
> The problem here is that the program indicators do not calculate properly. 
> Let me give you an example. My period is May, 1 2016 – April, 30 2017 (this 
> is Fiscal year 2017). I have been entering data for one Tracker program from 
> May,1 to April, 30 daily. I have built a program indicator of interest. When 
> I go to reporting I want to see ONE number, which is the sum/average/other 
> calculation of all months from May 2016 to April 2017. So, I select all these 
> months and put them in the reporting filter (I do not want them in 
> dimension). The reporting module fails to calculate the data properly for 
> these months, because they are in two different years.
> This problem is related to other malfunction in tracker:
>  
> When selecting monthly, six-monthly, yearly period for repeatable program 
> stages you can't create a stage for a year different than the year of 
> enrollment.
>  
> Example
>  
> Program stage is six-monthly
>  
> 
>  
>  
> Enrollment d

Re: [Dhis2-devs] [Dhis2-users] Auto-Generated Client UICs in Tracker v2.25

[Markus Bekken]

Also, you can vote for this issue, and add your specific requirements in the 
comments: 
https://jira.dhis2.org/browse/DHIS2-434


> 25. apr. 2017 kl. 17.49 skrev Em Le Hong :
> 
> You can use script on custom form. Until now, there's no way for default form 
> to generate based on tracked entity attributes.
> 
> On Tue, Apr 25, 2017 at 5:48 PM, Brian O'Donnell  > wrote:
> Hi all,
> 
> I'm curious if anyone has experience in auto-generating Unique Identifier 
> Codes (UICs) in tracker capture module (v2.25 or below), or if there is a 
> best practices document out there.
> 
> We are capturing sensitive information about clients through android tracker. 
> The service provider would like to capture name and phone number data, but 
> restrict viewing of these data to higher-level users. Data entry roles should 
> only be able to search based on a system-generated UIC. You should be able to 
> construct and re-construct UICs based on client data, as in the diagram from 
> PSI below.
> 
> 
> So we do not need a randomly generated ID for the tracked entity, but a 
> script which constructs a custom string attribute based on other tracked 
> entity attributes, similar to this app, but built directly into DHIS2 form: 
> https://play.google.com/store/apps/details?id=org.eyeseetea.uicapp&hl=en 
> 
> 
> I am not the only one who has requested this 
> (https://lists.launchpad.net/dhis2-devs/msg47211.html 
> ) but I cannot find a 
> manual or correspondence online. Happy to provide more details on use case on 
> request.
> 
> Brian
> -- 
>    Brian O'Donnell, MPAff
> Informatics Project Manager
> bodonn...@akros.com  
> 
> ___
> 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 
> 
> 
> 
> 
> 
> -- 
> Em Le Hong
> DHIS2 Implementation| HISP Vietnam 
> em.hispviet...@gmail.com  | Skype: 
> em.hispviet...@gmail.com 
> 
> 
> 
> 
> 
> ___
> 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

Re: [Dhis2-devs] [Dhis2-users] Enter data for a future date in Event and Tracker Capture

[Markus Bekken]

Hi Georgi and Nick

The tracker does not allow allow event dates in the future. This restriction is 
probably there because most(all so far?) tracker use cases register actual 
events that already has happened. Knowing nothing about your usecase: Can you 
model it slightly differently, capturing the future date a data element instead 
of the event date?

Markus






> 26. apr. 2017 kl. 09.29 skrev Georgi Chakarov :
> 
> Hi Nick,
>  
> Thanks for your response!
>  
> See my comments below.
>  
> Regards,
>  
> Georgi
>  
> From: Shurajit Dutta [mailto:shurajitdu...@gmail.com 
> ] 
> Sent: Wednesday, April 26, 2017 6:02 AM
> To: Georgi Chakarov  >
> Cc: dhis2-us...@lists.launchpad.net ; 
> dhis2-devs@lists.launchpad.net 
> Subject: Re: [Dhis2-users] Enter data for a future date in Event and Tracker 
> Capture
>  
> Hi Georgi,
>  
> 1. You can select "Date in future" for attributes/data elements within a 
> program to enter future dates
>  
> 
>  
> I need program stage date/Event reporting date to be future dates. You know 
> how in Data Entry app you can allow for entering data in the future, so from 
> the period drop-down you can select to enter data for 2018 for example, 
> regardless that it is 2017 now. I need the same for Events and Tracker 
> capture stages.
>  
>  
> 2. Does the use of program indicators not solve this issue? You could select 
> those months as the period of interest during analysis.
>  
> The problem here is that the program indicators do not calculate properly. 
> Let me give you an example. My period is May, 1 2016 – April, 30 2017 (this 
> is Fiscal year 2017). I have been entering data for one Tracker program from 
> May,1 to April, 30 daily. I have built a program indicator of interest. When 
> I go to reporting I want to see ONE number, which is the sum/average/other 
> calculation of all months from May 2016 to April 2017. So, I select all these 
> months and put them in the reporting filter (I do not want them in 
> dimension). The reporting module fails to calculate the data properly for 
> these months, because they are in two different years.
> This problem is related to other malfunction in tracker:
>  
> When selecting monthly, six-monthly, yearly period for repeatable program 
> stages you can't create a stage for a year different than the year of 
> enrollment.
>  
> Example
>  
> Program stage is six-monthly
>  
> 
>  
>  
> Enrollment date is in 2015
>  
> 
>  
> Current date is 2017
>  
> 
>  
> DHIS2 does not allow to create a six-monthly stages for 2016. Note how the 
> arrow used to go to next period (2016) is inactive. The only possible options 
> are the two six-monthly periods in 2015. 2014 is not active either.
>  
> 
>  
>  
>  
> Nick
>  
> On Tue, Apr 25, 2017 at 9:53 PM, Georgi Chakarov  > wrote:
> Hello DHIS2 users and devs!
>  
> I have two questions:
> 1)  Is there a way to enter data for a future date in Event and Tracker 
> capture? The latest date that could be selected in these two apps at data 
> entry is the current date.
> 
>  
> 
> 2)  Has someone worked with project periods that are outside of the 
> available periods in DHIS2? I have a client that uses Fiscal Year May, 1 – 
> April, 30 and this is causing a real trouble at data entry as well as 
> reporting.
> 
> For example, the period from May, 1 2015 – April, 30 2016 is defined as 
> Fiscal Year 2016. Data is entered daily in Event and Tracker Capture. How do 
> we enter data so that we fall under this specific reporting period and how do 
> we report an aggregate number for the entire 2016 Fiscal Year?
> 
> [Not to mention that TRACKER DOES NOT correctly aggregate reports when 
> selecting two different years and setting them as report filter in the 
> reports layout, which is an option to display one aggregate number for 2 
> years.]
> 
>  
> 
>  
> Your input is highly appreciated and awaited!
>  
> Thanks,
>  
> Georgi
>  
>   
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net 
>  | +1-647-478-5634 x 104 
>  | LogicalOutcomes c/o Centre for Social Innovation, 
> 720 Bathurst Street, Toronto Canada M5S 2R4 | You may unsubscribe from 
> receiving commercial electronic messages from LogicalOutcomes by emailing 
> i...@logicaloutcomes.net 
>  
> 
> ___
> 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 
> 
> 
> 
>  
> -- 
> Shurajit Dutta
> Health Information Consultant
> ___

Re: [Dhis2-devs] Bug - cannot schedule events in Tracker Capture

[Markus Bekken]

Hey Sam!
Thanks for pushing this up the priority list. It was a relatively small fix, 
new versions of 2.26 and 2.27 snapshot are ready to download.

Best regards,
Markus

> 25. apr. 2017 kl. 17.35 skrev Sam Johnson :
> 
> Hi devs,
>  
> Just following up on the bug below (DHIS2-1438 
> ).  I realize Abyot is on leave 
> (congratulations! J), but this ticket is still assigned to him – is there 
> anyone else who might be able to pick this up?
>  
> This bug is quite urgent, as it has effectively crippled the Tracker in 2.26. 
>  But I’m guessing that’s it’s just a case of the wrong code being fired, so 
> should hopefully be fairly simple to fix?
>  
> Cheers, Sam.
>  
>  
> From: Dhis2-devs 
>  > on 
> behalf of Sam Johnson  >
> Date: Tuesday, 18 April 2017 at 19:55
> To: Abyot Asalefew Gizaw mailto:ab...@dhis2.org>>, DHIS2 
> Developers  >
> Cc: "absolo...@yahoo.com "  >, Immaculate Ayebazibwe  >
> Subject: [Dhis2-devs] Bug - cannot schedule events in Tracker Capture
>  
> This sender failed our fraud detection checks and may not be who they appear 
> to be. Learn about spoofing    
> Feedback 
> Hi Abyot,
>  
> I’ve come across what looks like a new bug introduced into Tracker Capture in 
> 2.26 – I don’t seem to be able toschedule events.  Although I’ve not used 
> periods in my Tracker programs, I’m wondering if the fix discussed in the 
> thread below has triggered this new bug?
>  
> In 2.26, both the calendar icon and the ‘ask user to create new event when 
> stage is complete’ option now generate an open event instead of a scheduled 
> event.  (In 2.25, both of these correctly create a scheduled event instead of 
> an open event.)  Note that the one thing that still works fine is if the 
> booking is auto-generated on enrolment – this still schedules rather than 
> creates the event.)
>  
> To reproduce this in the Play demo website:
> 1.  Open Tracker Capture, select Ngelehun CHC, and register a new patient 
> for the WHO RMNCH Tracker (first visit = 2017-01-01).
> 2.  Complete the ‘First antenatal care visit’, which triggers a prompt to 
> ‘Schedule new event for stage Antenatal care visit’ – a new ‘open’ visit is 
> created instead of a scheduled visit (a future ‘open’ event shouldn’t be 
> possible!).
> 3.  Use the ‘+’ icon to create a new event for 2017-02-01 – a new ‘open’ 
> visit is correctly created.
> 4.  Use the calendar icon to schedule a new event (booking) for 
> 2017-03-01 – a new ‘open’ visit is created, instead of a scheduled visit.
>  
> I’ve reported this as https://jira.dhis2.org/browse/DHIS2-1438.  This is an 
> extremely important bug, as users in other facilities can only update 
> scheduled events (bookings) – so this bug also breaks the awesomely useful 
> feature you restored in https://jira.dhis2.org/browse/DHIS2-623.
>  
> Cheers, Sam.
>  
>  
> From: Dhis2-users 
>  on behalf 
> of Absolom MURAMIRA 
> Reply-To: "absolo...@yahoo.com" 
> Date: Thursday, 2 March 2017 at 20:03
> To: Abyot Asalefew Gizaw , Immaculate Ayebazibwe 
> 
> Cc: DHIS Users , DHIS2 Developers 
> 
> Subject: Re: [Dhis2-users] [Dhis2-devs] Fw: Tracker Events period issue
>  
> Dear Abyot,  
>  
> Thank you for the update. We also look forward for the periodic fix. 
>  
> Absolom 
>  
> Sent from Yahoo Mail on Android 
> 
>  
> On Thu, 2 Mar 2017 at 11:34, Abyot Asalefew Gizaw
>  wrote:
> Hi, 
>  
> We have now made a limited fix in 2.26.
>  
> Here is what is supported at the moment:
>  
> - scheduling periodic events is not supported at the moment
> - creation of events is possible
> - once created, editing the event's period is not possible
> - normally we store, the end date of the period as event date
> 
> --
> Abyot A. Gizaw.
> Senior Engineer, DHIS2
> University of Oslo
> http://www.dhis2.org 
>  
> On Tue, Feb 28, 2017 at 3:09 PM, Abyot Asalefew Gizaw > 
> wrote:
> sorry the other way round - the calendar icon not the plus icon!
> 
> --
> Abyot A. Gizaw.
> Senior Engineer, DHIS2
> University of Oslo
> http://www.dhis2.org 
>  
> On Tue, Feb 28, 2017 at 3:09 PM, Abyot Asalefew Gizaw > 
> wrote:
> You need to click the plus icon not the calendar icon
>  
> 
> 
> --
> Abyot A. Gizaw.
> Senior Engineer, DHIS2
> University of Oslo
> http://www.dhis2.org 
>  
> On Tue, Feb 28, 2017 at 2:27 PM, Immaculate Ayebazibwe  <>> wrote:
> Hi Abyot, 
>  
> Based on your explanation, even when you use only date, it will not go beyond 
> a given year.
> For example it will show only dates within 2017, or dates within 2016.
> 
>  
>  
> Thank yo

Re: [Dhis2-devs] Program indicator "hasValue"

[Markus Bekken]

Hey Olav,
if you're on 2.26 or later, d2:hasValue() should work: 
https://jira.dhis2.org/browse/DHIS2-1245 
<https://jira.dhis2.org/browse/DHIS2-1245>

Markus

> 24. apr. 2017 kl. 13.09 skrev Olav Poppe :
> 
> Hi, late follow-up on this - is there a «is empty» syntax for dates as well? 
> I get
> 
> ERROR: invalid input syntax for type timestamp: ‘'
> and
> ERROR: COALESCE types timestamp without time zone and integer cannot be 
> matched
> 
> if I use == ‘’ or == 0 respectively for dates.
> 
> Olav
> 
> 
> 
> 
> 
> 
>> 1. mar. 2017 kl. 15.24 skrev Markus Bekken > <mailto:mar...@dhis2.org>>:
>> 
>> Hi Olav,
>> the following syntax is now supported:  
>>> - #{wmSb9TmevMn.jeK5z6acB3N}  == ‘’
>> 
>> Jira issue: https://jira.dhis2.org/browse/DHIS2-1185 
>> <https://jira.dhis2.org/browse/DHIS2-1185>
>> 
>> Best regards,
>> Markus
>> 
>>> 1. feb. 2017 kl. 13.40 skrev Olav Poppe >> <mailto:olav.po...@me.com>>:
>>> 
>>> Hi devs, I’m trying (in 2.25) to make a program indicator counting events 
>>> where a specific data element has not been filled.
>>> 
>>> Tested so far: 
>>> - d2:hasValue(‘wmSb9TmevMn.jeK5z6acB3N’)=> not supported in 
>>> program indicators, only program rules
>>> - #{wmSb9TmevMn.jeK5z6acB3N}  == ‘’ => no data 
>>> - #{wmSb9TmevMn.jeK5z6acB3N}  != ‘’ => counts the 
>>> events WITH data, but I’m unable to «invert» this:
>>> -- !(#{wmSb9TmevMn.jeK5z6acB3N}  != ‘’) => no data, 
>>> catalina.out shows: ERROR: operator does not exist: ! boolean
>>> -- (#{wmSb9TmevMn.jeK5z6acB3N}  != '') != true  => no data
>>> - #{wmSb9TmevMn.jeK5z6acB3N}  is null   => works, but 
>>> is not a supported format from what I understand.
>>> 
>>> In general, what is displayed in «Filter description» and what actually 
>>> works is not consistent - some things are invalid, but work, others are 
>>> valid but don’t work…
>>> 
>>> Any advice?
>>> 
>>> Regards
>>> Olav
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs 
>>> <https://launchpad.net/~dhis2-devs>
>>> Post to : dhis2-devs@lists.launchpad.net 
>>> <mailto:dhis2-devs@lists.launchpad.net>
>>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>>> <https://launchpad.net/~dhis2-devs>
>>> More help   : https://help.launchpad.net/ListHelp 
>>> <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] Aggregating events based on last value of the data element

[Markus Bekken]

Dear Chathura and Pamod, 
Unfortunately, evaluating indicators using what would have been the latest 
value within every enrollment at a given time is not supported. We could make a 
program indicator that does the base calculation you want, but it will 
currently only reflect the disease situation as of the time of aggregation.

Please feel free to write up a JIRA improvement suggestion to support this.

Best regards
Markus

> 10. apr. 2017 kl. 16.17 skrev chathura widanage :
> 
> Hi Markus,
> 
> Thanks for the response.  Based on the scenario described above, we want to 
> draw a trend chart which is similar to the one in attached png. 
> 
> So basically, given a date, api should consider the latest event(upto given 
> date) of each entity when aggregating.
> 
> Thanks
> 
> On 10 Apr 2017 7:41 p.m., "Pamod Amarakoon"  <mailto:pam...@gmail.com>> wrote:
> Forgot to add we also need to consider the fact that B gets positive for the 
> disease again in May 2017 where we enroll him again and the total becomes 6 
> again.
> 
> Thanx.
> 
> On Mon, Apr 10, 2017 at 6:06 PM, Pamod Amarakoon  <mailto:pam...@gmail.com>> wrote:
> Dear Markus,
> 
> If I elaborate more, suppose there are 6 children A,B,C,D,E and F.
> A, B, and C are enrolled to the program in July 2016 being positive for the 
> disease X (yes/no DE)
> D,E gets enrolled to programme in August 2016 also being positive for X
> F gets enrolled in September 2016 being positive for X.
> 
> All the 6 children are being monthly followed up to assess the existence of 
> the Disease X.
> 
> B gets cured of disease X in January 2017and enrollment gets completed.
> D is lost to follow up from October 2016.
> A, C, E and F are being followed up till  now and all positive for Disease X.
> Although children D has not turned up at clinic we still consider him as 
> positive for Disease X.
> 
> So what I'm interested is to develop a table or trend chart (line chart) for 
> prevalence (old+new) of Disease X in the given community. Should be something 
> like below
> 
> July 2016 - 3
> August 2016 - 5
> September 2016 - 6
> October 2016 - 6
> November 2016 - 6
> December 2016 - 6
> January 2017 - 5
> February 2017 - 5
> March 2017 - 5
> April 2017 - 5
> 
> Is it possible to get this output using a program indicator.
> 
> Thank you.
> 
> On Mon, Apr 10, 2017 at 5:53 PM, Markus Bekken  <mailto:mar...@dhis2.org>> wrote:
> Dear Pamod,
> to put it simply - if you use October 2016 as reporting date and display this 
> enrollment program indicator, the pivot will be populated only with the data 
> for the children enrolled in October 2016. The child enrolled in October will 
> not show up un the numbers for November. If you want to make a report of all 
> currently positive children, you would have to define a long enough reporting 
> period to capture all enrollment dates, and filter out anyone not positive.
> 
> As a reminder there is a planned improvement to allow other dates to be the 
> basis of aggregation: DHIS2-1398 <https://jira.dhis2.org/browse/DHIS2-1398>
> 
> Curious to hear how this covers your use case. 
> 
> Markus
> 
>> 10. apr. 2017 kl. 13.37 skrev Pamod Amarakoon > <mailto:pam...@gmail.com>>:
>> 
>> Dear Marcus,
>> 
>> Want to clarify something. 
>> 
>> Suppose for example Child A has been marked positive for a disease in 
>> October 2016 and he has not turned up for further clinic followups. If we 
>> configure the program indicator the way you mentioned and select period 
>> dimension as last 12 months from pivot table and consider the output, we are 
>> interested in obtaining the cross sectional view of number of affected 
>> children at a given time.
>> 
>> Will the child A only be calculated for the month of October 2016 or will he 
>> be counted on subsequent months as well. (In the output we are expecting to 
>> see the prevalence of the disease per month).
>> 
>> Thank you
>> 
>> On Mon, Apr 10, 2017 at 2:47 PM, Markus Bekken > <mailto:mar...@dhis2.org>> wrote:
>> Hi there Chathura,
>> 
>> it seems that the query you want to make below can be achieved with 
>> enrollment program indicators. Assuming the program is built as a multiple 
>> event with registration, and the DE1 is part of a repeating program stage, 
>> the inherent properties of enrollment program indicators covers much of what 
>> you want. Each child will be counted only once, and only the latest value of 
>> D1 will be considered for each child.
>> 
>> Can you for example try making a program indicator with analytics type 
&g

Re: [Dhis2-devs] Aggregating events based on last value of the data element

[Markus Bekken]

Dear Pamod,
to put it simply - if you use October 2016 as reporting date and display this 
enrollment program indicator, the pivot will be populated only with the data 
for the children enrolled in October 2016. The child enrolled in October will 
not show up un the numbers for November. If you want to make a report of all 
currently positive children, you would have to define a long enough reporting 
period to capture all enrollment dates, and filter out anyone not positive.

As a reminder there is a planned improvement to allow other dates to be the 
basis of aggregation: DHIS2-1398 <https://jira.dhis2.org/browse/DHIS2-1398>

Curious to hear how this covers your use case. 

Markus

> 10. apr. 2017 kl. 13.37 skrev Pamod Amarakoon :
> 
> Dear Marcus,
> 
> Want to clarify something. 
> 
> Suppose for example Child A has been marked positive for a disease in October 
> 2016 and he has not turned up for further clinic followups. If we configure 
> the program indicator the way you mentioned and select period dimension as 
> last 12 months from pivot table and consider the output, we are interested in 
> obtaining the cross sectional view of number of affected children at a given 
> time.
> 
> Will the child A only be calculated for the month of October 2016 or will he 
> be counted on subsequent months as well. (In the output we are expecting to 
> see the prevalence of the disease per month).
> 
> Thank you
> 
> On Mon, Apr 10, 2017 at 2:47 PM, Markus Bekken  <mailto:mar...@dhis2.org>> wrote:
> Hi there Chathura,
> 
> it seems that the query you want to make below can be achieved with 
> enrollment program indicators. Assuming the program is built as a multiple 
> event with registration, and the DE1 is part of a repeating program stage, 
> the inherent properties of enrollment program indicators covers much of what 
> you want. Each child will be counted only once, and only the latest value of 
> D1 will be considered for each child.
> 
> Can you for example try making a program indicator with analytics type 
> "Enrollment", aggregation type "Sum" and the expression being the value of 
> DE1? Then you can use pivot or the API to query and see if the results match 
> your expectation.
> 
> Markus
> 
>> 1. apr. 2017 kl. 10.58 skrev chathura widanage > <mailto:chathurawidan...@gmail.com>>:
>> 
>> Hi,
>> 
>> We are currently using DHIS2 to track nutrition problems of children under 5 
>> years.
>> 
>> Assume we have only two children in the database and DE1 be a certain 
>> condition that we monitor continuously,
>> 
>> child 1 -> [event 1, DE1=1, time=t1] [event 2 - DE1=1,time=t2] [event 3 - 
>> DE1=0,time=t3]
>> child 2 -> [event 1, DE1=0, time=t1] [event 2 - DE1=0,time=t2] [event 3 - 
>> DE1=0,time=t3]
>> 
>> Now if I call 
>> "events/aggregate/?dimension=DE1:EQ:1&startDate=T1&endDate=T2&dimension=ou:",
>>  is there a parameter that we can set in the query to consider only the last 
>> value of the data element in the chosen event series.
>> 
>> eg :
>> 
>> case
>> T1
>> T2
>> Result
>> Expected result
>> 1
>> t1
>> t1+delta
>> 1
>> 1
>> 2
>> t1
>> t2+delta
>> 2
>> 1
>> 3
>> t1
>> t3+delta
>> 2
>> 0
>> 4
>> t2
>> t3+delta
>> 1
>> 0
>> 
>> case 1 : child 1 has the condition (because DE1=1), hence result =1
>> case 2 : child 1 still has the condition, but we want to consider him only 
>> once.
>> case 3 : child 1 has got rid of the condition, so we don't want to consider 
>> him for the results
>> 
>> Why we need this :  we want to analyze the state of org unit during a 
>> specific period of time and draw a trend chart to determine whether measures 
>> taken to improve child health has actually worked or not.
>> 
>>  
>>  And also we need to compare the identified risk factors graphically, so we 
>> know which area should get the highest focus or attention.
>> 
>> 
>> 
>> Please let us know whether above results can be achieved using API version 
>> 2.26. 
>> Currently we are using SQL Views (2 SQL views + 1 Query) to generate above 
>> results, but that is extremely inefficient and expensive.
>> 
>> Thanks
>> 
>> 
>> 
>> -- 
>> Best Regards,
>> 
>> Chathura Widanage,
>> Undergraduate,
>> Department of Computer Science and Engineering,
>> University of Moratuwa,
>> Sri Lanka
>>  
>> <https://www.linkedin.com/profile/public-p

Re: [Dhis2-devs] Aggregating events based on last value of the data element

[Markus Bekken]

Hi there Chathura,

it seems that the query you want to make below can be achieved with enrollment 
program indicators. Assuming the program is built as a multiple event with 
registration, and the DE1 is part of a repeating program stage, the inherent 
properties of enrollment program indicators covers much of what you want. Each 
child will be counted only once, and only the latest value of D1 will be 
considered for each child.

Can you for example try making a program indicator with analytics type 
"Enrollment", aggregation type "Sum" and the expression being the value of DE1? 
Then you can use pivot or the API to query and see if the results match your 
expectation.

Markus

> 1. apr. 2017 kl. 10.58 skrev chathura widanage :
> 
> Hi,
> 
> We are currently using DHIS2 to track nutrition problems of children under 5 
> years.
> 
> Assume we have only two children in the database and DE1 be a certain 
> condition that we monitor continuously,
> 
> child 1 -> [event 1, DE1=1, time=t1] [event 2 - DE1=1,time=t2] [event 3 - 
> DE1=0,time=t3]
> child 2 -> [event 1, DE1=0, time=t1] [event 2 - DE1=0,time=t2] [event 3 - 
> DE1=0,time=t3]
> 
> Now if I call 
> "events/aggregate/?dimension=DE1:EQ:1&startDate=T1&endDate=T2&dimension=ou:",
>  is there a parameter that we can set in the query to consider only the last 
> value of the data element in the chosen event series.
> 
> eg :
> 
> case
> T1
> T2
> Result
> Expected result
> 1
> t1
> t1+delta
> 1
> 1
> 2
> t1
> t2+delta
> 2
> 1
> 3
> t1
> t3+delta
> 2
> 0
> 4
> t2
> t3+delta
> 1
> 0
> 
> case 1 : child 1 has the condition (because DE1=1), hence result =1
> case 2 : child 1 still has the condition, but we want to consider him only 
> once.
> case 3 : child 1 has got rid of the condition, so we don't want to consider 
> him for the results
> 
> Why we need this :  we want to analyze the state of org unit during a 
> specific period of time and draw a trend chart to determine whether measures 
> taken to improve child health has actually worked or not.
> 
>  
>  And also we need to compare the identified risk factors graphically, so we 
> know which area should get the highest focus or attention.
> 
> 
> 
> Please let us know whether above results can be achieved using API version 
> 2.26. 
> Currently we are using SQL Views (2 SQL views + 1 Query) to generate above 
> results, but that is extremely inefficient and expensive.
> 
> Thanks
> 
> 
> 
> -- 
> Best Regards,
> 
> Chathura Widanage,
> Undergraduate,
> Department of Computer Science and Engineering,
> University of Moratuwa,
> Sri Lanka
>  
> 
>     
>   
> ___
> 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] Analyze across events

[Markus Bekken]

Hi Pamod, 
When using enrollment program indicators, the enrollments being aggregated in 
your pivot will be the defined by the enrollment date entered during 
registration/enrollment. Meaning that asking for a report from 2016Q1 will give 
you data for all enrollments that started in this period. You would then be 
able to filter out the enrollments you want using a filter that queries the 
outcome or other data data from one or more program stages within the 
enrollment. The event date of the outcome data event will not be taken into 
account in the current solution. 

Created a JIRA issue to support aggregating on different dates in the 
enrollment(this had been planned for a while but not documented): DHIS2-1398 
<https://jira.dhis2.org/browse/DHIS2-1398>. The last event date in the 
enrollment across all program stages can be accessed in filters and expressions 
calculations by using the V{event_date} variable. However, the individual 
program stages event dates cannot be accessed at the moment, so if you use a 
registration program stage you will not be able to use the event date here with 
enrollment analytics. JIRA issue for adding support for this can be found here: 
DHIS2-1397 <https://jira.dhis2.org/browse/DHIS2-1397>

Let us know the gaps if your you case doesn't seem to be supported - especially 
interested in the relation between the enrollment and event date below. Given 
the two improvements listed above, can you make a filter or expression that 
covers it?

Best regards
Markus

> 10. apr. 2017 kl. 09.43 skrev Pamod Amarakoon :
> 
> Hi Markus,
> 
> What happens when you add enrollment date in defining program indicator and 
> also select the compulsory time dimension in pivot table. Just confused as to 
> what may take precedence.
> 
> eg: In Pramil's case,
> 
> He has a registration stage with an enrollment date and he wants to analyze 
> the outcome event status of another program stage. Say he wants to follow a 
> cohort registered in 2016Q1 who's outcome will only be available in a 
> different program stage in 2017Q2, could this be achieved using Program 
> indicator in pivot table.
> 
> Thanx.
> 
> On Mon, Apr 10, 2017 at 1:04 PM, Pramil Liyanage  <mailto:prami...@gmail.com>> wrote:
> Thanks Markus. I'm on 2.25. Will update to 2.26 and try. Will get back to you 
> if any issue. Thanks again.
> 
> Pramil
> 
> On Mon, Apr 10, 2017 at 12:59 PM, Markus Bekken  <mailto:mar...@dhis2.org>> wrote:
> Hi there Pramil,
> if you are on version 2.26 or later you can make a program indicator with the 
> "Enrollment" analytics type:
> 
> 
> This will let you compare data from different events within the same 
> enrollment. The enrollment date is used as the aggregation date when looking 
> at the data in a pivot.
> 
> Hope this helps, get back if you have any further questions.
> 
> Best regards,
> Markus
> 
> 
>> 7. apr. 2017 kl. 21.48 skrev Pramil Liyanage > <mailto:prami...@gmail.com>>:
>> 
>> Hi,
>> 
>> I need to analyze data across variables in two events in a program with 
>> multiple stages. 
>> 
>> For example, I need to find the number of patients marked as cured in 
>> treatment outcome stage,  for a cohort registered during a specified time. 
>> Can I combine enrollment date or date from another event (e.g. registration 
>> event)? Event reports will aggregate to the event, treatment outcome, not 
>> registration.
>> 
>> I know that this is not possible to combine elements from two events in 
>> event reports. Is it possible to do this using programme indicators? If so 
>> what is the syntax?
>> 
>> Regards
>> Pramil
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> Post to : dhis2-us...@lists.launchpad.net 
>> <mailto:dhis2-us...@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-users 
>> <https://launchpad.net/~dhis2-users>
>> More help   : https://help.launchpad.net/ListHelp 
>> <https://help.launchpad.net/ListHelp>
> 
> 
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> Post to : dhis2-us...@lists.launchpad.net 
> <mailto:dhis2-us...@lists.launchpad.net>
> Unsubscribe : https://launchpad.net/~dhis2-users 
> <https://launchpad.net/~dhis2-users>
> More help   : https://help.launchpad.net/ListHelp 
> <https://help.launchpad.net/ListHelp>
> 
> 
> 
> 
> -- 
> Regards,
> Dr. Pamod Amarakoon
> MBBS (SL)
> M

Re: [Dhis2-devs] [Dhis2-users] Analyze across events

[Markus Bekken]

Hi there Pramil,
if you are on version 2.26 or later you can make a program indicator with the 
"Enrollment" analytics type:


This will let you compare data from different events within the same 
enrollment. The enrollment date is used as the aggregation date when looking at 
the data in a pivot.

Hope this helps, get back if you have any further questions.

Best regards,
Markus


> 7. apr. 2017 kl. 21.48 skrev Pramil Liyanage :
> 
> Hi,
> 
> I need to analyze data across variables in two events in a program with 
> multiple stages. 
> 
> For example, I need to find the number of patients marked as cured in 
> treatment outcome stage,  for a cohort registered during a specified time. 
> Can I combine enrollment date or date from another event (e.g. registration 
> event)? Event reports will aggregate to the event, treatment outcome, not 
> registration.
> 
> I know that this is not possible to combine elements from two events in event 
> reports. Is it possible to do this using programme indicators? If so what is 
> the syntax?
> 
> Regards
> Pramil
> ___
> 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

Re: [Dhis2-devs] [Dhis2-users] CLARITY ON DEFINITIONS FOR COUNTS IN PROGRAM INDICATORS

[Markus Bekken]

Hi Stanley!

You possibly already read this chapter in the docs:
26.4.1.7. About variables 


We can probably expand a bit more in the docs on how the different counts work. 
Here is a bit more of an explanation for the different counts.

Count of events(event mode): When looking at this in an pivot, it counts the 
number of events that 
- has an event date within the given period
- happened at the orgunit(s) included in the report
- matches any other filters you might have defined in the "Filter" part 
of the program indicator.

Count of enrollments(event mode): Is counting a subset of the "Count of events" 
above. When several events is linked to one enrollment, each of these groups 
will only be counted as one. An alternative narrative way of explaining it is 
that you count how many different enrollments that is represented with at least 
one event within the given period and orgunit(s).

Count of tracked entity instances(event mode): Is counting a subset of the 
"Count of enrollments" above. When several events is linked to one enrollment, 
and several enrollments is linked to one tracked entity instance, all these are 
grouped and counted on the tracked entity instance level. An alternative 
narrative way of explaining it is that you count how many different tracked 
entity instances that is represented with at least one event within the given 
period and orgunit(s).

As you can see, all these counts is by default founded in the individual events 
that happened within the reporting boundaries. In 2.26 we added another mode 
for program indicators in tracker programs called "Enrollment" mode. This is 
opposed to the "Event" mode that is explained above, and that is the default 
mode for all program indicators. Enrollment mode might be useful in some cases 
when working with tracker data. If you select "Enrollment" as the mode for the 
program indicator, the enrollment itself is the foundation for all counting, 
expressions and filtering. Here is how the counts behave in enrollment mode:

Count of events(enrollment mode): Not yet supported enrollment mode, but 
improvement issue is registered: 
https://jira.dhis2.org/browse/DHIS2-1068?jql=text%20~%20%22count%22

Count of enrollments(enrollment mode): When looking at this in an pivot, it 
counts the number of enrollments that 
- has an enrollment date within the given period
- was enrolled at the orgunit(s) included in the report
- matches any other filters you might have defined in the "Filter" part 
of the program indicator.

Count of tracked entity instances(enrollment mode): Is counting a subset of the 
"Count of enrollments" above. When several enrollments is linked to one tracked 
entity instance, all these are groups are counted as one. An alternative 
narrative way of explaining it is that you count how many different tracked 
entity instances that was enrolled within the 

Hope this explanation can help you when looking into your mentioned difference 
in numbers between event reports and program indicators. If you want further 
assistance on this part, please provide more detail on the indicator definition 
and the event reports query.

Best regards,
Markus

> 3. apr. 2017 kl. 09.19 skrev Stanley Kalyati :
> 
> Can someone please define for me what i expect to get when i create an 
> indicator based on the following in the expression description:
> 
> 1-Count of events,what will the indicator count
> 2-Count of enrollment,will this count all enrollments within the program
> 3-Count of tracked entity instances,what will this count.
> 
> I am saying this because when i extract enrollment data using Events 
> Reports,i get a figure that is different from that which is generated by the 
> program indicator whose expression description is "Count of enrollment"
> 
> A simple definition will help out,.
> 
> Thanks
> 
> Stanley
> ___
> 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

Re: [Dhis2-devs] [Dhis2-users] PROGRAM INDICATOR CAN DISPLAY DATA WHEN I SWITCH OU TO ROW DIMENSIONS

[Markus Bekken]

Dear Georgi and Stanley,
There seems to be a problem with the monthly periods in tracker - please 
register this as a bug in Jira.

The problem with the Program Indicators from different years I was not able to 
reproduce. Using the pivot table app I am able to see program indicator values 
from different years in the same table. Can you provide some more info on your 
indicator, alternatively  send the database to me offline?

Markus

> 24. mar. 2017 kl. 10.20 skrev Georgi Chakarov :
> 
> I am not sure. If someone on the developing team is following the issue I 
> would love their opinion!
> I think that the bug comes from tracker programs. In program settings if you 
> set your repeatable stages to be monthly (or yearly or other period) younwill 
> not be able to create stages that flow within two years. E.g. Now is 2017 and 
> I want to create monthly stages and enter data for earlier periods, say 
> months in 2016, tracker will not allow me to do so. It will allow me to 
> create monthly stages for 2017 only. This restriction actually is reflected 
> in reporting as well. You are not able to see a combined figure for two years.
> 
> I will put together some screenshots of the above and report to jira.
> 
> 
> Georgi Chakarov, CIA | geo...@logicaloutcomes.net | +1-647-478-5634 x 104 | 
> LogicalOutcomes c/o Centre for Social Innovation, 720 Bathurst Street, 
> Toronto Canada M5S 2R4 | You may unsubscribe from receiving commercial 
> electronic messages from LogicalOutcomes by emailing i...@logicaloutcomes.net
> From: Stanley Kalyati 
> Sent: Friday, March 24, 2017 7:54:23 AM
> To: Georgi Chakarov
> Cc: DHIS 2 Developers list; DHIS Users
> Subject: Re: [Dhis2-users] PROGRAM INDICATOR CAN DISPLAY DATA WHEN I SWITCH 
> OU TO ROW DIMENSIONS
>  
> Georgi,
> 
> You are right,when i select months for one year i am able to see data 
> regardless of how i move around with the Layout.But when i mix periods for 
> two years then data does  not show.
> 
> Is this a bug or thats how it is made.
> 
> I would love to have information across years.
> 
> Thank you
> 
> Stanley
> 
> On Thu, Mar 23, 2017 at 7:25 PM, Georgi Chakarov  > wrote:
> Hi Stanley,
> 
>  
> 
> Are you using months within one year or your months are from 2 years?
> 
> E.g. the below:
> 
>  
> 
> Oct 2016
> 
> Nov 2016
> 
> Dec 2016
> 
> Jan 2017
> 
> Feb 2017
> 
>  
> 
> Regards,
> 
>  
> 
> Georgi
> 
> From: Dhis2-users [mailto:dhis2-users-bounces+georgi 
> =logicaloutcomes@lists.launchpad.net 
> ] On Behalf Of Stanley Kalyati
> Sent: Thursday, March 23, 2017 3:56 PM
> To: DHIS 2 Developers list  >; DHIS Users 
> mailto:dhis2-us...@lists.launchpad.net>>
> Subject: Re: [Dhis2-users] PROGRAM INDICATOR CAN DISPLAY DATA WHEN I SWITCH 
> OU TO ROW DIMENSIONS
> 
>  
> 
> I had posted this issue for help, is there anyone who can advise?
> 
>  
> 
> Thanks
> 
>  
> 
> Stanley
> 
>  
> 
> On Mar 22, 2017 12:43 PM, "Stanley Kalyati"  > wrote:
> 
> I created a program indicator to count the number of clients enrolled to a 
> program. On layout,when i place the OrgUnit on Filter,Period on Row dimention 
> and data on column dimension,i am able to see data by months.But when i 
> switch OrgUnit to Row dimension and period to filter,then no data is 
> displayed.
> 
>  
> 
> What could be the problem? I am using DHIS2 2.25 latest build.
> 
>  
> 
> Please help
> 
>  
> 
> Stanley
> 
>  
> 
> 
> ___
> 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

Re: [Dhis2-devs] Program indicator "hasValue"

[Markus Bekken]

Hi Olav,
the following syntax is now supported:  
> - #{wmSb9TmevMn.jeK5z6acB3N}  == ‘’

Jira issue: https://jira.dhis2.org/browse/DHIS2-1185 


Best regards,
Markus

> 1. feb. 2017 kl. 13.40 skrev Olav Poppe :
> 
> Hi devs, I’m trying (in 2.25) to make a program indicator counting events 
> where a specific data element has not been filled.
> 
> Tested so far: 
> - d2:hasValue(‘wmSb9TmevMn.jeK5z6acB3N’)  => not supported in 
> program indicators, only program rules
> - #{wmSb9TmevMn.jeK5z6acB3N}  == ‘’   => no data 
> - #{wmSb9TmevMn.jeK5z6acB3N}  != ‘’   => counts the events 
> WITH data, but I’m unable to «invert» this:
>   -- !(#{wmSb9TmevMn.jeK5z6acB3N}  != ‘’) => no data, 
> catalina.out shows: ERROR: operator does not exist: ! boolean
>   -- (#{wmSb9TmevMn.jeK5z6acB3N}  != '') != true  => no data
> - #{wmSb9TmevMn.jeK5z6acB3N}  is null => works, but 
> is not a supported format from what I understand.
> 
> In general, what is displayed in «Filter description» and what actually works 
> is not consistent - some things are invalid, but work, others are valid but 
> don’t work…
> 
> Any advice?
> 
> Regards
> Olav
> ___
> 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] Tracking information between Program Stages and sections

[Markus Bekken]

Hi there!
One option is to make a program indicator that shows the test score. This will 
make this piece of information visible in the Indicators widget throughout all 
program stages.

It is also possible to automatically fill fields based on values in other 
fields using program rules, but it depends what you want here - wether you just 
want to show the value to the user as a guide, or save it as a data value in 
other program stages.

Markus

> 9. feb. 2017 kl. 17.08 skrev usuario tecugi :
> 
> Hi all,
> 
> We want to know if it is possible to fill textfield with information  of 
> other stages or section in the same program.
> 
> For example: A test was done in a previous stage, after we open the next 
> stage in the program, if we want to know the test score, we want to see it in 
> this new stage, so: Is there any way to get legacy with the data element in 
> DHIS?
> 
> Please, let us know.
> 
> Warm Regards,
> 
> ISC. Carlos M. Herrera Sierra
> SESAL/UGI
> 9715-2987
> usuariotec...@gmail.com 
> Cuidemos el Medio Ambiente, por favor,no imprima este correo electrónico si 
> no es necesario.
> 
> Este correo electrónico contiene información legal confidencial y 
> privilegiada. Si Usted no es el destinatario a quien se desea enviar este 
> mensaje, tendrá prohibido darlo a conocer a persona alguna, así como a 
> reproducirlo o copiarlo. Si recibe este mensaje por error, favor de 
> notificarlo al remitente de inmediato y desecharlo de su sistema.
> ___
> 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] OptionSets of type Number - is optionvalue CODES then limited to number?

[Markus Bekken]

Hi Calle - the data type of the option set is meant to dictate what type of 
data the option set codes will be. I would say the error was in 2.24 and older 
dhis versions - allowing letters in codes for numeric option sets seems like a 
bug. 

Markus

> Den 11. feb. 2017 kl. 12.40 skrev Calle Hedberg :
> 
> Hi again,
> 
> Just to add: the constraint that optionSets with valueType = Number can only 
> have optionValue codes consisting of digits is new in either 2.25 and/or 2.26 
> - it is not there in 2.24.
> 
> Which is why I suspect this might be a bug - but I would like confirmation 
> before reporting it on JIRA
> 
> Best regards
> Calle
> 
>> On 11 February 2017 at 13:21, Calle Hedberg  wrote:
>> Hi
>> 
>> I am uncertain if this is a bug or not (latest build 2.26): 
>> When you define an option set using valueType=Number, the system will only 
>> accept optionValue codes consisting of digits (no letters) for that 
>> optionSet.
>> 
>> There is no mention of this restriction in the user manual.
>> 
>> Is this intended behaviour, or is it a bug?
>> 
>> Regards
>> Calle 
>> ***
>> 
>> Calle Hedberg
>> 
>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>> 
>> Tel/fax (home): +27-21-685-6472
>> 
>> Cell: +27-82-853-5352
>> 
>> Iridium SatPhone: +8816-315-19119
>> 
>> Email: calle.hedb...@gmail.com
>> 
>> Skype: calle_hedberg
>> 
>> ***
>> 
>> 
> 
> 
> 
> -- 
> ***
> 
> Calle Hedberg
> 
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
> 
> Tel/fax (home): +27-21-685-6472
> 
> Cell: +27-82-853-5352
> 
> Iridium SatPhone: +8816-315-19119
> 
> Email: calle.hedb...@gmail.com
> 
> Skype: calle_hedberg
> 
> ***
> 
> 
> ___
> 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] Tracker Program Indicator using data element with option sert

[Markus Bekken]

Value code, yes - thank you Calle :)

> 31. jan. 2017 kl. 11.03 skrev Calle Hedberg :
> 
> Markus,
> 
> You are saying "optionSETcode" - you do mean "optionVALUEcode"??
> 
> What Brent wants here is the ability to select one or more optionvalues, not 
> optionSETs
> 
> Regards
> calle
> 
> On 31 January 2017 at 10:48, Markus Bekken  <mailto:mar...@dhis2.org>> wrote:
> Hi there Brent,
> As Calle says, you should use the option set code for the program indicators. 
> In your example below it seems you are using parenthesis around your 
> condition value. You should remove these and use apostrophes to quote the 
> option set code like this:
> #{programstage.dataelement} == 'Your optionset code'
> 
> Markus
> 
>> 31. jan. 2017 kl. 09.43 skrev Calle Hedberg > <mailto:calle.hedb...@gmail.com>>:
>> 
>> Brent,
>> 
>> Are your program indicators using the option VALUE or the option CODE?
>> 
>> regards
>> calle
>> 
>> On 31 January 2017 at 09:36, Brent Williams > <mailto:br...@hisp.org>> wrote:
>> Dear all,
>> 
>>  
>> 
>> I have  setup a tracker program, in which the data elements are using 
>> options sets in certain cases. I have tried to set up a program indicator 
>> that would calculate the value for the sum of the 1, 2 or 3 of the data 
>> element options, but the result is counting all the events are not filtering 
>> the 2 option.
>> 
>>  
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>>  
>> 
>>  
>> 
>> Is it possible to setup an program indicator using option sets?
>> 
>> What am I missing?
>> 
>>  
>> 
>> Brent Williams
>> 
>> 
>>   
>> 
>> Project Implementation
>> Health Information Systems Program (HISP) - SA
>> 
>> ---
>> 
>> e-mail:br...@hisp.org <mailto:br...@hisp.org> 
>> Mobile:   071 542 9140
>> 
>> Skype:brent.williams267
>> Web:   http://www.hisp.org <http://www.hisp.org/>
>>  
>> 
>>  
>> 
>>  
>> 
>>  
>> 
>> 
>> This message and any attachments are subject to a disclaimer published at 
>> http://www.hisp.org/policies.html#comms_disclaimer 
>> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the 
>> disclaimer before opening any attachment or taking any other action in terms 
>> of this electronic transmission.  If you cannot access the disclaimer, 
>> kindly send an email to disclai...@hisp.org <mailto:disclai...@hisp.org> and 
>> a copy will be provided to you. By replying to this e-mail or opening any 
>> attachment you agree to be bound by the provisions of the disclaimer.
>> 
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> Post to : dhis2-devs@lists.launchpad.net 
>> <mailto:dhis2-devs@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp 
>> <https://help.launchpad.net/ListHelp>
>> 
>> 
>> 
>> 
>> -- 
>> *** <>
>> Calle Hedberg
>> 
>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>> 
>> Tel/fax (home): +27-21-685-6472 
>> Cell: +27-82-853-5352 
>> Iridium SatPhone: +8816-315-19119 
>> Email: calle.hedb...@gmail.com <mailto:calle.hedb...@gmail.com>
>> Skype: calle_hedberg
>> 
>> ***
>> 
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> Post to : dhis2-devs@lists.launchpad.net 
>> <mailto:dhis2-devs@lists.launchpad.net>
>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>> <https://launchpad.net/~dhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp 
>> <https://help.launchpad.net/ListHelp>
> 
> 
> 
> 
> -- 
> *** <>
> Calle Hedberg
> 
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
> 
> Tel/fax (home): +27-21-685-6472
> 
> Cell: +27-82-853-5352
> 
> Iridium SatPhone: +8816-315-19119
> 
> Email: calle.hedb...@gmail.com <mailto:calle.hedb...@gmail.com>
> Skype: calle_hedberg
> 
> ***
> 
> 

___
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] Tracker Program Indicator using data element with option sert

[Markus Bekken]

Hi there Brent,
As Calle says, you should use the option set code for the program indicators. 
In your example below it seems you are using parenthesis around your condition 
value. You should remove these and use apostrophes to quote the option set code 
like this:
#{programstage.dataelement} == 'Your optionset code'

Markus

> 31. jan. 2017 kl. 09.43 skrev Calle Hedberg :
> 
> Brent,
> 
> Are your program indicators using the option VALUE or the option CODE?
> 
> regards
> calle
> 
> On 31 January 2017 at 09:36, Brent Williams  > wrote:
> Dear all,
> 
>  
> 
> I have  setup a tracker program, in which the data elements are using options 
> sets in certain cases. I have tried to set up a program indicator that would 
> calculate the value for the sum of the 1, 2 or 3 of the data element options, 
> but the result is counting all the events are not filtering the 2 option.
> 
>  
> 
> 
> 
> 
> 
> 
> 
>  
> 
>  
> 
> Is it possible to setup an program indicator using option sets?
> 
> What am I missing?
> 
>  
> 
> Brent Williams
> 
> 
>   
> 
> Project Implementation
> Health Information Systems Program (HISP) - SA
> 
> ---
> 
> e-mail:br...@hisp.org  
> Mobile:   071 542 9140
> 
> Skype:brent.williams267
> Web:   http://www.hisp.org 
>  
> 
>  
> 
>  
> 
>  
> 
> 
> This message and any attachments are subject to a disclaimer published at 
> http://www.hisp.org/policies.html#comms_disclaimer 
> .  Please read the 
> disclaimer before opening any attachment or taking any other action in terms 
> of this electronic transmission.  If you cannot access the disclaimer, kindly 
> send an email to disclai...@hisp.org  and a copy 
> will be provided to you. By replying to this e-mail or opening any attachment 
> you agree to be bound by the provisions of the disclaimer.
> 
> 
> ___
> 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 
> 
> 
> 
> 
> 
> -- 
> *** <>
> Calle Hedberg
> 
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
> 
> Tel/fax (home): +27-21-685-6472
> 
> Cell: +27-82-853-5352
> 
> Iridium SatPhone: +8816-315-19119
> 
> Email: calle.hedb...@gmail.com 
> Skype: calle_hedberg
> 
> ***
> 
> 
> ___
> 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