Accords interbranches

Documents

Erreur SQL: Échec de la conversion de la valeur nvarchar '1975 bis' en type de données int. SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this_k_2.result1 AS this_k_2_1, this_s_document_2.[_oid] AS this_s_document_2, this_s_document_1.[_oid] AS this_s_document_1, this.titre AS this_p_titre, this.reference AS this_p_reference, this.date_de_publication AS this_p_date_de_publication, this_s_document_1.urlDir AS this_s_document_1_p_urlDir, this_s_document_1.filename AS this_s_document_1_p_filename, this_s_document_1.extension AS this_s_document_1_p_extension, this_z.ocsModificationDate AS this_z_p_ocsModificationDate, ISNULL(CAST(this.reference AS int), 0) AS IsoF12 FROM dm_card_articles AS this INNER JOIN ocs_card AS this_z LEFT JOIN ocs_catalog AS this_z_s_ocsCatalog On ((this_z.ocsCatalog = this_z_s_ocsCatalog.[_oid]) AND (this_z_s_ocsCatalog.iso_sid <> '')) On ((this.[_oid] = this_z.[_oid]) AND (this_z.iso_sid <> '')) LEFT JOIN (SELECT c0.[_oid] AS origin, COUNT(DISTINCT this.[_oid]) AS result1 FROM xrm_category AS this INNER JOIN dm_card_articles AS c0 INNER JOIN ocs_card_ocsVisibility AS c0_l On ((c0.[_oid] = c0_l.[_from]) AND (c0.iso_sid <> '')) INNER JOIN ocs_card AS c0_z On ((c0.[_oid] = c0_z.[_oid]) AND (c0_z.iso_sid <> '')) On ((this.[_oid] = c0_l.[_to]) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.[_oid] IN (605, 607)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) LEFT JOIN (SELECT c0.[_oid] AS origin, MAX(this.[_oid]) AS result1 FROM kwd_keyword AS this INNER JOIN dm_card_articles AS c0 INNER JOIN dm_card_articles_juricoop_social AS c0_l On ((c0.[_oid] = c0_l.[_from]) AND (c0.iso_sid <> '')) INNER JOIN ocs_card AS c0_z On ((c0.[_oid] = c0_z.[_oid]) AND (c0_z.iso_sid <> '')) On ((this.[_oid] = c0_l.[_to]) AND (c0_l.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (this.gid IN ('000110c0', '000100fe', '000110b6', '000110ba')) GROUP BY c0.[_oid]) AS this_k_2 On (this.[_oid] = this_k_2.origin) LEFT JOIN alb_private_resource AS this_s_document_2 On ((this.document_2 = this_s_document_2.[_oid]) AND (this_s_document_2.iso_sid <> '')) LEFT JOIN alb_private_resource AS this_s_document_1 On ((this.document_1 = this_s_document_1.[_oid]) AND (this_s_document_1.iso_sid <> '')) WHERE (this.iso_sid <> '') AND (CASE WHEN (this_z_s_ocsCatalog.useValidation = 1) THEN this_z.ocsStatus ELSE CASE WHEN ((this_z.ocsStatus = 2) OR (this_z.ocsStatus = 3)) THEN this_z.ocsStatus ELSE 0 END END = 2) AND ((this_z_s_ocsCatalog.useXRM = 0) OR ((this_z_s_ocsCatalog.useXRM = 1) AND (this_k_1.result1 > 0))) AND (this_z_s_ocsCatalog.name = 'documents_juridiques') AND (this_k_2.result1 IS NOT NULL ) ORDER BY IsoF12 ASC

Aucune fiche disponible pour le moment.