Hi all, While making some statistic scripts I find out a little stange logoc in db scheme. Lets see some details. While performing sql query which depends on article.create_time (thinking i'd get all articles=email which was send between two dates) i figured out that all articles, in specific ticket, have the same create_time value!!?? And even more bizzare, that values which should be in article.create_time files are stored in tictet_history.create_time!!?? My perspective was, that ticket is generated just once (so there is one create_time), all the related articles are generated when follow-up comes and at that time also article.creation_time is set. Well, maybe this is just my confusion, so please correct if i'm wrong.
Thanks! Alex P.s. I've used this SQL query string (statistic for specific agent - how many bounces between two dates) select system_user.login AS login, queue.name AS queue, article.create_time AS date, article.a_subject AS subject, ticket_history_type.name AS hist_name from system_user, queue, article, ticket, ticket_history, ticket_history_type where article.ticket_id=ticket.id and system_user.id=ticket.user_id and ticket_history.ticket_id=ticket.id and queue.id=ticket.queue_id and ticket_history.history_type_id=ticket_history_type.id and article.create_time >= '2003-07-01 00:00:00' and article.create_time <= '2003-07-01 23:59:59' and ticket_history_type.id='8' and system_user.id='2' and article.a_subject like '[ID%' and article.article_sender_type_id='1' order by date _______________________________________________ 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
