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 2020-07-24 15:42:36

slegrand
Member
Registered: 2020-07-01
Posts: 5

Erreur SQL recherche suivis via API REST

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

#2 2020-07-27 09:56:34

orthagh
Administrator
From: TECLIB - CAEN
Registered: 2010-11-30
Posts: 662
Website

Re: Erreur SQL recherche suivis via API REST

Répliqué et corrigé ici : https://github.com/glpi-project/glpi/pull/7769

Offline

Board footer

Powered by FluxBB