← Back to team overview

dhis2-devs team mailing list archive

Re: Data Value Submission Date

 

Hi Barnabas,

For this I think you need to use the Analytics API:

Organisation unit identifiers, and keywords USER_ORGUNIT,
USER_ORGUNIT_CHILDREN, USER_ORGUNIT_GRANDCHILDREN, LEVEL-<level> and
OU_GROUP-<group-id>

https://docs.dhis2.org/master/en/developer/html/webapi_analytics.html#webapi_analytics_dimensions_and_items

On Tue, May 8, 2018 at 6:02 PM, Barnabas Akumba <akumbabarns@xxxxxxxxx>
wrote:

> Hello All,
>
> I want to query the datavaluesets endpoint in such a way that I should be
> able to get Datavalues for all the facilities under a particular level i.e.
> District. Is it possible?
> For example the API Below, can I change the orgUnit argument in the line
> below to give the datavalues for all the facilities under a particular
> district?
>
> https://play.dhis2.org/2.29/api/26/dataValueSets?dataSet=
> pBOMPrpg1QX&period=201701&orgUnit=DiszpKrYNg8
>
> Any help will be appreciated.
>
> Regards
>
>
>
> On Mon, Apr 30, 2018 at 3:20 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>
>> I suppose you mean through the Analytics API, since you can do something
>> like this:
>>
>> https://play.dhis2.org/2.29/api/26/dataValueSets?dataSet=pBO
>> MPrpg1QX&period=201701&orgUnit=DiszpKrYNg8
>>
>> On Mon, Apr 30, 2018 at 4:08 PM, Barnabas Akumba <akumbabarns@xxxxxxxxx>
>> wrote:
>>
>>> Hello Devs,
>>>
>>> I have looked at the "datavalue" table and discovered there are two
>>> columns (created and lastupdated). This I assume are supposed to be be the
>>> date (time stamp) of submission and update of the data values.
>>>
>>> In trying to query the API for the data values, I however have issues
>>> with fetching either the created or lastupdated time stamps. Is there any
>>> way to fetch these two fields (time stamps) along side the data values?
>>>
>>> Your prompt response'll be highly appreciated.
>>>
>>> Regards
>>>
>>>
>>> --
>>>
>>> Barnabas AKUMBA
>>>
>>> *Mobile:* +2348036195778
>>> *Skype:* barnabas.akumba
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Knut Staring
>>
>> Department of Information, Evidence and Research
>> World Health Organization, Geneva, Switzerland
>> Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
>> Skype:     knutstar
>>
>
>
>
> --
>
> Barnabas AKUMBA
>
> *Mobile:* +2348036195778
> *Skype:* barnabas.akumba
>



-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype:     knutstar

Follow ups

References