This release includes:
- New SQL-only Mode: Setting
sqlOnly
andsqlOnlyIncrementalInsert
to TRUE inexecuteDqChecks
will return (but not run) a set of SQL queries that, when executed, will calculate the results of the DQ checks and insert them into a database table. Additionally,sqlOnlyUnionCount
can be used to specify a number of SQL queries to union for each check type, allowing for parallel execution of these queries and potentially large performance gains. See the SqlOnly vignette for details - Results File Case Converter: The new function
convertJsonResultsFileCase
can be used to convert the keys in a DQD results JSON file between snakecase and camelcase. This allows reading of v2.1.0+ JSON files in older DQD versions, and other conversions which may be necessary for secondary use of the DQD results file. See function documentation for details
- In the v2.1.0 release, all DQD variables were converted from snakecase to camelcase, including those in the results JSON file. This resulted in errors for users trying to view results files generated by older DQD versions in DQD v2.1.0+. This issue has now been fixed.
viewDqDashboard
will now automatically convert the case of pre-v2.1.0 results files to camelcase so that older results files may be viewed in v2.3.0+
This release includes:
cohortTableName
parameter added toexecuteDqChecks
. Allows user to specify the name of the cohort table when running DQD on a cohort. Defaults to"cohort"
- Fixed several bugs in the default threshold files:
- Updated plausible low value for specimen quantity from 1 to 0
- Removed foreign key domains for episode object concept ID (multitude of plausible domains make checking this field infeasible)
- Updated date format for hard-coded dates to
YYYYMMDD
to conform to SqlRender standard - Added DEATH checks to v5.2 and v5.3
- Fixed field level checks to incorporate user-specified
vocabDatabaseSchema
andcohortDatabaseSchema
where appropriate
- Removed
outputFile
parameter from DQD setup vignette (variable not set in script) - Removed hidden BOM character from several threshold csv files, and updated csv read method to account for BOM character moving forward. This character caused an error on some operating systems
And some minor documentation updates for clarity/accuracy.
- Fixing bug in cdmDatatype check SQL that was causing NULL values to fail the check.
- Updating author list in DESCRIPTION.
This release includes:
- cdmDatatype check, which checks that values in integer columns are integers, updated so that float values will now fail the check
- Quotes removed from
offset
column name in v5.4 thresholds file so that this column is skipped by DQD in all cases (use of reserved word causes failures in some SQL dialects) - Broken images fixed in addNewCheck vignette
- All snakecase variables updated to camelcase
- Global variable binding R Check note resolved
This release includes:
- Not Applicable identifies checks with no data to support them
- Error identifies checks that failed due to a SQL error
- measureConditionEraCompleteness checks to make sure that every person with a Condition_Era record have a record in Condition_Occurrence as well
- withinVisitDates looks at clinical facts and the visits they are associated with to make sure that the visit dates occur within one week on either side of the visit
- plausibleUnitConceptIds identifies records with invalid Unit_Concept_Ids by Measurement_Concept_Id
- The
outputFolder
parameter for theexecuteDqChecks
function is now REQUIRED and no longer has a default value. This may be a breaking change for users who have not specified this parameter in their script to run DQD.
No material changes from v1.4, this adds a correct DESCRIPTION
file
with the correct DQD version
This release provides support for CDM v5.4
and incorporates minor bug fixes
related to incorrectly assigned checks in the control files.
This fixes a small bug and removes a duplicate record in the concept level checks that was throwing an error.
This release includes additional concept level checks to support
the OHDSI Symposium 2020 study-a-thon and bug fixes to the writeJSONToTable
function.
This is the release that study-a-thon data partners should use.
This is a bug fix release that updates how notes are viewed in the UI and adds CDM table, field, and check name to the final table.
This release of the Data Quality Dashboard incorporates the following features:
- Addition of notes fields in the threshold files
- Addition of notes to the UI
- Functionality to run the DQD on a cohort
- Fixes the
writeToTable
,writeJsonToTable
functions
This is the first release of the OHDSI Data Quality Dashboard tool.