dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Hi Stephen,

You could probably set up a standard report to do this, but I agree with
Dapo that the fastest way is probably to go to Data Administration -> Sql
Views and create a new view similar to this (I limited the search in time
by setting an arbitrary date):

select de.name,ou.name,p.startdate, p.enddate, dv.comment from datavalue dv
inner join organisationunit ou on dv.sourceid=ou.organisationunitid
inner join period p on p.periodid=dv.periodid inner join dataelement de on
de.dataelementid=dv.dataelementid
where dv.comment is not null and dv.lastupdated > '2015-01-01'

On Friday, January 13, 2017, Dapo Adejumo <dapo@xxxxxxxxxxxxxx> wrote:

> Hi Stephen,
> You may need to pull the comments directly from the database (data value
> table) via an sql view. Alternatively, marking the star sign after
> “Comment” will make the entry visible in the follow analysis function
> within the Data Quality App (This however does not include the comments but
> can point you to the comment in the data entry screen).
> Hope that helps.
> ……………………….
>
>
>
> *Dapo Adejumo*
>
>
> On 13 Jan 2017, at 15:41, Stephen Gbanyan <mambu9@xxxxxxxxx
> <javascript:_e(%7B%7D,'cvml','mambu9@xxxxxxxxx');>> wrote:
>
> Hi All,
>
> I am trying to figure out how I can download the comment in the attached
> file.  Some Counties are opting to write in comments for clarity and I want
> to know on how I can download the comments.
>
> Thanks
>
> --
> __________________________________
> Stephen M. Gbanyan, Jr. - ASc. BA.
> Director
> Health Information System
> Ministry of Health and Social Welfare
> Republic of Liberia
> +231-886-847-915
> skype: mambu9
>
> <Screen Shot 2017-01-13 at 2.38.07 PM.png>_______________________
> ________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> <javascript:_e(%7B%7D,'cvml','dhis2-users@xxxxxxxxxxxxxxxxxxx');>
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>

-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org