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
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
Hi, On your OTRS installation, the 'doc' folder contains a .png image of the database ERD and also it contains the base .mwb file for use in MySQL Workbench. You can also see the image of the ERD here: http://source.otrs.org/viewvc.cgi/otrs/doc/OTRSDatabaseDiagram.png?revision=... Hope this helps! -- Mike On Wed, Jun 20, 2012 at 2:55 AM, Soporte Informatica PGJE < ddmi@pgje.michoacan.gob.mx> wrote:
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
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
Tanks Michiel Beijen its very good
Regards
========
Hi,
On your OTRS installation, the 'doc' folder contains a .png image of the database ERD and also it contains the base .mwb file for use in MySQL Workbench.
You can also see the image of the ERD here:
http://source.otrs.org/viewvc.cgi/otrs/doc/OTRSDatabaseDiagram.png?revision=...
Hope this helps!
--
Mike
On Wed, Jun 20, 2012 at 2:55 AM, Soporte Informatica PGJE
participants (2)
-
Michiel Beijen -
Soporte Informatica PGJE