Forum GLPI-Project

bmichelsz

Member

From: Slovakia

Registered: 2007-10-20

Posts: 37

Components search engine

Dear all,
I found the folloving behavior in Components search engine.
Main menu -> Setup -> Components -> Power Supplies -> Power Supply Items button

When I tried search a string like "D-Link" in "Associated element" no items were found.

but when I tried search a number e.g. "52", search engine found a "D-Link DAP-1160" under "Asociated elements". Yes, ID of "D-Link DAP-1160" is exactly 52.

Is it a bug, or expected behavior?
From my point of view, the easier way would be to search for strings instead of IDs.

I tried also search an unassigned items with 'NULL' string in search engine. Unassigned items were found, but in debug mode SQL Warning appeared on screen:

SQL Warnings: 1292: Truncated incorrect DOUBLE value: '' in query "SELECT DISTINCT `glpi_items_devicepowersupplies`.`id` AS id, 'USER_NAME' AS currentuser,
`glpi_items_devicepowersupplies`.`entities_id`, `glpi_items_devicepowersupplies`.`is_recursive`, `glpi_items_devicepowersupplies`.`id` AS `ITEM_Item_DevicePowerSupply_1`,
`glpi_items_devicepowersupplies`.`id` AS `ITEM_Item_DevicePowerSupply_1_id`, `glpi_items_devicepowersupplies`.`serial` AS `ITEM_Item_DevicePowerSupply_10`, GROUP_CONCAT(DISTINCT
CONCAT(`glpi_devicepowersupplies_c398f5c771d557e371cee28c1fdf8d40`.`designation`, '$#$' , `glpi_devicepowersupplies_c398f5c771d557e371cee28c1fdf8d40`.`id`) ORDER BY
`glpi_devicepowersupplies_c398f5c771d557e371cee28c1fdf8d40`.`id` SEPARATOR '$$##$$') AS `ITEM_Item_DevicePowerSupply_4`, `glpi_items_devicepowersupplies`.`items_id` AS `ITEM_Item_DevicePowerSupply_5`,
`glpi_items_devicepowersupplies`.`itemtype` AS `ITEM_Item_DevicePowerSupply_5_itemtype`, `glpi_items_devicepowersupplies`.`itemtype` AS `ITEM_Item_DevicePowerSupply_6` FROM
`glpi_items_devicepowersupplies`LEFT JOIN `glpi_devicepowersupplies` AS `glpi_devicepowersupplies_c398f5c771d557e371cee28c1fdf8d40` ON (`glpi_items_devicepowersupplies`.`devicepowersupplies_id` =
`glpi_devicepowersupplies_c398f5c771d557e371cee28c1fdf8d40`.`id` ) WHERE `glpi_items_devicepowersupplies`.`is_deleted` = 0 AND ( (`glpi_items_devicepowersupplies`.`items_id` IS NULL OR
`glpi_items_devicepowersupplies`.`items_id` = '') ) GROUP BY `glpi_items_devicepowersupplies`.`id` ORDER BY `ITEM_Item_DevicePowerSupply_1` ASC "

Thank you.

---

Debian 11, GLPI 10.0.6, OCS 2.3.1, MariaDB 10.5.18, Apache 2.4.52, PHP 7.4.33