Answers.Body: <p>I'm guessing you already looked at <a href="https://civicrm.stackexchange.com/questions/3807/batch-update-relationships?rq=1">Batch Update Relationships</a> although it seems like maybe the extension technique isn't working anymore.</p>
  
  <p>The below is maybe only a step above running some SQL directly and I don't recommend it for the average office staffer but it seems to work and is mostly straightforward. The danger is if you get the criteria wrong you might update way more relationship records than you thought.</p>
  
  <ol>
  <li>Visit [your_site_url]/civicrm/api4</li>
  <li>Make it look like this screenshot, where you pick the appropriate org contact and set the end date at the bottom to the appropriate date.</li>
  <li><a href="https://i.sstatic.net/jgVPX.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/jgVPX.png" alt="api screenshot"></a></li>
  <li>Optionally add a "where" criteria for a specific relationship type or types.</li>
  <li>Click Execute.</li>
  <li>At the bottom right you should see a list of the updated ones.</li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-07-12T22:40:20.150Z
Answers.Text: I love the import plugin you suggested (API CSV Import GUI extension). Thank you.
Answers.UserDisplayName: Stacey
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-07-01T03:14:26.920Z
Answers.LastActivityDate: 2019-07-01T03:14:26.920Z
Answers.UserDisplayName: Demerit
Answers.Body: <p>With SearchKit, probably from version 5.43, it will be possible to do in-place edits of relationship fields as start and end dates, is active and custom fields. <a href="https://github.com/civicrm/civicrm-core/pull/21533" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/pull/21533</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-09-19T19:04:25.763Z
Answers.LastActivityDate: 2021-09-19T19:04:25.763Z
Answers.UserDisplayName: Francesc Bassas i Bullich
Body: <p>Suppose I am using relationships for specific classes where the student in a class (organization) may not have a start and end date. Is there a way for me to look up a particular class and globally update all the students/relationships by adding an end date when that class ends?</p>
  
  <p>I am talking about the relationship between a company (class) and an individual (student) in the join table, not the current "employer" field on the individual record.</p>
  
  <p>Ideally, i would like to globally import end dates but can't do that without the relationship key. Is there a way to create a profile listing all current relationships of an organization where I can manually set end dates for students in a editable spreadsheet/profile format? I have many students assigned to classes that have ended and want to globally end those relationships without having to go to mySQL.</p>
  
  <p>In other words, I need to create a listing of all the "active" relationships of an organization so I can easily edit start and end dates without a pop-up form.</p>
  
Tags: <relationships>
Title: Is there the ability to globally update relationship end dates or add them to a profile for bulk updates?
ThreadText: # Is there the ability to globally update relationship end dates or add them to a profile for bulk updates?
  
  (Asked by: username_0 on 2019-06-30)
  
  Suppose I am using relationships for specific classes where the student in a class (organization) may not have a start and end date. Is there a way for me to look up a particular class and globally update all the students/relationships by adding an end date when that class ends?
  
  I am talking about the relationship between a company (class) and an individual (student) in the join table, not the current "employer" field on the individual record.
  
  Ideally, i would like to globally import end dates but can't do that without the relationship key. Is there a way to create a profile listing all current relationships of an organization where I can manually set end dates for students in a editable spreadsheet/profile format? I have many students assigned to classes that have ended and want to globally end those relationships without having to go to mySQL.
  
  In other words, I need to create a listing of all the "active" relationships of an organization so I can easily edit start and end dates without a pop-up form.
  
  **Tags:** relationships
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2019-07-01. Score: 2
  
  I'm guessing you already looked at [Batch Update Relationships](https://civicrm.stackexchange.com/questions/3807/batch-update-relationships?rq=1) although it seems like maybe the extension technique isn't working anymore.
  
  The below is maybe only a step above running some SQL directly and I don't recommend it for the average office staffer but it seems to work and is mostly straightforward. The danger is if you get the criteria wrong you might update way more relationship records than you thought.
  
  1. Visit [your\_site\_url]/civicrm/api4
  2. Make it look like this screenshot, where you pick the appropriate org contact and set the end date at the bottom to the appropriate date.
  3. [![api screenshot](https://i.sstatic.net/jgVPX.png)](https://i.sstatic.net/jgVPX.png)
  4. Optionally add a "where" criteria for a specific relationship type or types.
  5. Click Execute.
  6. At the bottom right you should see a list of the updated ones.
  
  > **Comments:**
  > **username_0**: I love the import plugin you suggested (API CSV Import GUI extension). Thank you.  
  
  ---
  
  ### Answer by username_2 on 2021-09-19. Score: 1
  
  With SearchKit, probably from version 5.43, it will be possible to do in-place edits of relationship fields as start and end dates, is active and custom fields. <https://github.com/civicrm/civicrm-core/pull/21533>
  
  
  ---
  
  