projects
/
freeside.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
debug
[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';