You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2013-11-20 14:23:04

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)

Offline

#2 2013-11-20 14:41:19

bojti.gabor
Member
Registered: 2013-11-20
Posts: 5

Re: [SOLVED] Search Engine problem?

GLPI version 0.84.3

Offline

#3 2013-11-20 14:49:41

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

Offline

#4 2013-12-01 14:45:12

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

Offline

#5 2014-04-02 13:29:20

bojti.gabor
Member
Registered: 2013-11-20
Posts: 5

Re: [SOLVED] Search Engine problem?

Thank you for your help!

Offline

Board footer

Powered by FluxBB