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