dhis2-devs team mailing list archive

[Alex Tumwesigye <atumwesigye@xxxxxxxxx>]

Dear Timothy,

The dataSet query parameter is required.
Try something like

api/dataValueSets?orgUnit="KQfLafniynG"&dataSet='dataSetUID'

Note that datavalues are related to a period, orgunit and dataset.
Ideally, a set of values (dataValueSet) may not appear in multiple
datasets, thus there is need to indicate which dataset.

Alex

On Wed, Aug 12, 2015 at 5:05 PM, Timothy Harding <hardingt@xxxxxxxxx> wrote:

> Thanks Knut,
>
> That sounds like a great option! I fear, in this case, it may not help as
> this instance is running 2.17, I think that parameterized SQL View was
> introduced in 2.19 (please correct me though)? For instances on 2.19 and
> above though, that sounds like it would be perfect.
>
> Without this approach, am I stuck using SQL to get all the datavalues
> associated with a particular OU (without knowing where exactly all of them
> are)?
>
>
> Timothy Harding
> RPCV Vanuatu
> Skype: hardingt@xxxxxxxxx
> +1 (541) 632-6623
>
> On Wed, Aug 12, 2015 at 7:03 AM, Knut Staring <knutst@xxxxxxxxx> wrote:
>
>> You could do a mix of those approaches  - create a parametrised SQL view
>> that is available through the API.
>>
>> On Wed, Aug 12, 2015 at 3:33 PM, Timothy Harding <hardingt@xxxxxxxxx>
>> wrote:
>>
>>> Hello Dev Group,
>>>
>>> Is it possible to get all the datavalues associated with an OU out of
>>> the API?
>>>
>>> I'm getting the need more and more to remove org units which will
>>> randomly have dependencies. I know the official position of DHIS2 is "don't
>>> ever remove org units" but I'm embarking on this quest all the same :).
>>>
>>> So, I'm wondering about data values today. I started here:
>>>
>>>
>>> https://www.dhis2.org/doc/snapshot/en/developer/html/dhis2_developer_manual_full.html#d5232e1433
>>>
>>> There is a phrase:
>>> "The following query parameters are required" and a giant table, but
>>> even the examples don't use more than 3 of the parameters from the table.
>>>
>>> I tried:
>>> api/dataValueSets?orgUnit="KQfLafniynG"
>>>
>>> but received an error:
>>> "Required Set parameter 'dataSet' is not present"
>>>
>>> What if the there are many, many datasets to go through, or the
>>> dataelement/datavalue in question is no longer associated with a dataset?
>>>
>>> In the meantime, I will probably need to crack open PgAdmin to get this
>>> done, but I prefer to use the API if I can. Thanks!
>>>
>>>
>>> Timothy Harding
>>> RPCV Vanuatu
>>> Skype: hardingt@xxxxxxxxx
>>> +1 (541) 632-6623
>>>
>>> _______________________________________________
>>> 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
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org
>>
>
>
> _______________________________________________
> 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
>
>


-- 
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems -
DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don't want to be anything other than what I have been - one tree hill "