Event Date location

Support - Assistance technique
1

Hi Guys

Quick and easy question for you: When you upload an event payload into DHIS2 via the Web-API (payload example shown below), in which table in the database is the event date stored?

  { "program": "eBAyeGv0exc", "orgUnit": "DiszpKrYNg8", "eventDate": "2013-05-17", "status": "COMPLETED", "storedBy": "admin", "coordinate": { "latitude": "59.8", "longitude": "10.9" }, "dataValues": [ { "dataElement": "qrur9Dvnyt5", "value": "22" }, { "dataElement": "oZg33kd9taw", "value": "Male" }, { "dataElement": "msodh3rEMJa", "value": "2013-05-18" } ] }

Regards

···

Farai Mutero

2

Hi,

The table is programstageinstance

···

On Tue, Mar 10, 2015 at 3:33 PM, Farai Mutero fmutero@gmail.com wrote:

Hi Guys

Quick and easy question for you: When you upload an event payload into DHIS2 via the Web-API (payload example shown below), in which table in the database is the event date stored?

  { "program": "eBAyeGv0exc", "orgUnit": "DiszpKrYNg8", "eventDate": "2013-05-17", "status": "COMPLETED", "storedBy": "admin", "coordinate": { "latitude": "59.8", "longitude": "10.9" }, "dataValues": [ { "dataElement": "qrur9Dvnyt5", "value": "22" }, { "dataElement": "oZg33kd9taw", "value": "Male" }, { "dataElement": "msodh3rEMJa", "value": "2013-05-18" } ] }

Regards

Farai Mutero

–

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

Thank you,

Abyot.

3

It’s a combination of programstageinstance (for the event) and trackedentitydatavalue (for the data values).

Lars

···

On Tue, Mar 10, 2015 at 3:50 PM, Abyot Gizaw abyota@gmail.com wrote:

Hi,

The table is programstageinstance

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

Thank you,

Abyot.

On Tue, Mar 10, 2015 at 3:33 PM, Farai Mutero fmutero@gmail.com wrote:

Hi Guys

Quick and easy question for you: When you upload an event payload into DHIS2 via the Web-API (payload example shown below), in which table in the database is the event date stored?

  { "program": "eBAyeGv0exc", "orgUnit": "DiszpKrYNg8", "eventDate": "2013-05-17", "status": "COMPLETED", "storedBy": "admin", "coordinate": { "latitude": "59.8", "longitude": "10.9" }, "dataValues": [ { "dataElement": "qrur9Dvnyt5", "value": "22" }, { "dataElement": "oZg33kd9taw", "value": "Male" }, { "dataElement": "msodh3rEMJa", "value": "2013-05-18" } ] }

Regards

Farai Mutero

–

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