Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-303558 - DB Restore Request for HDTN-295474|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-303558]
*This issue relates to i21 Help Desk ticket:* [ HDTN-295474 - Filter out the packaging materials from Production report|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-295474]
*Steps:*
1. Query existing views.
*Issue:*
The datetime field is having additional 0s highlighted below. Please remove these 0s from all DATETIME field of the following views:
vyuMFGetProduction
vyuMFGetRMUsageByLot
vyuMFGetOverAndUnderWeight
vyuMFGetRMUsage
vyuMFGetReceiving
uspMFProductionReport
!pastedImage_d219326_0.png|height=290,width=550!
*Acceptance:*
Datetime field should not have trailing zeros.
|