Comments in the Event Report

Hi DHIS team,

Is it possible to include the comments values (as entered in the Comment box on the Event Capture data entry screen) in an Event Report?

So far, the only way we’ve found to retrieve the comments is by a SQL query to the trackedentitycomment table, which is not very convenient.

Thanks for your assistance,

Becky

Becky Smith

Development-Operations Specialist

ICAP at Columbia University

Tel: 212.304.7109

Email: rs3524@cumc.columbia.edu

Hi Becky,

unfortunately - not at the moment.

Could you tell us where in event reports you would like comments to be visible? It clearly makes sense in the “individual event overview” section (and not in the aggregate events section) it seems.

best regards,

Lars

···

On Mon, Jun 20, 2016 at 7:46 PM, Smith, Rebecca A. rs3524@cumc.columbia.edu wrote:

Hi DHIS team,

Is it possible to include the comments values (as entered in the Comment box on the Event Capture data entry screen) in an Event Report?

So far, the only way we’ve found to retrieve the comments is by a SQL query to the trackedentitycomment table, which is not very convenient.

Thanks for your assistance,

Becky

Becky Smith

Development-Operations Specialist

ICAP at Columbia University

Tel: 212.304.7109

Email: rs3524@cumc.columbia.edu


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Thanks for the quick response!

Yes, it would be on the individual event overview.

···

Hi Becky,

unfortunately - not at the moment.

Could you tell us where in event reports you would like comments to be visible? It clearly makes sense in the “individual event overview” section (and not in the aggregate events section) it seems.

best regards,

Lars

On Mon, Jun 20, 2016 at 7:46 PM, Smith, Rebecca A. rs3524@cumc.columbia.edu wrote:

Hi DHIS team,

Is it possible to include the comments values (as entered in the Comment box on the Event Capture data entry screen) in an Event Report?

So far, the only way we’ve found to retrieve the comments is by a SQL query to the trackedentitycomment table, which is not very convenient.

Thanks for your assistance,

Becky

Becky Smith

Development-Operations Specialist

ICAP at Columbia University

Tel: 212.304.7109

Email: rs3524@cumc.columbia.edu


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Okay good. A bit more detail: as popups hovering the values, as separate columns or something else?

···

On Mon, Jun 20, 2016 at 7:50 PM, Smith, Rebecca A. rs3524@cumc.columbia.edu wrote:

Thanks for the quick response!

Yes, it would be on the individual event overview.

From: Lars Helge Øverland [mailto:lars@dhis2.org]

Sent: Monday, June 20, 2016 1:50 PM

To: Smith, Rebecca A.

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Comments in the Event Report

Hi Becky,

unfortunately - not at the moment.

Could you tell us where in event reports you would like comments to be visible? It clearly makes sense in the “individual event overview” section (and not in the aggregate events section) it seems.

best regards,

Lars

On Mon, Jun 20, 2016 at 7:46 PM, Smith, Rebecca A. rs3524@cumc.columbia.edu wrote:

Hi DHIS team,

Is it possible to include the comments values (as entered in the Comment box on the Event Capture data entry screen) in an Event Report?

So far, the only way we’ve found to retrieve the comments is by a SQL query to the trackedentitycomment table, which is not very convenient.

Thanks for your assistance,

Becky

Becky Smith

Development-Operations Specialist

ICAP at Columbia University

Tel: 212.304.7109

Email: rs3524@cumc.columbia.edu


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

A separate column for the comments would be ideal.

We’d be fine with popups or any other display style in the UI, as long as they become separate columns in the Excel/CSV data download.

Thanks,

Becky

···

Okay good. A bit more detail: as popups hovering the values, as separate columns or something else?

On Mon, Jun 20, 2016 at 7:50 PM, Smith, Rebecca A. rs3524@cumc.columbia.edu wrote:

Thanks for the quick response!

Yes, it would be on the individual event overview.

From: Lars Helge Øverland [mailto:lars@dhis2.org]

Sent: Monday, June 20, 2016 1:50 PM

To: Smith, Rebecca A.

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Comments in the Event Report

Hi Becky,

unfortunately - not at the moment.

Could you tell us where in event reports you would like comments to be visible? It clearly makes sense in the “individual event overview” section (and not in the aggregate events section) it seems.

best regards,

Lars

On Mon, Jun 20, 2016 at 7:46 PM, Smith, Rebecca A. rs3524@cumc.columbia.edu wrote:

Hi DHIS team,

Is it possible to include the comments values (as entered in the Comment box on the Event Capture data entry screen) in an Event Report?

So far, the only way we’ve found to retrieve the comments is by a SQL query to the trackedentitycomment table, which is not very convenient.

Thanks for your assistance,

Becky

Becky Smith

Development-Operations Specialist

ICAP at Columbia University

Tel: 212.304.7109

Email: rs3524@cumc.columbia.edu


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Hi Lars,

Just to add an extra vote for enabling a Comments column (through options?) which can be retrieved when downloading events data.

I’d also hope that the comments field will be enabled in the upcoming Event (and Tracker?) capture mobile app, as this is currently not the case.

Bram

PSI

···

On 20 June 2016 at 18:10, Smith, Rebecca A. rs3524@cumc.columbia.edu wrote:

A separate column for the comments would be ideal.

We’d be fine with popups or any other display style in the UI, as long as they become separate columns in the Excel/CSV data download.

Thanks,

Becky

From: Lars Helge Øverland [mailto:lars@dhis2.org]

Sent: Monday, June 20, 2016 1:53 PM

To: Smith, Rebecca A.

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Comments in the Event Report

Okay good. A bit more detail: as popups hovering the values, as separate columns or something else?

On Mon, Jun 20, 2016 at 7:50 PM, Smith, Rebecca A. rs3524@cumc.columbia.edu wrote:

Thanks for the quick response!

Yes, it would be on the individual event overview.

From: Lars Helge Øverland [mailto:lars@dhis2.org]

Sent: Monday, June 20, 2016 1:50 PM

To: Smith, Rebecca A.

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Comments in the Event Report

Hi Becky,

unfortunately - not at the moment.

Could you tell us where in event reports you would like comments to be visible? It clearly makes sense in the “individual event overview” section (and not in the aggregate events section) it seems.

best regards,

Lars

On Mon, Jun 20, 2016 at 7:46 PM, Smith, Rebecca A. rs3524@cumc.columbia.edu wrote:

Hi DHIS team,

Is it possible to include the comments values (as entered in the Comment box on the Event Capture data entry screen) in an Event Report?

So far, the only way we’ve found to retrieve the comments is by a SQL query to the trackedentitycomment table, which is not very convenient.

Thanks for your assistance,

Becky

Becky Smith

Development-Operations Specialist

ICAP at Columbia University

Tel: 212.304.7109

Email: rs3524@cumc.columbia.edu


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org


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

Hi there,

I have written a blueprint here:

https://blueprints.launchpad.net/dhis2/+spec/event-reports-include-comments

regards,

Lars

···

On Mon, Jun 20, 2016 at 8:19 PM, Bram Piot bram.piot@gmail.com wrote:

Hi Lars,

Just to add an extra vote for enabling a Comments column (through options?) which can be retrieved when downloading events data.

I’d also hope that the comments field will be enabled in the upcoming Event (and Tracker?) capture mobile app, as this is currently not the case.

Bram

PSI

On 20 June 2016 at 18:10, Smith, Rebecca A. rs3524@cumc.columbia.edu wrote:

A separate column for the comments would be ideal.

We’d be fine with popups or any other display style in the UI, as long as they become separate columns in the Excel/CSV data download.

Thanks,

Becky

From: Lars Helge Øverland [mailto:lars@dhis2.org]

Sent: Monday, June 20, 2016 1:53 PM

To: Smith, Rebecca A.

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Comments in the Event Report

Okay good. A bit more detail: as popups hovering the values, as separate columns or something else?

On Mon, Jun 20, 2016 at 7:50 PM, Smith, Rebecca A. rs3524@cumc.columbia.edu wrote:

Thanks for the quick response!

Yes, it would be on the individual event overview.

From: Lars Helge Øverland [mailto:lars@dhis2.org]

Sent: Monday, June 20, 2016 1:50 PM

To: Smith, Rebecca A.

Cc: dhis2-users@lists.launchpad.net

Subject: Re: [Dhis2-users] Comments in the Event Report

Hi Becky,

unfortunately - not at the moment.

Could you tell us where in event reports you would like comments to be visible? It clearly makes sense in the “individual event overview” section (and not in the aggregate events section) it seems.

best regards,

Lars

On Mon, Jun 20, 2016 at 7:46 PM, Smith, Rebecca A. rs3524@cumc.columbia.edu wrote:

Hi DHIS team,

Is it possible to include the comments values (as entered in the Comment box on the Event Capture data entry screen) in an Event Report?

So far, the only way we’ve found to retrieve the comments is by a SQL query to the trackedentitycomment table, which is not very convenient.

Thanks for your assistance,

Becky

Becky Smith

Development-Operations Specialist

ICAP at Columbia University

Tel: 212.304.7109

Email: rs3524@cumc.columbia.edu


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org