dhis2-users team mailing list archive

[Pedro Vasconcelos Maciel De Lima <pedrova@xxxxxxxxxx>]

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<mailto: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<mailto: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<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp




--

Regards,
Bharath Kumar. Ch