Answers.Body: <p>Unfortunately, there is no way to batch update relationship via the user interface b/c relationships are reciprocal. Using the Import Contacts wizard and selecting "Update" doesn't allow you to designate a relationship as permissioned either. </p>
  
  <p>If you have a programmer on hand, this type of update would be easy to do using an SQL query directly on the database:</p>
  
  <p>Assumptions:</p>
  
  <ul>
  <li>Relationship Type ID = 4 (in my environment, this is the ID for Employee/Employer)</li>
  <li>Contact A = Individual</li>
  <li>Contact B = Organization</li>
  </ul>
  
  <p>Query:</p>
  
  <p>UPDATE <code>civicrm_relationship</code> SET <code>is_permission_a_b</code>= 1 WHERE <code>relationship_type_id</code>= 4</p>
  
  <p>Alternatively, if you have sufficient permissions, you could use API Explorer as documented <a href="https://docs.civicrm.org/dev/en/latest/api/" rel="nofollow noreferrer">HERE</a>, but this should only be done by someone who has good knowledge of the CiviCRM database structure.</p>
  
  <p>Good luck!</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-09-18T23:25:16.890Z
Answers.LastActivityDate: 2018-09-18T23:25:16.890Z
Answers.UserDisplayName: Tamar Meir - Cividesk
Body: <p>We have a specific contact/organization relationship type that should be a permissioned relationship for the contact to edit the organizations record.  When we converted to Civi many of these contacts did not get the permissioned relationship check box checked. Is there a way to update the Permissioned Ralationship check box for this specific relationship type in bulk? </p>
  
Tags: <permissions><relationships>
Title: Batch Update Permissioned Relationships
ThreadText: # Batch Update Permissioned Relationships
  
  (Asked by: username_0 on 2018-09-18)
  
  We have a specific contact/organization relationship type that should be a permissioned relationship for the contact to edit the organizations record. When we converted to Civi many of these contacts did not get the permissioned relationship check box checked. Is there a way to update the Permissioned Ralationship check box for this specific relationship type in bulk?
  
  **Tags:** permissions, relationships
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2018-09-18. Score: 2
  
  Unfortunately, there is no way to batch update relationship via the user interface b/c relationships are reciprocal. Using the Import Contacts wizard and selecting "Update" doesn't allow you to designate a relationship as permissioned either.
  
  If you have a programmer on hand, this type of update would be easy to do using an SQL query directly on the database:
  
  Assumptions:
  
  * Relationship Type ID = 4 (in my environment, this is the ID for Employee/Employer)
  * Contact A = Individual
  * Contact B = Organization
  
  Query:
  
  UPDATE `civicrm_relationship` SET `is_permission_a_b`= 1 WHERE `relationship_type_id`= 4
  
  Alternatively, if you have sufficient permissions, you could use API Explorer as documented [HERE](https://docs.civicrm.org/dev/en/latest/api/), but this should only be done by someone who has good knowledge of the CiviCRM database structure.
  
  Good luck!
  
  
  ---
  
  