dhis2-users team mailing list archive

[Abyot Gizaw <abyota@xxxxxxxxx>]

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>
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]
> *Sent:* 14 April 2015 16:15
> *To:* Joao Mazuze
> *Cc:* dhis2-users@xxxxxxxxxxxxxxxxxxx
> *Subject:* Re: [Dhis2-users] Print list of data element values
>
>
>
> sorry, using this:
>
>
>
> SELECT program.uid as ProgUID, program.name as Prog,
> trackedentityattribute.trackedentityattributeid as ProgAttribID,
> trackedentityattribute.uid as ProgAttribUID, trackedentityattribute.name
> as ProgAttrib, programstage.uid as ProgStageUID, programstage.name as
> ProgStage, dataelement.dataelementid as ProgStageElementID, dataelement.uid
> as ProgStageElementUID, 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,
> trackedentityattribute.name, programstage.name, dataelement.name
>
>
>
>
>
>
>
> On Tue, Apr 14, 2015 at 4:14 PM, Greg Rowles <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>
> 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
> 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
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>