Reports Plugin - Output Help Needed

danh · 2012-10-24 21:58:49

I am trying to combine user first name with last name in the output.
Nothing is working yet.

I can use:
new PluginReportsColumn('name2','Password Reset For:'),
new PluginReportsColumn('name3',' '));

It works, but it's not pretty. How can I get them to both be in the same output field?

I am using glpi_users.firstname and glpi_users.realname fields

tomolimo · 2012-10-29 17:44:35

Dear danh,
You have two solutions:
Either to create a virtual field in the SELECT clause in your SQL request, or what I'm doing most of the time is to use a mySQL 'view' that I later use in my report.
regards,
Tomolimo

Last edited by tomolimo (2012-10-29 17:48:08)

danh · 2012-10-30 15:57:49

I have created the view, but I am not able to call this in the actual SQL statement.

Here is what I am working with:

$sql="SELECT glpi_tickets.name as name1, glpi_tickets.Date, glpi_tickets.content, glpi_users.realname as name3, glpi_users.firstname as name2
FROM (glpi_tickets_users INNER JOIN glpi_tickets ON glpi_tickets_users.tickets_id = glpi_tickets.ID) INNER JOIN glpi_users ON glpi_tickets_users.users_id = glpi_users.ID
WHERE (((glpi_tickets.itilcategories_id)=32) AND ((glpi_tickets_users.type)=1))";

tomolimo · 2012-10-30 16:02:49

Try this:

SELECT glpi_tickets.name as name1, glpi_tickets.Date, glpi_tickets.content, CONCAT(glpi_users.realname, ' ' , glpi_users.firstname ) as UserName

regards,
Tomolimo

danh · 2012-10-30 16:08:14

That works awesome. Thank you very much!

Forum GLPI-Project

Announcement

#1 2012-10-24 21:58:49

Reports Plugin - Output Help Needed

#2 2012-10-29 17:44:35

Re: Reports Plugin - Output Help Needed

#3 2012-10-30 15:57:49

Re: Reports Plugin - Output Help Needed

#4 2012-10-30 16:02:49

Re: Reports Plugin - Output Help Needed

#5 2012-10-30 16:08:14

Re: Reports Plugin - Output Help Needed

Board footer