dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

There is no way to get this directly. You would need to look in
the completedatasetregistration table.

However, if you have multiple people who might submit the data for a
particular orgunit, you would not be able to distinguish who completed the
information the first time, versus the last time. The only thing this table
will show you will be the last person who "completed" the data.

I think

SELECT storedby, COUNT(*) FROM completedatasetregistration
WHERE date  >= '2011-10-01' and date <='2012-09-30'
GROUP BY storedby;


might give you what you need however.

Regards,
Jason




On Tue, Sep 11, 2012 at 6:37 PM, Muhumuza Kananura Rornald <
mk.rornald@xxxxxxxxx> wrote:

> Dear Lars;
> Thanks for the support.
> I have data entrants who are paid according the number of forms (Data
> sets) entered. Is there any way how I can access the number of forms
> submitted by each individual.
>
> I will be grateful for the feedback.
>
> Regards
> Muhumuza Kananura Rornald
> Management Information System Officer
> THETA Uganda
> Tel: +256776301718
>
>
>   ------------------------------
> *From:* Lars Helge Øverland <larshelge@xxxxxxxxx>
> *To:* Muhumuza Kananura Rornald <mk.rornald@xxxxxxxxx>
> *Cc:* "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>
> *Sent:* Tuesday, September 11, 2012 2:12 PM
> *Subject:* Re: [Dhis2-users] DHIS Annual Report
>
> Hello Muhumuza,
>
> at the moment we only support aggregated reports for the financial
> year which starts in July. We can implement support for this in the
> next version which is 2.10.
>
> The work-around is to create a "report table" (reports module) where
> you include the four quarters which comprise your financial year. You
> then generate this report and export to Excel where you can summarize
> those four quarters into the financial year.
>
> regards,
>
> Lars
>
> On Mon, Sep 10, 2012 at 2:10 PM, Muhumuza Kananura Rornald
> <mk.rornald@xxxxxxxxx> wrote:
> > Dear;
> >
> > Dear DHIS2 Users;
> > I am using DHIS2 in managing community health data in our organization
> (CDC
> > funded). I am now supposed to produce an annual report for which the
> > financial year ends in September 31. How can I go about it.
> >
> > Regards
> >
> > Muhumuza Kananura Rornald
> > Management Information System Officer
> > THETA Uganda
> > tel: 0776301718
> >
> > _______________________________________________
> > 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
> >
>
>
>
> _______________________________________________
> 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
>
>