bug: CCDA import creates extra entries in list_options for drug_units list_id #7319
Assignees
Labels
Bug
developers
This issue targets an issue that is for developers/collaborators/module writers/technical users
Milestone
Comments
|
Note this bug slows down the patient summary screen immensely once you have a number of patients due to how large the drug_units table becomes. This causes the immunization / prescription queries on the patient summary screen to get extremely slow. To fix this we need to look at only inserting the entries in the InsertImmunization screen function if there are actual data values to insert. |
|
Looks like the same bug happens in CdaTemplateImportDispose->InsertPrescriptions |
adunsulag
added a commit
to DiscoverAndChange/openemr
that referenced
this issue
Apr 5, 2024
This fixes the error in the ccda that was creating tons of entries in the drug_entry list options list. The CCDA was not checking against empty values and would continue to create new list_options for each immunization / prescription drug_unit when the unit was an empty string I also added some debugging instruments on the prescription and immunization process which makes it easy to compare for a ccda what is being parsed and what is being stored in the database. Added a debug flag to all of the ccda commands so that these options are available for people needing to do any debugging of the process.
adunsulag
added a commit
that referenced
this issue
Apr 7, 2024
* Fixes #7319 ccda extra drug_unit list options This fixes the error in the ccda that was creating tons of entries in the drug_entry list options list. The CCDA was not checking against empty values and would continue to create new list_options for each immunization / prescription drug_unit when the unit was an empty string I also added some debugging instruments on the prescription and immunization process which makes it easy to compare for a ccda what is being parsed and what is being stored in the database. Added a debug flag to all of the ccda commands so that these options are available for people needing to do any debugging of the process. * Exclude 0 values from amount administered checks. We decided that we wanted to exclude recording 0 values so updated the conditions on the immunization and prescription to account for that.
stephenwaite
pushed a commit
to stephenwaite/openemr
that referenced
this issue
Apr 7, 2024
* Fixes openemr#7319 ccda extra drug_unit list options This fixes the error in the ccda that was creating tons of entries in the drug_entry list options list. The CCDA was not checking against empty values and would continue to create new list_options for each immunization / prescription drug_unit when the unit was an empty string I also added some debugging instruments on the prescription and immunization process which makes it easy to compare for a ccda what is being parsed and what is being stored in the database. Added a debug flag to all of the ccda commands so that these options are available for people needing to do any debugging of the process. * Exclude 0 values from amount administered checks. We decided that we wanted to exclude recording 0 values so updated the conditions on the immunization and prescription to account for that.
sjpadgett
pushed a commit
to sjpadgett/openemr
that referenced
this issue
Apr 16, 2024
* Fixes openemr#7319 ccda extra drug_unit list options This fixes the error in the ccda that was creating tons of entries in the drug_entry list options list. The CCDA was not checking against empty values and would continue to create new list_options for each immunization / prescription drug_unit when the unit was an empty string I also added some debugging instruments on the prescription and immunization process which makes it easy to compare for a ccda what is being parsed and what is being stored in the database. Added a debug flag to all of the ccda commands so that these options are available for people needing to do any debugging of the process. * Exclude 0 values from amount administered checks. We decided that we wanted to exclude recording 0 values so updated the conditions on the immunization and prescription to account for that. (cherry picked from commit 0b1be28)
adunsulag
added
the
developers
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
When running the CCDA import process with a CCDA for a patient the CdaTemplateImportDispose->InsertImmunization() function is creating empty list_option entries for the drug_units list_id.
You can reproduce this easily by running the
openemr-cmd irp 20utility command or by passing a CCDA directly with the following command (run in the easy-dev docker environment)This was discovered in the latest OpenEMR master release and likely exists in OpenEMR 7.0.2.
The text was updated successfully, but these errors were encountered: