Re: RV: hierarchy of tickets

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=1.2&view=co

Hope this helps!

--
Mike

On Wed, Jun 20, 2012 at 2:55 AM, Soporte Informatica PGJE <
[email protected]> 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: [email protected] [mailto:[email protected]] En nombre de
> Soporte
> Informatica PGJE
> Enviado el: viernes, 15 de junio de 2012 08:42 p.m.
> Para: [email protected]
> 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
>

_______________________________________________
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