CiviCRM Graphic 2 Patient Export

Direct Query

Requirements

1. Bring across consents and IDs etc from the civicrm_value_graphic2_10 table.
2. Check that the patient has one of the required statuses in the civicrm_case.status_id column. (Define what these are ~ recruited, completed, etc)