Downloads Documentation Community
Contribute
Contribute Demo






Show Sidebar
Login | Register


Ticket #634 (assigned defect)

Opened 9 months ago

Last modified 7 months ago

Unlabeled symptom durations in Encounter view

Reported by: cmack Assigned to: bwolfe (accepted)
Priority: major Milestone: OpenMRS 1.3
Component: OpenMRS Code Base Keywords:
Cc: djazayeri Introductory Ticket:

Description

In the TB Screening section (it’s really similar to the adult DDB) the symptom concepts and duration of symptoms aren’t matching up with the system present findings. You can see that in the attached screen shot—Symptom present is below the big chart, but and there are unlabeled duration of symptom in days observations in the big chart. To make the form I just duplicated the schema for the Adult RV. The symptoms and their durations are showing up correctly when I test the Adult RV, so I’m not sure why this isn’t working. The form is saved as PROGRAMME PEDI VIH –RENDEZ-VOUS- Rwanda (v.1.0)

Attachments

Rwanda Pedi RV error.JPG (84.5 kB) - added by bwolfe on 03/05/08 14:15:41.
obsGroup.zip (19.1 kB) - added by djazayeri on 03/06/08 22:53:47.

Change History

02/26/08 17:41:00 changed by bwolfe

If its just a matter of visually displaying it correctly, this /should/ be solved by the obs_group fix that I'm working on: #392

03/05/08 14:15:23 changed by bwolfe

Claire, can you give me the data for this encounter? I'm testing my new obs group code and I want to make sure this is displayed correctly.

I'll need these five tables: select * from obs where encounter_id = ? select * from concept where concept_id in (select concept_id from obs where encounter_id = ?) select * from concept_name where concept_id in (select concept_id from obs where encounter_id = ?) select * from field where field_id in (select field_id from form_field where form_id in (select form_id from encounter where encounter_id = ?)) select * from form_field where form_id in (select form_id from encounter where encounter_id = ?) (I don't need data on the patient or the encounter, I can make those up)

03/05/08 14:15:41 changed by bwolfe

  • attachment Rwanda Pedi RV error.JPG added.

03/06/08 22:53:47 changed by djazayeri

  • attachment obsGroup.zip added.

03/06/08 22:55:52 changed by djazayeri

I did the queries with mysql query browser, and exported them as xml. Hopefully you can deal with this format.

03/07/08 18:33:47 changed by bwolfe

  • owner changed from djazayeri to bwolfe.
  • status changed from new to assigned.

No xml doesn't really help me. mysqlimport and "load data into" don't really like those files. Can 't you export them as sql easy enough?

03/07/08 22:54:16 changed by djazayeri

MySQL Query Browser won't export as insert statements.

I tried using Oracle SQLDeveloper, which is supposed to be able to, but my installation appears hosed.

03/07/08 22:54:45 changed by djazayeri

Incidentally for my own reference this is encounter id 32948

03/12/08 21:10:28 changed by bwolfe

  • cc set to djazayeri.
  • milestone set to OpenMRS 1.3.

Darius, I only need the obs rows now. I found some other pih data callen had given me.

You can get the sql using mysqldump 

mysqldump -uroot -p -w"encounter_id = 32948" openmrs-alpha obs > obs_for_32948.sql

...or if you want to zip it in the same step 

mysqldump -uroot -p -w"encounter_id = 32948" openmrs obs | zip obs_for_32948.zip -

04/16/08 21:42:21 changed by bwolfe

Claire, have you tested this with the latest trunk code? Is this resolved?