← Back to team overview

dhis2-users team mailing list archive

Re: Get Date Values

 

Ohh I see it now. Thank you.


*Walusiku J. Muyunda*

*Cell: +260953063387*

*"We have heaven to win and hell to shun, our lives testify better!"
<http://wildvoices.blogspot.com/>*


On Thu, Aug 16, 2018 at 9:05 AM Vladimer Shioshvili <vshioshvili@xxxxxxxxx>
wrote:

> Walusiku,
>
> Periodtype table contains the list of period types (weekly, daily,
> monthly, quarterly, etc).
>
> Period table has the actual period definitions: period type, start date,
> and end date (e.g. quarterly type, start date january 1, 2018, end date
> March 31, 2018).
>
> period id in the data value table refers to the entry in the period table.
>
> periodid is for the period that the data is reported for.
>
> If you need to get when the data value was actually entered/last updated,
> in datavalue table you have created (when data point was created) and
> lastupdated (when the data point value was last update).
>
> Best,
> Vlad
>
> On Thu, Aug 16, 2018 at 2:54 AM Walusiku Muyunda <jomuwalu@xxxxxxxxx>
> wrote:
>
>> Hello,
>>
>> We recently implemented DHIS2 for our data collection needs and are
>> currently looking at the first data submitted. Am just getting used to the
>> table structure and need help on where the Data Set data entry
>> dates/periods are saved. In the datavalue table I have a field periodid but
>> cant seem to find what table to link it to to get the actual dates. the
>> period and periodtype tables dont seem to have the actual dates when the
>> data was being reported. Please help.
>>
>> Thank you.
>>
>>
>> *Walusiku J. Muyunda*
>>
>>
>> *"We have heaven to win and hell to shun, our lives testify better!"
>> <http://wildvoices.blogspot.com/>*
>> _______________________________________________
>> 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
>>
>

References