Forum GLPI-Project

bojti.gabor

Member

Registered: 2013-11-20

Posts: 5

[SOLVED] Search Engine problem?

First of all sorry for my english!

I want to search by alternate username in main page search field, but not shown computers (only monitors and devices) for user. Although alternate username is define in computer page. Is it bug?

Thanks in advance for help

Last edited by bojti.gabor (2014-04-02 13:28:27)

bojti.gabor

Member

Registered: 2013-11-20

Posts: 5

Re: [SOLVED] Search Engine problem?

GLPI version 0.84.3

bojti.gabor

Member

Registered: 2013-11-20

Posts: 5

Re: [SOLVED] Search Engine problem?

In 0.83.8 version there is computer.contact condition in MySQL select and 0.84.3 there isn't.
0.83.8 select is:

SELECT 'cuser' AS currentuser, `glpi_computers`.`name` AS ITEM_0, `glpi_computers`.`id` AS ITEM_0_2, `glpi_states`.`completename` AS ITEM_1, `glpi_manufacturers`.`name` AS ITEM_2, `glpi_computers`.`serial` AS ITEM_3, `glpi_computertypes`.`name` AS ITEM_4, `glpi_computermodels`.`name` AS ITEM_5, `glpi_operatingsystems`.`name` AS ITEM_6, `glpi_locations`.`completename` AS ITEM_7, `glpi_computers`.`date_mod` AS ITEM_8, `glpi_computers`.`contact` AS ITEM_9, `glpi_computers`.`id` AS id
FROM `glpi_computers`
LEFT JOIN `glpi_states` ON (`glpi_computers`.`states_id` = `glpi_states`.`id` )
LEFT JOIN `glpi_manufacturers` ON (`glpi_computers`.`manufacturers_id` = `glpi_manufacturers`.`id` )
LEFT JOIN `glpi_computertypes` ON (`glpi_computers`.`computertypes_id` = `glpi_computertypes`.`id` )
LEFT JOIN `glpi_computermodels` ON (`glpi_computers`.`computermodels_id` = `glpi_computermodels`.`id` )
LEFT JOIN `glpi_operatingsystems` ON (`glpi_computers`.`operatingsystems_id` = `glpi_operatingsystems`.`id` )
LEFT JOIN `glpi_locations` ON (`glpi_computers`.`locations_id` = `glpi_locations`.`id` )
WHERE `glpi_computers`.`is_deleted` = '0' AND `glpi_computers`.`is_template` = '0' AND ( `glpi_computers`.`entities_id` IN ('0') ) AND ( ( `glpi_computers`.`name` LIKE '%User%' OR `glpi_states`.`completename` LIKE '%User%' OR `glpi_manufacturers`.`name` LIKE '%User%' OR `glpi_computers`.`serial` LIKE '%User%' OR `glpi_computertypes`.`name` LIKE '%User%' OR `glpi_computermodels`.`name` LIKE '%User%' OR `glpi_operatingsystems`.`name` LIKE '%User%' OR `glpi_locations`.`completename` LIKE '%User%' OR `glpi_computers`.`date_mod` LIKE '%User%' OR `glpi_computers`.`contact` LIKE '%User%' ) )
ORDER BY ITEM_0 ASC

0.84.8 select is:

SELECT 'cuser' AS currentuser, `glpi_computers`.`name` AS ITEM_0, `glpi_computers`.`id` AS ITEM_0_2, `glpi_states`.`completename` AS ITEM_1, `glpi_manufacturers`.`name` AS ITEM_2, `glpi_computers`.`serial` AS ITEM_3, `glpi_computertypes`.`name` AS ITEM_4, `glpi_computermodels`.`name` AS ITEM_5, `glpi_operatingsystems`.`name` AS ITEM_6, `glpi_locations`.`completename` AS ITEM_7, `glpi_computers`.`date_mod` AS ITEM_8, GROUP_CONCAT(DISTINCT CONCAT(`glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`designation`,'$$',`glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`id`) SEPARATOR '$$$$') AS ITEM_9, `glpi_computers`.`id` AS id 
FROM `glpi_computers`
LEFT JOIN `glpi_states` ON (`glpi_computers`.`states_id` = `glpi_states`.`id` )
LEFT JOIN `glpi_manufacturers` ON (`glpi_computers`.`manufacturers_id` = `glpi_manufacturers`.`id` )
LEFT JOIN `glpi_computertypes` ON (`glpi_computers`.`computertypes_id` = `glpi_computertypes`.`id` )
LEFT JOIN `glpi_computermodels` ON (`glpi_computers`.`computermodels_id` = `glpi_computermodels`.`id` )
LEFT JOIN `glpi_operatingsystems` ON (`glpi_computers`.`operatingsystems_id` = `glpi_operatingsystems`.`id` )
LEFT JOIN `glpi_locations` ON (`glpi_computers`.`locations_id` = `glpi_locations`.`id` )
LEFT JOIN `glpi_items_deviceprocessors` ON (`glpi_computers`.`id` = `glpi_items_deviceprocessors`.`items_id` AND `glpi_items_deviceprocessors`.`itemtype` = 'Computer' )
LEFT JOIN `glpi_deviceprocessors` AS glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604 ON (`glpi_items_deviceprocessors`.`deviceprocessors_id` = `glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`id` )
WHERE `glpi_computers`.`is_deleted` = '0' AND `glpi_computers`.`is_template` = '0' AND ( `glpi_computers`.`entities_id` IN ('0') ) AND ( ( `glpi_computers`.`name` LIKE '%User%' OR `glpi_states`.`completename` LIKE '%User%' OR `glpi_manufacturers`.`name` LIKE '%User%' OR `glpi_computers`.`serial` LIKE '%User%' OR `glpi_computertypes`.`name` LIKE '%User%' OR `glpi_computermodels`.`name` LIKE '%User%' OR `glpi_operatingsystems`.`name` LIKE '%User%' OR `glpi_locations`.`completename` LIKE '%User%' OR `glpi_computers`.`date_mod` LIKE '%User%' ) ) GROUP BY `glpi_computers`.`id`
ORDER BY ITEM_0 ASC

MoYo

GLPI - Lead

From: Poitiers

Registered: 2004-09-13

Posts: 14,513

Website

Re: [SOLVED] Search Engine problem?

Is the alternate username is a displayed column of the default search (global one not user one) ?

---

MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

bojti.gabor

Member

Registered: 2013-11-20

Posts: 5

Re: [SOLVED] Search Engine problem?

Thank you for your help!