Patient Clinical Summary Enhancement-GSOC 2018

madushan · April 25, 2018, 3:16pm

@sthaiya @mwere Hi all, I am Madushan and I am going to work on the aforementioned project in this year’s GSOC. Project Objectives-

Create patient summary review/feedback which allows providers

to confirm the clinical summary is correct

to provide recommendation for the changes

For feedback review, it should allow reviewers

to accept recommendations and make changes
to decline the recommednations with reasons

Currently I am hoping to add the first feature. Any guidance from the community who are experienced in this module is highly appreciated.

sthaiya · April 27, 2018, 1:00pm

@madushan we are happy to work with you on this project.

@madushan @mwere Thank you all for today’s e-meeting.

@madushan we have agreed that between now and Tuesday you continue familiarizing yourself with OpenMRS clinical summaries handling as well as derived concepts. We will proceed on Tuesday at the agreed time.

madushan · April 27, 2018, 1:38pm

@sthaiya @mwere Thank you for the meeting. I am extremely sorry for the inconvenience caused. It was out of my control. I will make sure this wouldn’t happen again. I will get familiarized with those during the time.

madushan · May 21, 2018, 3:52pm

@sthaiya @mwere I am trying to create an html/text based output for my report which uses a sql dataset definition named ‘to_print_obs’.

I added a weight observation(conceptId = 5089) for patient ‘Dileka’. My sql dataset definition brings the following result.

In my groovy script I added the following code to print obs copying from openMRS wiki.

There is no exception seen and no output is printed. Looking foreward for your help to get this fixed. Thanks

dkayiwa · May 21, 2018, 4:59pm

Is this reproducible on the demo server? http://demo.openmrs.org/

madushan · May 21, 2018, 5:46pm

@dkayiwa yes, I could reproduce given the credentials.

dkayiwa · May 21, 2018, 5:56pm

What are the exact steps to reproduce locally?

madushan · May 22, 2018, 3:33am

@dkayiwa

Add weight obs for a patient
Create a sql dataset definition to bring obs of the patient
Create a customized report.
Add the created sql dataset definition to the report.
add html/text based output to the report.

In the groovy script add the following code.

<%
obsList = data.weights

     obsList = util.sort(obsList, "obsDatetime desc")
     count = 0
     for (obs in obsList) {
         if (++count > 3) {
             break
         }
         println obs.valueNumeric  + '  (' + util.format(obs.obsDatetime, 'dd/MMM/yyyy') + ')'
     }

%>

dkayiwa · May 22, 2018, 11:01pm

Can you reproduce it on demo.openmrs.org and then give me a direct link to check it out?

UserName: admin Password: Admin123

madushan · May 23, 2018, 12:27am

@dkayiwa Thank you very much for the support. I reproduced a report ‘to print obs’. Please check it here

dkayiwa · May 23, 2018, 6:23am

Can you point me to where you specify the column names that you are referencing in your groovy script?

madushan · May 23, 2018, 7:36am

@dkayiwa I have written a sql query to get all columns from a single row from obs table.

dkayiwa · May 23, 2018, 11:59am

Take a second look at the documentation you linked above in regards to column names.

madushan · May 23, 2018, 12:02pm

@dkayiwa the document asks the column to be named ‘weight’. But there are multiple columns in the obs table.

dkayiwa · May 23, 2018, 12:09pm

Is any of them named so?

madushan · May 23, 2018, 12:22pm

@dkayiwa Thanks for the help. I modified the sql query like this.

select obs_id as weights, obs_datetime as obsDatetime, value_numeric as valueNumeric, date_created from obs where obs_id = 7

But it is still the same.

dkayiwa · May 23, 2018, 12:53pm

Can you share a demo server link to your groovy script?

madushan · May 23, 2018, 12:57pm

@dkayiwa https://demo.openmrs.org/openmrs/module/reporting/reports/renderers/textTemplateReportRenderer.form?type=org.openmrs.module.reporting.report.renderer.TextTemplateRenderer&reportDesignUuid=da53df5f-04ac-470b-97d7-1ee23b31d547&reportDefinitionUuid=822057fb-d9ab-4cce-8a21-55d2ae05866e&successUrl=/openmrs/module/reporting/reports/reportEditor.form?uuid=822057fb-d9ab-4cce-8a21-55d2ae05866e

dkayiwa · May 23, 2018, 2:39pm

Your link gives me a null pointer exception

madushan · May 24, 2018, 11:57am

@dkayiwa I am sorry for the inconvenience caused. @sthaiya helped me to figure out the mistake. Thank you very much for your help.

`SELECT value_numeric as weights FROM obs'

would solve the issue.