Where is the flow lines? U_u https://dl.dropbox.com/u/6443236/otrs/otrs%20design.png This is a screenshoot from Mysql workbench, model section. ===== De: dev-bounces@otrs.org [mailto:dev-bounces@otrs.org] En nombre de Soporte Informatica PGJE Enviado el: viernes, 15 de junio de 2012 08:42 p.m. Para: dev@otrs.org Asunto: [dev] hierarchy of tickets Hi everyone, OTRS: 3.1.2 Problem: I need to classify tickets using a hierarchical tree and have statistics on the number of tickets in each level tree. PROPOSED SOLUTION: 1. I have a very functional implementation with multi ID for customers, the problem here is that the stat module only find specific IDS, but does not search the customers_ids field. in this context as I can show the tickets assigned to an ID and tickets hierarchically below the? 2. I have dynamic fields of each hierarchical level, I want to create a relationship herarquical including Choosing a level and sublevel only in its child nodes are displayed. I can create this relationship as? Where i can ER diagram of Database otrs? Can I to use mysql workbench for this? regards -- Martin Edmundo