Am 19.06.2012 10:55, schrieb louis du Beux: Louis, have a look at the tables 'ticket_history' and 'ticket_history_type' 'ticket_history' records all actions related to a ticket (ticket_id) via history_type_id (look up in 'ticket_history_type' ) with additional infomration like ticket type, the corresponding article id , id of creator and changer (lookup in 'users') etc.

hi, firstly i apologize for my bad english.

i need some help i you could help me.

i read all the information about ticket stocked in the table of my database using some sql request, but i don't find where are the information about the moves of the ticket (actualy i only can see the actuel file of the ticket not the precedent).

and i need to know in which table their stocked to extract it for the db with a sql request.

regards,

Louis du Beux

ps : if you don't understand what i wrote don't hesitate to tell me, thanks. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs