This is a bit hard to explain but I will do my best. I have an example of data that is part of a repeating group being shown in the wrong row. The screen shot shows 2 rows. The Onset Exact Age: column shows a value of 51 in the first row when it should be in the second. If I export the data in the CDISC format it is actually formatted correctly. A snippet of the XML is below. I have included a copy of the drop down values from the CRF so that you can see the value of Sister is 5 and Mother is 1 (for field I_MEDIC_FAMILYMEMBERMEMORYDEMENTIA), and that the value of 51 for onset age is in the ItemGroupRepeatKey with a value of 2, but is shown in the incorrect row in the screen shot being in the same row as the row with Mother a value of 1.
Looking in the data base the ordinal value is correctly set at 1 for the first row and 2 for the second row. If I directly insert a row in the item_data table with a value for this field and an ordinal of 1 pointing to the event_crf for field I_MEDIC_ONSETAGEMEMORYDEMENTIA it displays correctly. I am guessing it has something to do with an absence of data for the previous row. The version of OC is Version: 18.104.22.168.
I am not sure what other information you need. I have tried to limit it just to specifics but can supply the CRF etc if necessary.
Drop down values
Mother,Father,Grandmother,Grandfather,Sister,Brother,Aunt,Uncle,Cousin,Niece,Nephew, Great Grandmother, Great Grandfather
Thanks for your help.
Australian e-Health Research Centre
Phone: +61 7 3253 3613
Fax: +61 7 3253 3690
email: [email protected]
OpenClinicaScreenshot.JPG 38.7 KB