dhis2-users team mailing list archive

[Joao Mazuze <Joao_Mazuze@xxxxxxxxxxxx>]

Hi Abyot,
Of course I am interested in only listing data element values of a program stage. I wonder if you could help me on that.

Many thanks,
Joao

From: Abyot Gizaw [mailto:abyota@xxxxxxxxx]
Sent: 14 April 2015 17:05
To: Joao Mazuze
Cc: Greg Rowles; dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] Print list of data element values

Hi Joao,

I was following the conversation from your request, but I still couldn't understand what you wanted to do. Can you tell us more on your use case?

The tracked entity instance example you mentioned is generated by an app, probably you need to develop a similar one. I can guide you a bit on that.

Are you interested in only listing data element values of a program stage? Don't you need from whom the listed values are recorded?


---
Thank you,
Abyot.

On Tue, Apr 14, 2015 at 4:39 PM, Joao Mazuze <Joao_Mazuze@xxxxxxxxxxxx<mailto:Joao_Mazuze@xxxxxxxxxxxx>> wrote:
It is something like we can see when we list from a program on a tracked entity form search. But I am not able to get data element s from a specific program stage belonging to that program.

Best regards

From: Greg Rowles [mailto:greg.rowles@xxxxxxxxx<mailto:greg.rowles@xxxxxxxxx>]
Sent: 14 April 2015 16:15
To: Joao Mazuze
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-users] Print list of data element values

sorry, using this:

SELECT program.uid as ProgUID, program.name<http://program.name> as Prog, trackedentityattribute.trackedentityattributeid as ProgAttribID, trackedentityattribute.uid as ProgAttribUID, trackedentityattribute.name<http://trackedentityattribute.name> as ProgAttrib, programstage.uid as ProgStageUID, programstage.name<http://programstage.name> as ProgStage, dataelement.dataelementid as ProgStageElementID, dataelement.uid as ProgStageElementUID, dataelement.name<http://dataelement.name> as ProgStageElement FROM public.program, public.program_attributes, public.trackedentityattribute, public.programstage, public.programstage_dataelements, public.dataelement WHERE program_attributes.trackedentityattributeid = trackedentityattribute.trackedentityattributeid AND program_attributes.programid = program.programid AND programstage.programid = program.programid AND programstage_dataelements.programstageid = programstage.programstageid AND dataelement.dataelementid = programstage_dataelements.dataelementid ORDER BY program.name<http://program.name>, trackedentityattribute.name<http://trackedentityattribute.name>, programstage.name<http://programstage.name>, dataelement.name<http://dataelement.name>



On Tue, Apr 14, 2015 at 4:14 PM, Greg Rowles <greg.rowles@xxxxxxxxx<mailto:greg.rowles@xxxxxxxxx>> wrote:
Hi Joao

Create a SQLview using this:

On Tue, Apr 14, 2015 at 3:34 PM, Joao Mazuze <Joao_Mazuze@xxxxxxxxxxxx<mailto:Joao_Mazuze@xxxxxxxxxxxx>> wrote:
Hi all,
How do I print a list of data element values in a program stage? I have configured some of them to be displayed in reports, is there ba way to display that list?

Kind regards

________________________________
This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Health Information Systems Program - South Africa
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Mobile  :    073 246 2992
Landline:   021 554 3130
Fax:          086 733 8432
Skype:      gregory_rowles



--
Health Information Systems Program - South Africa
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Mobile  :    073 246 2992
Landline:   021 554 3130
Fax:          086 733 8432
Skype:      gregory_rowles

________________________________
This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



________________________________
This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.