Bonjour a tous.
J’exécute une requête en SQL, et cela fonctionne.
Quand je la mets dans mon outil de reporting, j'ai ce message d'erreur :
"Expression de type non booléen spécifiée dans un contexte où une condition est attendue, près de 'Order'"
Pourtant dans la requête je ne fais pas d'order by
Voici la requête :
Merci beaucoup de votre aide
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19 Select AM_ASSET.ASSET_TAG AS "Code matériel", AM_ASSET.SERIAL_NUMBER AS "N° de série", AM_UN_CLASSIFICATION.UN_CLASSIFICATION_FR AS "Catégorie", AM_CATALOG.ARTICLE_MODEL AS "Modèle", AM_MANUFACTURER.MANUFACTURER AS "Marque", AM_STATUS.STATUS_FR AS "Statut", AM_EMPLOYEE.LAST_NAME AS "Utilisateur principal", AM_ASSET.NETWORK_IDENTIFIER AS "Identifiant réseau", AM_catalog.AVAILABLE_FIELD_5 AS "Modele de remplacement", AM_catalog.AVAILABLE_FIELD_6 AS "Statut de retour", AM_MAIN_USAGE.REFERENCE_FR AS "Emploi principal", AM_LOCATION.AVAILABLE_FIELD_1 AS "Type de site", lpth.location_path_fr as "Localisation complète", Dpth.department_path_fr as "Entité complète" From AM_ASSET INNER JOIN AM_CATALOG ON AM_ASSET.CATALOG_ID = AM_CATALOG.CATALOG_ID INNER JOIN AM_LOCATION_PATH LPTH ON LPTH.LOCATION_ID = AM_asset.LOCATION_ID INNER JOIN AM_DEPARTMENT_PATH DPTH ON DPTH.DEPARTMENT_ID = AM_asset.DEPARTMENT_ID INNER JOIN AM_UN_CLASSIFICATION ON AM_CATALOG.UN_CLASSIFICATION_ID = AM_UN_CLASSIFICATION.UN_CLASSIFICATION_ID INNER JOIN AM_REFERENCE ON AM_UN_CLASSIFICATION.ARTICLE_TYPE_ID = AM_REFERENCE.REFERENCE_ID LEFT OUTER JOIN AM_EMPLOYEE ON AM_ASSET.EMPLOYEE_ID = AM_EMPLOYEE.EMPLOYEE_ID LEFT OUTER JOIN AM_LOCATION ON AM_ASSET.LOCATION_ID = AM_LOCATION.LOCATION_ID LEFT OUTER JOIN AM_DEPARTMENT ON AM_ASSET.DEPARTMENT_ID = AM_DEPARTMENT.DEPARTMENT_ID LEFT OUTER JOIN AM_MANUFACTURER ON AM_CATALOG.MANUFACTURER_ID = AM_MANUFACTURER.MANUFACTURER_ID LEFT OUTER JOIN AM_STATUS ON AM_ASSET.STATUS_ID = AM_STATUS.STATUS_ID LEFT OUTER JOIN V_MAIN_USAGE AM_MAIN_USAGE ON AM_ASSET.MAIN_USAGE_ID = AM_MAIN_USAGE.REFERENCE_ID where status_fr = 'En service' and (AM_UN_CLASSIFICATION.UN_CLASSIFICATION_id = '150' or AM_UN_CLASSIFICATION.UN_CLASSIFICATION_id = '168' or aM_UN_CLASSIFICATION.UN_CLASSIFICATION_id = 169) and am_location.available_field_1 like 'Point%'
Partager