Check cdmTable and cdmField error in query

[dassagichnicht]

In the check "cdmTable" the most inner select statement is the following
SELECT CASE WHEN COUNT(*) = 0 THEN 0 ELSE 0 END AS num_violated_rows FROM hob_valid.CONDITION_OCCURRENCE cdmTable GROUP BY 1
However, this query results in 0 rows if the table is empty.

I think deleting the GROUP BY 1 solves the issue.

The same holds true for the check "cdmField".

Unfortunately, I couldn't find the files in which the checks are defined to check if the problem is still there or if I'm just using an old version.

[katy-sadowski]

Please let me know what version of DataQualityDashboard you are running. The GROUP BY clause is not in the current source SQL for this check: https://github.com/OHDSI/DataQualityDashboard/blob/main/inst/sql/sql_server/table_cdm_table.sql. However, if you are on the latest version of the package it's possible this is a SqlRender issue.

[katy-sadowski]

@dassagichnicht I am going to close this issue for now but please let me know if you continue to have problems after updating the package.