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 <d...@baosystems.com> 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 <mam...@gmail.com > <javascript:_e(%7B%7D,'cvml','mam...@gmail.com');>> 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@lists.launchpad.net > <javascript:_e(%7B%7D,'cvml','dhis2-users@lists.launchpad.net');> > 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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
