schema.Oracle\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.Oracle

blob: b53dceb021e1cd08864b604c2109e678a2f2799c (plain)

UPDATE Transactions
SET TimeTaken
    = COALESCE(TO_NUMBER(REGEXP_SUBSTR(NewValue, '^-?\d+$')), 0)
    - COALESCE(TO_NUMBER(OldValue),0)
WHERE ObjectType = 'RT::Ticket' AND Type = 'Set' AND Field = 'TimeWorked';