List of Indexed Attributes

Below is a comprehensive list of all object attributes indexed by Elasticsearch. In other words, if you wish to find a ticket, article, or user via the Zammad search box, Elasticsearch can match on any (or all) of the fields below.

Note

These fields may vary if you created custom fields (objects) in the admin interface.

Ticket

Field Sample Value Description
article Article Article Hash, which includes all articles stored on a ticket
article_count 1 Count of articles
close_at null First close time, after create
close_diff_in_min null Business hours in minutes within or above the specified SLA for closing the ticket
close_escalation_at null Time stamp of the escalation if the SLA of the closing time has been violated (DateTime, UTC)
close_in_min null Business hours in minutes it took to close the ticket
create_article_sender Customer Who has created the first article (Agent, Customer)
create_article_sender_id 2 Sender id of the first article (Agent|Customer)
create_article_type web Article type for the first article (note, email, phone…)
create_article_type_id 11 Article type ID for the first article (note, email, phone…)
created_at 2017-08-03T14:21:38.701Z Created timestamp (DateTime, UTC)
created_by User User details of the user who created the ticket
created_by_id 13 User id of user who created the ticket
customer User Customer details
customer_id 13 User id of the current customer (assigned to ticket)
escalation_at null Next first escalation date (nearest close_escalation_at, first_response_escalation_at or update_escalation_at (DateTime, UTC)
first_response_at null Time stamp of the first reaction to the customer (DateTime, UTC)
first_response_diff_in_min null Business hours in minutes within or above the specified SLA for the first reaction to the customer.
first_response_escalation_at null Time stamp of the escalation if the SLA of the first reaction time has been violated. (DateTime, UTC)
first_response_in_min null Business hours in minutes it took to send inital response to customer.
group Sales Current ticket group (Sales, Support…)
group_id 1 Current ticket group id
id 19 Ticket id
last_contact_agent_at null Last contact to customer from agent, timestamp (DateTime, UTC)
last_contact_at 2017-08-03T14:21:38.701Z Last contact timestamp (DateTime, UTC)
last_contact_customer_at 2017-08-03T14:21:38.701Z Last contact from a customer, timestamp (DateTime, UTC)
note null Internal note for ticket
number 61019 The uniq ticket number
organization_id null Id of the organization of a given customer
owner User Current owner (agent)
owner_id 1 User id of owner
pending_time null Current pending time (DateTime, UTC)
preferences   Sub Hash for special information
priority 2 normal Ticket priority
priority_id 2 ID of the currently set priority
state new Ticket state (new, open…)
state_id 1 Ticket state id for available ticket states (new, open…)
time_unit null Accounted time units for this ticket
title Feedback Form Ticket title
type null Ticket Type (deprecated)
update_diff_in_min null Business hours in minutes within or above the specified SLA for updating the ticket.
update_escalation_at null Time stamp of the last update reaction to the customer (DateTime, UTC)
update_in_min null Business hours in minutes it took to send the last update response to customer
updated_at 2017-08-03T14:21:38.701Z Last update timestamp (DateTime, UTC)
updated_by User User who updated the ticket
updated_by_id 13 User id of user who updated the ticket

Article

Field Sample Value Description
attachment.title file1.txt File name
attachment.content Hello world File Content
attachment.keywords keyword File Keywords
attachment.content Max File Author
body :) Content of the article
cc null Content of the optional cc field
content_type text/plain Content type
created_at 2017-08-03T14:21:38.000Z Article create date (DateTime, UTC)
created_by See User Who has created the article
created_by_id 13 Who (UserID) has created the article
from Christopher Miller via <order@chrispresso.com> Sender address of the article Sender address of the article
id 19 internal (DB) article id
in_reply_to null Content of reply to field
internal FALSE Is article visible for customer
message_id null Message ID (if article was an email)
message_id_md5 null internal message id MD5 Checksum
origin_by_id null For which real user (UserID) the article creation has been done. For example the customer which was calling on the phone done
preferences { } Hash for additional information
references null Email references header
reply_to null Content of the reply to field
sender Customer Who is the sender (Customer, Agent)
sender_id 2 Which type of user has created the article (Agent, Customer)
subject Feedback Form Article subject
ticket_id 19 referencing ticket ID
to null Content of the to field
type web Article type (phone, email, web…)
type_id 11 Article type id (phone, email, web…)
updated_at 2017-08-03T14:21:38.701Z Update time of the article (DateTime, UTC)
updated_by See User Who has updated the article
updated_by_id 13 Who (UserID) has updated the article

User

Field Sample Value Description
active TRUE is activ (boolean)
address   User Adress
city   User City
country   User Country
created_at 2017-07-26T21:21:28.000Z User creation date (DateTime, UTC)
created_by_id 1 ID of user who created the current user
department   User Department
email chris@chrispresso.com User E-Mail
fax   User Fax
firstname Christopher User Firstname
id 3 Internal id (database, autincrement)
last_login 2017-07-26T21:23:15.019Z User last login (DateTime, UTC)
lastname Miller User Lastname
login chris@chrispresso.com User Login
mobile   User Mobile
note   internal note
organization Chrispresso Inc Orgnaization name of the current user
organization_id 2 ID which links to the organization name
phone   User Phone
street   User Street
updated_at 2017-07-27T15:04:47.270Z Last update date (DateTime, UTC)
updated_by_id 3 ID of user who updated the current user
verified FALSE is verified (boolean)
vip FALSE Is VIP (boolean)
web   User Web Url
zip   User ZIP