dhis2-users team mailing list archive

[Alex Tumwesigye <atumwesigye@xxxxxxxxx>]

Dear Pedro,

If you are running 2.21 or higher,  try this link (I have not tried it).
http://dhis2.github.io/dhis2-docs/2.21/en/developer/html/dhis2_developer_manual_full.html#d4934e2217

Querying the below endpoints might be better and more secure than SQL Views.

/api/completeDataSetRegistrations

Alex


On Wed, Dec 16, 2015 at 5:01 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> I think you can POST it to the metadata endpoint:
>
> https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s06.html
>
> Knut
>
> On Wed, Dec 16, 2015 at 2:54 PM, Pedro Vasconcelos Maciel De Lima <
> pedrova@xxxxxxxxxx> wrote:
>
>> Hi Bharath​ and All,
>>
>>
>> Is there a way I can create a SQL view with a Web API call (instead of
>> creating it in apps -> data administration)?
>>
>>
>> Best regards,
>>
>> Pedro
>>
>>
>> ------------------------------
>> *De:* Dhis2-users <dhis2-users-bounces+pedrova=
>> ifi.uio.no@xxxxxxxxxxxxxxxxxxx> em nome de Pedro Vasconcelos Maciel De
>> Lima <pedrova@xxxxxxxxxx>
>> *Enviado:* 9 de dezembro de 2015 09:37
>> *Para:* Bharath
>> *Cc:* dhis2-users@xxxxxxxxxxxxxxxxxxx
>> *Assunto:* Re: [Dhis2-users] Web API Complete data set registrations
>>
>> Thanks, I'll give this a try!
>>
>> Best regards,
>> Pedro
>>
>>
>> No dia 07/12/2015, às 06:08, Bharath <chbharathk@xxxxxxxxx> escreveu:
>>
>>
>> One option is you can create sql view (apps -> data administration) and
>> make webapi call to that sql view. doc here
>> <http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s25.html>
>>
>> On Sun, Dec 6, 2015 at 9:51 PM, Pedro Vasconcelos Maciel De Lima <
>> pedrova@xxxxxxxxxx> wrote:
>>
>>> Hi All,
>>>
>>>
>>> I'm trying to get all complete data set registrations for a particular
>>> user after a particular date. Something along the lines of:
>>>
>>>
>>> *SELECT * FROM completedatasetregistration WHERE date>'2015-11-01' and
>>> storedby='admin';*
>>>
>>>
>>> How can I achieve this through the Web API?
>>>
>>>
>>> Best regards,
>>>
>>> Pedro Lima
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>>
>> --
>>
>> Regards,
>> Bharath Kumar. Ch
>>
>>
>> _______________________________________________
>> 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
>>
>>
>
>
> --
> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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 "