Skip to content

Custom rule based data quality resolutions not included in export #1

@jmcarson

Description

@jmcarson

We are working on incorporating this module to find outstanding data queries.

If you open a query on a custom rule the query is not included in the export. My suspicion is that the following line in export.php is causing them to be excluded:

-- join to metadata to exclude fields that no longer exist (like REDCap does programmatically)
JOIN redcap_metadata m
	ON m.project_id = $project_id
	AND s.field_name = m.field_name

custom rules do not have a field_name associated with them so will be filtered out. Possibly updating to something like this:

-- join to metadata to exclude fields that no longer exist (like REDCap does programmatically)
JOIN redcap_metadata m
	ON m.project_id = $project_id
	AND (s.field_name is null or s.field_name = m.field_name)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions