diff options
Diffstat (limited to 'rt/etc')
| -rw-r--r-- | rt/etc/drop.Oracle | 6 | ||||
| -rw-r--r-- | rt/etc/initialdata | 40 |
2 files changed, 43 insertions, 3 deletions
diff --git a/rt/etc/drop.Oracle b/rt/etc/drop.Oracle index 4ce5de475..475e984e1 100644 --- a/rt/etc/drop.Oracle +++ b/rt/etc/drop.Oracle @@ -14,7 +14,8 @@ DROP TABLE SCRIPCONDITIONS; DROP TABLE SCRIPS; DROP TABLE SESSIONS; DROP TABLE TEMPLATES; -DROP TABLE TICKETCUSTOMFIELDVALUES; +DROP TABLE OBJECTCUSTOMFIELDS; +DROP TABLE OBJECTCUSTOMFIELDVALUES; DROP TABLE TICKETS; DROP TABLE TRANSACTIONS; DROP TABLE USERS; @@ -33,7 +34,8 @@ DROP SEQUENCE SCRIPACTIONS_seq; DROP SEQUENCE SCRIPCONDITIONS_seq; DROP SEQUENCE SCRIPS_seq; DROP SEQUENCE TEMPLATES_seq; -DROP SEQUENCE TICKETCUSTOMFIELDVALUES_seq; +DROP SEQUENCE OBJECTCUSTOMFIELDVALUES_seq; +DROP SEQUENCE OBJECTCUSTOMFIELDS_seq; DROP SEQUENCE TICKETS_seq; DROP SEQUENCE TRANSACTIONS_seq; DROP SEQUENCE USERS_seq; diff --git a/rt/etc/initialdata b/rt/etc/initialdata index 3a21ce1f6..54fa9d195 100644 --- a/rt/etc/initialdata +++ b/rt/etc/initialdata @@ -136,7 +136,7 @@ Description => 'Create new tickets based on this scrip\'s template', # loc ExecModule => 'CreateTickets', }, - { Name => 'Open Tickets', + { Name => 'Open Tickets', # loc Description => 'Open tickets on correspondence', # loc ExecModule => 'AutoOpen' }, ); @@ -585,3 +585,41 @@ return 0; # ignore $passed; Right => 'SuperUser', }, ); + +# Predefined searches + +@Attributes = ( + { Name => 'Search - My Tickets', + Description => '[_1] highest priority tickets I own', # loc + Content => + { Format => "'<a href=\"__WebPath__/Ticket/Display.html?id=__id__\">__id__</a>/TITLE:#', '<a href=\"__WebPath__/Ticket/Display.html?id=__id__\">__Subject__</a>/TITLE:Subject', Priority, QueueName, ExtendedStatus", + Query => " Owner = '__CurrentUser__' AND ( Status = 'new' OR Status = 'open')", + OrderBy => 'Priority', + Order => 'DESC' }, + }, + { Name => 'Search - Unowned Tickets', + Description => '[_1] newest unowned tickets', # loc + Content => +# 'Take' #loc + { Format => "'<a href=\"__WebPath__/Ticket/Display.html?id=__id__\">__id__</a>/TITLE:#', '<a href=\"__WebPath__/Ticket/Display.html?id=__id__\">__Subject__</a>/TITLE:Subject', QueueName, ExtendedStatus, CreatedRelative, '<A HREF=\"__WebPath__/Ticket/Display.html?Action=Take&id=__id__\">__loc(Take)__</a>/TITLE: ' ", + Query => " Owner = 'Nobody' AND ( Status = 'new' OR Status = 'open')", + OrderBy => 'Created', + Order => 'DESC' }, + }, + { Name => 'HomepageSettings', + Description => 'HomepageSettings', + Content => + { 'body' => # loc + [ { type => 'system', name => 'My Tickets' }, + { type => 'system', name => 'Unowned Tickets' }, + { type => 'component', name => 'QuickCreate'}, + ], + 'summary' => # loc + [ + { type => 'component', name => 'MyReminders' }, + { type => 'component', name => 'Quicksearch' }, + { type => 'component', name => 'RefreshHomepage' }, + ] + }, +} +); |