projects
/
freeside.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
b53dceb021e1cd08864b604c2109e678a2f2799c
[freeside.git]
/
rt
/
etc
/
upgrade
/
4.1.7
/
schema.Oracle
1
UPDATE Transactions
2
SET TimeTaken
3
= COALESCE(TO_NUMBER(REGEXP_SUBSTR(NewValue, '^-?\d+$')), 0)
4
- COALESCE(TO_NUMBER(OldValue),0)
5
WHERE ObjectType = 'RT::Ticket' AND Type = 'Set' AND Field = 'TimeWorked';