Data Value Submission Date

Support - Assistance technique
1

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

2

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=pBOMPrpg1QX&period=201701&orgUnit=DiszpKrYNg8

···

On Mon, Apr 30, 2018 at 4:08 PM, Barnabas Akumba akumbabarns@gmail.com 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@lists.launchpad.net

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

3

Thanks Knut.

Regards

···

On Mon, Apr 30, 2018 at 3:20 PM, Knut Staring knutst@gmail.com 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=pBOMPrpg1QX&period=201701&orgUnit=DiszpKrYNg8

–

On Mon, Apr 30, 2018 at 4:08 PM, Barnabas Akumba akumbabarns@gmail.com 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@lists.launchpad.net

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

4

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@gmail.com 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=pBOMPrpg1QX&period=201701&orgUnit=DiszpKrYNg8

–

On Mon, Apr 30, 2018 at 4:08 PM, Barnabas Akumba akumbabarns@gmail.com 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@lists.launchpad.net

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

5

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- and OU_GROUP-

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@gmail.com 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@gmail.com 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=pBOMPrpg1QX&period=201701&orgUnit=DiszpKrYNg8

–

Barnabas AKUMBA

Mobile: +2348036195778

Skype: barnabas.akumba

On Mon, Apr 30, 2018 at 4:08 PM, Barnabas Akumba akumbabarns@gmail.com 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@lists.launchpad.net

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

–

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

6

Hi Barnabas,

You can add children=true

Also you can idScheme=name if you want name of metadata than uid in response.

More details here https://docs.dhis2.org/2.29/en/developer/html/dhis2_developer_manual_full.html#webapi_reading_data_values

Think this can help.

Best.

···

2018-05-09 8:29 GMT+00:00 Knut Staring knutst@gmail.com:

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- and OU_GROUP-

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

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

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

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

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

–

On Tue, May 8, 2018 at 6:02 PM, Barnabas Akumba akumbabarns@gmail.com 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

–
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

On Mon, Apr 30, 2018 at 3:20 PM, Knut Staring knutst@gmail.com 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=pBOMPrpg1QX&period=201701&orgUnit=DiszpKrYNg8

–

Barnabas AKUMBA

Mobile: +2348036195778

Skype: barnabas.akumba

On Mon, Apr 30, 2018 at 4:08 PM, Barnabas Akumba akumbabarns@gmail.com 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@lists.launchpad.net

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

–

**----**Sakibou

7

Thanks Knut.
Will give it a try.

Regards

···

On Tue, May 8, 2018 at 6:02 PM, Barnabas Akumba akumbabarns@gmail.com 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

–
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

On Mon, Apr 30, 2018 at 3:20 PM, Knut Staring knutst@gmail.com 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=pBOMPrpg1QX&period=201701&orgUnit=DiszpKrYNg8

–

Barnabas AKUMBA

Mobile: +2348036195778

Skype: barnabas.akumba

On Mon, Apr 30, 2018 at 4:08 PM, Barnabas Akumba akumbabarns@gmail.com 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@lists.launchpad.net

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

–

8

Hi Sekibou,

Thanks for the information.

Will try it out and see.

Regards

···

2018-05-09 8:29 GMT+00:00 Knut Staring knutst@gmail.com:

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- and OU_GROUP-

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

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

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

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

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

–
**----**Sakibou

On Tue, May 8, 2018 at 6:02 PM, Barnabas Akumba akumbabarns@gmail.com 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

–
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

On Mon, Apr 30, 2018 at 3:20 PM, Knut Staring knutst@gmail.com 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=pBOMPrpg1QX&period=201701&orgUnit=DiszpKrYNg8

–

Barnabas AKUMBA

Mobile: +2348036195778

Skype: barnabas.akumba

On Mon, Apr 30, 2018 at 4:08 PM, Barnabas Akumba akumbabarns@gmail.com 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@lists.launchpad.net

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

–

9

Actually the link from Sakibou is more pertinent than what I sent, but I strongly recommend reading both parts of the manual thoroughly and experiment with the long range of parameters listed.

Knut

···

On Wed, May 9, 2018 at 11:09 AM, Barnabas Akumba akumbabarns@gmail.com wrote:

Thanks Knut.
Will give it a try.

Regards

On Wed, May 9, 2018, 9:29 AM Knut Staring knutst@gmail.com wrote:

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- and OU_GROUP-

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

–
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

On Mon, Apr 30, 2018 at 3:20 PM, Knut Staring knutst@gmail.com 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=pBOMPrpg1QX&period=201701&orgUnit=DiszpKrYNg8

–

Barnabas AKUMBA

Mobile: +2348036195778

Skype: barnabas.akumba

On Mon, Apr 30, 2018 at 4:08 PM, Barnabas Akumba akumbabarns@gmail.com 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@lists.launchpad.net

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

–

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

10

Thanks Knut & Sekibou.

Your suggestions have been very useful.

Regards

···

On Wed, May 9, 2018 at 10:21 AM, Knut Staring knutst@gmail.com wrote:

Knut

Actually the link from Sakibou is more pertinent than what I sent, but I strongly recommend reading both parts of the manual thoroughly and experiment with the long range of parameters listed.

–

On Wed, May 9, 2018 at 11:09 AM, Barnabas Akumba akumbabarns@gmail.com wrote:

Thanks Knut.
Will give it a try.

Regards

On Wed, May 9, 2018, 9:29 AM Knut Staring knutst@gmail.com wrote:

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- and OU_GROUP-

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

–
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

On Tue, May 8, 2018 at 6:02 PM, Barnabas Akumba akumbabarns@gmail.com 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

–
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

On Mon, Apr 30, 2018 at 3:20 PM, Knut Staring knutst@gmail.com 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=pBOMPrpg1QX&period=201701&orgUnit=DiszpKrYNg8

–

Barnabas AKUMBA

Mobile: +2348036195778

Skype: barnabas.akumba

On Mon, Apr 30, 2018 at 4:08 PM, Barnabas Akumba akumbabarns@gmail.com 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@lists.launchpad.net

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