Web API Complete data set registrations

Support - Assistance technique
1

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

2

One option is you can create sql view (apps → data administration) and make webapi call to that sql view. doc here

···

On Sun, Dec 6, 2015 at 9:51 PM, Pedro Vasconcelos Maciel De Lima pedrova@ifi.uio.no 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

Regards,
Bharath Kumar. Ch

3

Thanks, I’ll give this a try!

Best regards,

Pedro

No dia 07/12/2015, às 06:08, Bharath chbharathk@gmail.com escreveu:

···

On Sun, Dec 6, 2015 at 9:51 PM, Pedro Vasconcelos Maciel De Lima pedrova@ifi.uio.no 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@lists.launchpad.net

Unsubscribe :
https://launchpad.net/~dhis2-users

More help :
https://help.launchpad.net/ListHelp

–

Regards,

Bharath Kumar. Ch

4

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@lists.launchpad.net em nome de Pedro Vasconcelos Maciel De Lima pedrova@ifi.uio.no

Enviado: 9 de dezembro de 2015 09:37

Para: Bharath

Cc: dhis2-users@lists.launchpad.net

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@gmail.com escreveu:

One option is you can create sql view (apps → data administration) and make webapi call to that sql view. doc
here

On Sun, Dec 6, 2015 at 9:51 PM, Pedro Vasconcelos Maciel De Lima pedrova@ifi.uio.no 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@lists.launchpad.net

Unsubscribe :
https://launchpad.net/~dhis2-users

More help :
https://help.launchpad.net/ListHelp

–

Regards,

Bharath Kumar. Ch

5

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@ifi.uio.no 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@lists.launchpad.net em nome de Pedro Vasconcelos Maciel De Lima pedrova@ifi.uio.no

Enviado: 9 de dezembro de 2015 09:37

Para: Bharath

Cc: dhis2-users@lists.launchpad.net

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@gmail.com escreveu:

One option is you can create sql view (apps → data administration) and make webapi call to that sql view. doc
here

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

On Sun, Dec 6, 2015 at 9:51 PM, Pedro Vasconcelos Maciel De Lima pedrova@ifi.uio.no 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@lists.launchpad.net

Unsubscribe :
https://launchpad.net/~dhis2-users

More help :
https://help.launchpad.net/ListHelp

–

Regards,

Bharath Kumar. Ch

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

6

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@gmail.com wrote:

I think you can POST it to the metadata endpoint:

https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s06.html

Knut

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–

On Wed, Dec 16, 2015 at 2:54 PM, Pedro Vasconcelos Maciel De Lima pedrova@ifi.uio.no 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@lists.launchpad.net em nome de Pedro Vasconcelos Maciel De Lima pedrova@ifi.uio.no

Enviado: 9 de dezembro de 2015 09:37

Para: Bharath

Cc: dhis2-users@lists.launchpad.net

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@gmail.com escreveu:

One option is you can create sql view (apps → data administration) and make webapi call to that sql view. doc
here

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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

On Sun, Dec 6, 2015 at 9:51 PM, Pedro Vasconcelos Maciel De Lima pedrova@ifi.uio.no 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@lists.launchpad.net

Unsubscribe :
https://launchpad.net/~dhis2-users

More help :
https://help.launchpad.net/ListHelp

–

Regards,

Bharath Kumar. Ch

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 "