Help Version number: local
Contact us
If you have any questions or problems using the system, please get in touch at the email listed below.
- University of Washington
- E-mail: cirg-adm+inform-clinic-help@uw.edu
Operating systems and web browsers that work with Let's Talk Tech
- Supported Browsers:
- Google Chrome: all versions
- Firefox: version 54 and above
- Safari: version 11 and above
- Internet Explorer: Edge and above
- iPad and iPhone:
- Standard iPad web browser (Safari 11 and above)
- Android:
- Google Chrome
- Firefox
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `UserAclLeaf`.`id`, `UserAclLeaf`.`user_id`, `UserAclLeaf`.`acl_alias`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`change_pw_flag`, `User`.`clinic_id`, `User`.`language`, `User`.`last4ssn`, `User`.`registered`, `User`.`study_group`, `User`.`external_id`, `User`.`email_confirmed`, `User`.`alt_contact_email`, `User`.`phone1`, `User`.`agreed_to_terms`, `User`.`birthdate`, `User`.`comm_pref`, `User`.`phone1_confirmed`, (IFNULL(`User`.`email`, `User`.`phone1`)) AS `User__email_or_phone` FROM `cpro`.`user_acl_leafs` AS `UserAclLeaf` LEFT JOIN `cpro`.`users` AS `User` ON (`UserAclLeaf`.`user_id` = `User`.`id`) WHERE `UserAclLeaf`.`user_id` IS NULL | 0 | 0 | 1 | |
| 2 | SELECT `Clinic`.`id`, `Clinic`.`site_id`, `Clinic`.`name`, `Clinic`.`friendly_name`, `Clinic`.`support_name`, `Clinic`.`state`, `Clinic`.`irb_contact`, `Clinic`.`support_email`, `Clinic`.`support_phone`, `Clinic`.`patient_status_email`, `Clinic`.`one_usual_care_session`, `Site`.`id`, `Site`.`name`, `Site`.`friendly_name`, `Site`.`timezone`, `Site`.`research_staff_email_alias`, `Site`.`research_staff_signature`, `Site`.`new_aim_consent_mod_date` FROM `cpro`.`clinics` AS `Clinic` LEFT JOIN `cpro`.`sites` AS `Site` ON (`Clinic`.`site_id` = `Site`.`id`) WHERE 1 = 1 | 1 | 1 | 1 | |
| 3 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`change_pw_flag`, `User`.`clinic_id`, `User`.`language`, `User`.`last4ssn`, `User`.`registered`, `User`.`study_group`, `User`.`external_id`, `User`.`email_confirmed`, `User`.`alt_contact_email`, `User`.`phone1`, `User`.`agreed_to_terms`, `User`.`birthdate`, `User`.`comm_pref`, `User`.`phone1_confirmed`, (IFNULL(`User`.`email`, `User`.`phone1`)) AS `User__email_or_phone` FROM `cpro`.`users` AS `User` WHERE `User`.`clinic_id` = (1) | 8 | 8 | 1 | |
| 4 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `cpro`.`aros` AS `Aro` WHERE `Aro`.`alias` = 'aroPatientTechSupport' LIMIT 1 | 1 | 1 | 0 | |
| 5 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght`, `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete` FROM `cpro`.`acos` AS `Aco` JOIN `cpro`.`aros_acos` AS `Permission` ON (`Permission`.`aro_id` = 26 AND `Permission`.`aco_id` = `Aco`.`id`) | 4 | 4 | 1 | |
| 6 | SELECT `Aro`.`lft`, `Aro`.`rght` FROM `cpro`.`aros` AS `Aro` WHERE 1 = 1 AND `Aro`.`id` = 26 LIMIT 1 | 1 | 1 | 0 | |
| 7 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `cpro`.`aros` AS `Aro` WHERE 1 = 1 AND `Aro`.`rght` < 55 AND `Aro`.`lft` > 54 ORDER BY `Aro`.`lft` asc | 0 | 0 | 0 | |
| 8 | SELECT `UserAclLeaf`.`id`, `UserAclLeaf`.`user_id`, `UserAclLeaf`.`acl_alias`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`change_pw_flag`, `User`.`clinic_id`, `User`.`language`, `User`.`last4ssn`, `User`.`registered`, `User`.`study_group`, `User`.`external_id`, `User`.`email_confirmed`, `User`.`alt_contact_email`, `User`.`phone1`, `User`.`agreed_to_terms`, `User`.`birthdate`, `User`.`comm_pref`, `User`.`phone1_confirmed`, (IFNULL(`User`.`email`, `User`.`phone1`)) AS `User__email_or_phone` FROM `cpro`.`user_acl_leafs` AS `UserAclLeaf` LEFT JOIN `cpro`.`users` AS `User` ON (`UserAclLeaf`.`user_id` = `User`.`id`) WHERE `UserAclLeaf`.`user_id` IS NULL | 0 | 0 | 1 |