Skip to main content
Skip table of contents

Land - Updating the Lease/Agreement Number via scripting.

Clients may request a lease number update due to incorrect input or post-creation changes. This operation can be only performed via scripting to adjust the lease number or Agreement number directly in the database, ensuring data consistency and accurate linkage with related records.

Example - Client’s request:

“Lease E0-5615-0004 was sold so the lease number needs to be changed to E0-5615-0005”

📘 Instructions

Please follow the instructions below to apply the changes requested by the clients.

  1. Verify the field to modify to check the incorrect value.

    1. Through the UI

      image-20251020-204332.png
    2. Via DB

      SQL
      select * from agreements where number='E0-5615-0004';
    3. Double-check the record ID to create the updated based on ID.

  2. Create the update script to verify the number in the client’s project box.

    SQL
    update a
    set number='E0-5615-0005'
    from agreements a
    where id=7044;
image-20251020-225959.png
  1. Once verified, deploy the Script in a Non-Prod environment.

  2. Deploy the Script in Prod after receiving approval from the client.

NOTE: Please remember to always get confirmation from the client before deploying any Script in Non-Prod and Prod.

📋 Similar tickets

WESS-16572

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.