Hi Carlos Rodriguez, So far are giving me information to keep working, I'll check. Thank you very much. ======== De: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] En nombre de Carlos Rodríguez Enviado el: martes, 19 de junio de 2012 09:15 p.m. Para: User questions and discussions about OTRS. Asunto: Re: [otrs] Edit PDF stats Hi Martin, I don't think there is an easy way to do that, e.g. in TicketAccumulation this values are fetch from the DB in this lines sub GetObjectAttributes { my ( $Self, %Param ) = @_; # get user list my %UserList = $Self->{UserObject}->UserList( Type => 'Long', Valid => 0, ); While it could sound like good idea to try using Type => 'Short', that will not help, because you will only get the UserLogin that THATS what you want to avoid, so I see 2 options, there are maybe more. 1 Loop trough %UserList and remove the login part form the value, I mean is always in format "LastName, FirstName (UserLogin)" (without the quotes), so a Regex can do the magic.... but be careful with names like "De la Torre Heranandez, María Concepción Socorro (2) (Maria2)" where (2) is part of the name as a differentiator..... (you know, it could happen) and (Maria) is the UserLogin 2 Loop trough %UserList and get the UserData by UserGet() on each key, and assemble a temp UserList, when is done, copy the temp UserList to the Original. This is obviously slower than 1. Both are dirty solutions and will need some development skills, as well as modifications to OTRS files, if you wish to to that I will recommend you to read the Development Manual and create a package so you don't modify an OTRS file directly, and if you uninstall the package you modified file is removed and replaced with the original. so is safer and portable. ((enjoy)) Carlos Rodríguez On Jun 19, 2012, at 7:39 PM, Soporte Informatica PGJE wrote: Hi everybody, I have OTRS 3.1.2 I wanna show only names from agent and customers without ID in my PDF stat. I thing that with a view en my database in a relationship between ticket, customers and agents tables, but i didnt know the way. How i can do only show Names winthout IDS from Customers and Agent/Owner in TicketList and TicketAcomulation Stats? Wich the correct and easy way? My stats today: https://dl.dropbox.com/u/6443236/otrs/Ticket%20List.pdf https://dl.dropbox.com/u/6443236/otrs/Tickets%20Acomulations.pdf Regards from Mexico :) -- Martin Edmundo --------------------------------------------------------------------- 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