Hi Gustavo, On 27.09.2009, at 15:43, Gustavo Azambuja wrote:
Hi, where I can find all valid "Attributes"? In OTRS, I can find this: StateType, TicketPendingTimeOlderMinutes but where I can find all valid keys and values? (StateName?? TicketNumber??...)
http://dev.otrs.org/ -> OTRS 2.4 -> Kernel::System::Ticket -> TicketSearch [...] # ticket number (optional) as STRING or as ARRAYREF TicketNumber => '%123546%', TicketNumber => ['%123546%', '%123666%'], # ticket title (optional) as STRING or as ARRAYREF Title => '%SomeText%', Title => ['%SomeTest1%', '%SomeTest2%'], Queues => ['system queue', 'other queue'], QueueIDs => [1, 42, 512], # use also sub queues of Queue|Queues in search UseSubQueues => 0, # You can use types like normal, ... Types => ['normal', 'change', 'incident'], TypeIDs => [3, 4], # You can use states like new, open, pending reminder, ... States => ['new', 'open'], StateIDs => [3, 4], # (Open|Closed) tickets for all closed or open tickets. StateType => 'Open', # You also can use real state types like new, open, closed, # pending reminder, pending auto, removed and merged. StateType => ['open', 'new'], StateTypeIDs => [1, 2, 3], Priorities => ['1 very low', '2 low', '3 normal'], PriorityIDs => [1, 2, 3], Services => ['Service A', 'Service B'], ServiceIDs => [1, 2, 3], SLAs => ['SLA A', 'SLA B'], SLAIDs => [1, 2, 3], Locks => ['unlock'], LockIDs => [1, 2, 3], OwnerIDs => [1, 12, 455, 32] ResponsibleIDs => [1, 12, 455, 32] WatchUserIDs => [1, 12, 455, 32] # CustomerID (optional) as STRING or as ARRAYREF CustomerID => '123', CustomerID => ['123', 'ABC'], # CustomerUserLogin (optional) as STRING as ARRAYREF CustomerUserLogin => 'uid123', CustomerUserLogin => ['uid123', 'uid777'], # create ticket properties (optional) CreatedUserIDs => [1, 12, 455, 32] CreatedTypes => ['normal', 'change', 'incident'], CreatedTypeIDs => [1, 2, 3], CreatedPriorities => ['1 very low', '2 low', '3 normal'], CreatedPriorityIDs => [1, 2, 3], CreatedStates => ['new', 'open'], CreatedStateIDs => [3, 4], CreatedQueues => ['system queue', 'other queue'], CreatedQueueIDs => [1, 42, 512], # 1..16 (optional) TicketFreeKey1 => 'Product', TicketFreeText1 => 'adasd', # or with multi options as array ref or string possible TicketFreeKey2 => ['Product', 'Product2'], TicketFreeText2 => ['Browser', 'Sound', 'Mouse'], # 1..6 (optional) # tickets with free time after ... (optional) TicketFreeTime1NewerDate => '2006-01-09 00:00:01', # tickets with free time before ... (optional) TicketFreeTime1OlderDate => '2006-01-19 23:59:59', # article stuff (optional) From => '%spam@example.com%', To => '%support@example.com%', Cc => '%client@example.com%', Subject => '%VIRUS 32%', Body => '%VIRUS 32%', # use full text index if configured (optional, default off) FullTextIndex => 1, # content search (AND or OR) (optional) ContentSearch => 'AND', # content conditions for From,To,Cc,Subject,Body,TicketNumber, # Title,CustomerID and CustomerUserLogin (all optional) ConditionInline => 1, # articles created after 60 minutes (article newer than 60 minutes) (optional) ArticleCreateTimeOlderMinutes => 60, # articles created before 120 minutes (article older than 120 minutes) (optional) ArticleCreateTimeNewerMinutes => 120, # articles with create time after ... (article newer than this date) (optional) ArticleCreateTimeNewerDate => '2006-01-09 00:00:01', # articles with created time before ... (article older than this date) (optional) ArticleCreateTimeOlderDate => '2006-01-19 23:59:59', # tickets created after 60 minutes (ticket newer than 60 minutes) (optional) TicketCreateTimeOlderMinutes => 60, # tickets created before 120 minutes (ticket older than 120 minutes) (optional) TicketCreateTimeNewerMinutes => 120, # tickets with create time after ... (ticket newer than this date) (optional) TicketCreateTimeNewerDate => '2006-01-09 00:00:01', # tickets with created time before ... (ticket older than this date) (optional) TicketCreateTimeOlderDate => '2006-01-19 23:59:59', # tickets changed after 60 minutes (ticket changed newer than 60 minutes) (optional) TicketChangeTimeOlderMinutes => 60, # tickets changed before 120 minutes (ticket changed older 120 minutes) (optional) TicketChangeTimeNewerMinutes => 120, # tickets with changed time after ... (ticket changed newer than this date) (optional) TicketChangeTimeNewerDate => '2006-01-09 00:00:01', # tickets with changed time before ... (ticket changed older than this date) (optional) TicketChangeTimeOlderDate => '2006-01-19 23:59:59', # tickets closed after 60 minutes (ticket closed newer than 60 minutes) (optional) TicketCloseTimeOlderMinutes => 60, # tickets closed before 120 minutes (ticket closed older than 120 minutes) (optional) TicketCloseTimeNewerMinutes => 120, # tickets with closed time after ... (ticket closed newer than this date) (optional) TicketCloseTimeNewerDate => '2006-01-09 00:00:01', # tickets with closed time before ... (ticket closed older than this date) (optional) TicketCloseTimeOlderDate => '2006-01-19 23:59:59', # tickets pending after 60 minutes (optional) TicketPendingTimeOlderMinutes => 60, # tickets pending before 120 minutes (optional) TicketPendingTimeNewerMinutes => 120, # tickets with pending time after ... (optional) TicketPendingTimeNewerDate => '2006-01-09 00:00:01', # tickets with pending time before ... (optional) TicketPendingTimeOlderDate => '2006-01-19 23:59:59', # you can use all following escalation options with this four different ways of escalations # TicketEscalationTime... # TicketEscalationUpdateTime... # TicketEscalationResponseTime... # TicketEscalationSolutionTime... # ticket escalations over 60 minutes (optional) TicketEscalationTimeOlderMinutes => -60, # ticket escalations in 120 minutes (optional) TicketEscalationTimeNewerMinutes => -120, # tickets with escalation time after ... (optional) TicketEscalationTimeNewerDate => '2006-01-09 00:00:01', # tickets with escalation time before ... (optional) TicketEscalationTimeOlderDate => '2006-01-09 23:59:59', [...] :-D I hope it will help you! :) PS: Remember, changes my take up to 30 sec., because every ticket backend in dashboard get's cached (per default 30 sec.). -Martin