You are not logged in.
Pages: 1
Bonjour,
En voulant effectuer une recherche dans les suivis via l'API REST, je suis tombé sur l'erreur SQL suivante :
SQL Error "1052": Column 'itemtype' in where clause is ambiguous in query "SELECT DISTINCT `glpi_itilfollowups`.`id` AS id, 'xxxx' AS currentuser, `glpi_itilfollowups`.`content` AS `ITEM_ITILFollowup_1`, COUNT(DISTINCT `glpi_documents_items`.`id`) AS `ITEM_ITILFollowup_119`, `glpi_itilfollowups`.`itemtype` AS `ITEM_ITILFollowup_6` FROM `glpi_itilfollowups` LEFT JOIN `glpi_documents_items` ON (`glpi_itilfollowups`.`id` = `glpi_documents_items`.`items_id` AND `glpi_documents_items`.`itemtype` = 'ITILFollowup') WHERE `glpi_itilfollowups`.`is_private` IN ('1','0') AND ((`itemtype` = 'Ticket') OR (`itemtype` = 'Change' AND 0 = 1) OR (`itemtype` = 'Problem' AND 0 = 1) )) AND ( (`glpi_itilfollowups`.`itemtype` LIKE 'Ticket' ) ) GROUP BY `glpi_itilfollowups`.`id` HAVING (`ITEM_ITILFollowup_119` LIKE '1' ) ORDER BY ITEM_ITILFollowup_1 ASC "
Requête HTTP :
/apirest.php//search/ITILFollowup?range=0-9999999999&&uid_cols=true&criteria[0][field]=119&criteria[0][searchtype]=contains&criteria[0][value]=^1$&criteria[1][field]=6&criteria[1][searchtype]=contains&criteria[1][value]=^Ticket$
Version de GLPI : GLPI 9.5.1
Mode d'installation : TARBALL
Offline
Répliqué et corrigé ici : https://github.com/glpi-project/glpi/pull/7769
Offline
Pages: 1