Dynamic Field - link to ticket

[kelyne]

Hi,

I've created a dynamic field called cost centre and place it on the AgentTicketPhone action. How do i link this dynamic field to the ticket that has been logged?

Thanks,
Keith

[jojo]

this is done automatically

[kelyne]

What tables and columns do I join on?

Thanks,
Keith

mysql> desc ticket;
+--------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| tn | varchar(50) | NO | UNI | NULL | |
| title | varchar(255) | YES | MUL | NULL | |
| queue_id | int(11) | NO | MUL | NULL | |
| ticket_lock_id | smallint(6) | NO | MUL | NULL | |
| ticket_answered | smallint(6) | NO | MUL | NULL | |
| type_id | smallint(6) | YES | MUL | NULL | |
| service_id | int(11) | YES | MUL | NULL | |
| sla_id | int(11) | YES | MUL | NULL | |
| user_id | int(11) | NO | MUL | NULL | |
| responsible_user_id | int(11) | NO | MUL | NULL | |
| group_id | int(11) | NO | | NULL | |
| ticket_priority_id | smallint(6) | NO | MUL | NULL | |
| ticket_state_id | smallint(6) | NO | MUL | NULL | |
| group_read | smallint(6) | YES | | NULL | |
| group_write | smallint(6) | YES | | NULL | |
| other_read | smallint(6) | YES | | NULL | |
| other_write | smallint(6) | YES | | NULL | |
| customer_id | varchar(150) | YES | MUL | NULL | |
| customer_user_id | varchar(250) | YES | MUL | NULL | |
| timeout | int(11) | NO | MUL | NULL | |
| until_time | int(11) | NO | MUL | NULL | |
| escalation_time | int(11) | NO | MUL | NULL | |
| escalation_update_time | int(11) | NO | MUL | NULL | |
| escalation_response_time | int(11) | NO | MUL | NULL | |
| escalation_solution_time | int(11) | NO | MUL | NULL | |
| valid_id | smallint(6) | NO | MUL | NULL | |
| archive_flag | smallint(6) | NO | MUL | 0 | |
| create_time_unix | bigint(20) | NO | MUL | NULL | |
| create_time | datetime | NO | MUL | NULL | |
| create_by | int(11) | NO | MUL | NULL | |
| change_time | datetime | NO | | NULL | |
| change_by | int(11) | NO | MUL | NULL | |
+--------------------------+--------------+------+-----+---------+----------------+

[jojo]

you don't need do to anything on the database level. OTRS will assign the field to the ticket

[kelyne]

I would like to report on it.

So i would like a report where I show the ticket id, the total accounted time and the cost centre.

I cannot see what fields I can use to join the cost centre to ticket.

[jojo]

this is done via the object_id field in the dynamic_field_value table

[kelyne]

Excellent, thanks for that.

Cheers,
Keith