schema.mysql\4.1.7\upgrade\etc\rt - freeside.git - Freeside billing, trouble ticketing, network monitoring and provisioning

index : freeside.git

Freeside billing, trouble ticketing, network monitoring and provisioning

Git T. F. Source

summary refs log tree commit diff

path: root/rt/etc/upgrade/4.1.7/schema.mysql

blob: 95013f3335a75e503008a8f240b0f3be8a00485f (plain)

UPDATE Transactions
SET TimeTaken
    = COALESCE(NewValue,0)
    - COALESCE(OldValue,0)
WHERE ObjectType = 'RT::Ticket' AND Type = 'Set' AND Field = 'TimeWorked';