Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-274043 - UAP TM-3376 then update Swink to 19.1.0614.1367 |https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-274043]
*This issue relates to i21 Help Desk ticket:* [ HDTN-273582 - Can Not save when adding a new Lease|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-273582]
+Background:+
* {color:#0f0f0f}Cannot save when creating a new lease.{color}
* {color:#0f0f0f}Upon investigation, device {color}was not entered during the creation of lease.
* Customer, then, requested for a query that will delete the lease for company 01.
+Requirements:+
* Run a script that will delete all lease except for records with present 'Last Lease Bill Date'
+Steps:+
# Backup database before running the script.
# Check the records in the Lease screen.
# Execute the query:
BEGIN TRAN
DELETE tblTMLease WHERE dtmLastLeaseBillingDate IS NULL
COMMIT TRAN
# Verify that all records except with the 'Last Lease Bill Date' are deleted.
|