Skip to main content

system.kanoa.cmms.updateWorkOrderEventImage(workOrderEventImageId, workOrderEventId, imageName, imageType, imageDescription, imageBytes, thumbnail, userId)

Updates an existing work order event image record, identified by workOrderEventImageId, replacing its associated work order event link, name, type, description, image bytes, and thumbnail. A userId is passed for the audit trail. Returns the number of records affected along with a success/error message.


Parameters​

workOrderEventImageId Integer: Id of image to update
workOrderEventId Integer: Id of the workOrderEvent
imageName String: Name of image
imageType String: Type of image
imageDescription String: Description of image
imageBytes byteArray: The image in byteArray format
thumbnail byteArray: Thumbnail of image in byteArray format
userId Integer:Id of the user executing the function


Returns​

# of rows modified Integer
msg String None if success


Example​

# Replace the "before" photo on a work order event with a corrected
# image and regenerate its thumbnail.

workOrderEventImageId = 9137
workOrderEventId = 4821
userId = system.kanoa.security.getIDPUserId({'userName': 'SYSTEM'})

newImageBytes = system.file.readFileAsBytes('C:/temp/repair_before_v2.jpg')
newThumbBytes = system.file.readFileAsBytes('C:/temp/repair_before_v2_thumb.jpg')

rowsUpdated, msg = system.kanoa.cmms.updateWorkOrderEventImage(
workOrderEventImageId,
workOrderEventId,
'repair_before_v2.jpg',
'JPEG',
'Before photo - hydraulic leak on pump housing (corrected orientation)',
newImageBytes,
newThumbBytes,
userId
)