recherche contact centre ressource mention Plan du site Login
 
Actualités
Actualités des dossiers
Agenda
Les événements précédents
Les "Rencontres du Centre de ressources"

Les événements précédents




Cliquez sur l'onglet du mois de votre choix.

Erreur de Base de données:
Erreur non spécifiée

SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this.titre AS this_p_titre, this.lieu AS this_p_lieu, this_z_s_ocsCatalog.name AS this_z_s_ocsCatalog_p_name, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.useXRM AS this_z_s_ocsCatalog_p_useXRM, this.debut_evenement AS IsoF7 FROM dm_card_agenda 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_agenda 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 (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) 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 = 'agenda') AND (this.titre LIKE ('%' + '/01/' + '%')) AND (this.date_fin_visibilite <= 1441058400000) ORDER BY IsoF7 DESC

Erreur de Base de données:
Erreur non spécifiée

SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this.titre AS this_p_titre, this.lieu AS this_p_lieu, this_z_s_ocsCatalog.name AS this_z_s_ocsCatalog_p_name, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.useXRM AS this_z_s_ocsCatalog_p_useXRM, this.debut_evenement AS IsoF7 FROM dm_card_agenda 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_agenda 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 (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) 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 = 'agenda') AND (this.titre LIKE ('%' + '/02/' + '%')) AND (this.date_fin_visibilite <= 1441058400000) ORDER BY IsoF7 DESC

Erreur de Base de données:
Erreur non spécifiée

SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this.titre AS this_p_titre, this.lieu AS this_p_lieu, this_z_s_ocsCatalog.name AS this_z_s_ocsCatalog_p_name, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.useXRM AS this_z_s_ocsCatalog_p_useXRM, this.debut_evenement AS IsoF7 FROM dm_card_agenda 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_agenda 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 (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) 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 = 'agenda') AND (this.titre LIKE ('%' + '/03/' + '%')) AND (this.date_fin_visibilite <= 1441058400000) ORDER BY IsoF7 DESC

Erreur de Base de données:
Erreur non spécifiée

SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this.titre AS this_p_titre, this.lieu AS this_p_lieu, this_z_s_ocsCatalog.name AS this_z_s_ocsCatalog_p_name, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.useXRM AS this_z_s_ocsCatalog_p_useXRM, this.debut_evenement AS IsoF7 FROM dm_card_agenda 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_agenda 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 (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) 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 = 'agenda') AND (this.titre LIKE ('%' + '/04/' + '%')) AND (this.date_fin_visibilite <= 1441058400000) ORDER BY IsoF7 DESC

Erreur de Base de données:
Erreur non spécifiée

SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this.titre AS this_p_titre, this.lieu AS this_p_lieu, this_z_s_ocsCatalog.name AS this_z_s_ocsCatalog_p_name, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.useXRM AS this_z_s_ocsCatalog_p_useXRM, this.debut_evenement AS IsoF7 FROM dm_card_agenda 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_agenda 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 (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) 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 = 'agenda') AND (this.titre LIKE ('%' + '/05/' + '%')) AND (this.date_fin_visibilite <= 1441058400000) ORDER BY IsoF7 DESC

Erreur de Base de données:
Erreur non spécifiée

SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this.titre AS this_p_titre, this.lieu AS this_p_lieu, this_z_s_ocsCatalog.name AS this_z_s_ocsCatalog_p_name, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.useXRM AS this_z_s_ocsCatalog_p_useXRM, this.debut_evenement AS IsoF7 FROM dm_card_agenda 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_agenda 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 (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) 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 = 'agenda') AND (this.titre LIKE ('%' + '/06/' + '%')) AND (this.date_fin_visibilite <= 1441058400000) ORDER BY IsoF7 DESC

Erreur de Base de données:
Erreur non spécifiée

SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this.titre AS this_p_titre, this.lieu AS this_p_lieu, this_z_s_ocsCatalog.name AS this_z_s_ocsCatalog_p_name, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.useXRM AS this_z_s_ocsCatalog_p_useXRM, this.debut_evenement AS IsoF7 FROM dm_card_agenda 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_agenda 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 (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) 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 = 'agenda') AND (this.titre LIKE ('%' + '/07/' + '%')) AND (this.date_fin_visibilite <= 1441058400000) ORDER BY IsoF7 DESC

Erreur de Base de données:
Erreur non spécifiée

SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this.titre AS this_p_titre, this.lieu AS this_p_lieu, this_z_s_ocsCatalog.name AS this_z_s_ocsCatalog_p_name, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.useXRM AS this_z_s_ocsCatalog_p_useXRM, this.debut_evenement AS IsoF7 FROM dm_card_agenda 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_agenda 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 (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) 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 = 'agenda') AND (this.titre LIKE ('%' + '/08/' + '%')) AND (this.date_fin_visibilite <= 1441058400000) ORDER BY IsoF7 DESC

Erreur de Base de données:
Erreur non spécifiée

SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this.titre AS this_p_titre, this.lieu AS this_p_lieu, this_z_s_ocsCatalog.name AS this_z_s_ocsCatalog_p_name, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.useXRM AS this_z_s_ocsCatalog_p_useXRM, this.debut_evenement AS IsoF7 FROM dm_card_agenda 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_agenda 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 (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) 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 = 'agenda') AND (this.titre LIKE ('%' + '/09/' + '%')) AND (this.date_fin_visibilite <= 1441058400000) ORDER BY IsoF7 DESC

Erreur de Base de données:
Erreur non spécifiée

SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this.titre AS this_p_titre, this.lieu AS this_p_lieu, this_z_s_ocsCatalog.name AS this_z_s_ocsCatalog_p_name, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.useXRM AS this_z_s_ocsCatalog_p_useXRM, this.debut_evenement AS IsoF7 FROM dm_card_agenda 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_agenda 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 (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) 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 = 'agenda') AND (this.titre LIKE ('%' + '/10/' + '%')) AND (this.date_fin_visibilite <= 1441058400000) ORDER BY IsoF7 DESC

Erreur de Base de données:
Erreur non spécifiée

SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this.titre AS this_p_titre, this.lieu AS this_p_lieu, this_z_s_ocsCatalog.name AS this_z_s_ocsCatalog_p_name, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.useXRM AS this_z_s_ocsCatalog_p_useXRM, this.debut_evenement AS IsoF7 FROM dm_card_agenda 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_agenda 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 (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) 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 = 'agenda') AND (this.titre LIKE ('%' + '/11/' + '%')) AND (this.date_fin_visibilite <= 1441058400000) ORDER BY IsoF7 DESC

Erreur de Base de données:
Erreur non spécifiée

SELECT this.[_oid] AS this, this_k_1.result1 AS this_k_1_1, this.titre AS this_p_titre, this.lieu AS this_p_lieu, this_z_s_ocsCatalog.name AS this_z_s_ocsCatalog_p_name, this_z_s_ocsCatalog.useValidation AS this_z_s_ocsCatalog_p_useValidation, this_z_s_ocsCatalog.useXRM AS this_z_s_ocsCatalog_p_useXRM, this.debut_evenement AS IsoF7 FROM dm_card_agenda 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_agenda 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 (-1)) GROUP BY c0.[_oid]) AS this_k_1 On (this.[_oid] = this_k_1.origin) 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 = 'agenda') AND (this.titre LIKE ('%' + '/12/' + '%')) AND (this.date_fin_visibilite <= 1441058400000) ORDER BY IsoF7 DESC


[ imprimer] [ mise à jour le   ]
 
 

Votre agenda


Un sujet vous intéresse mais vous n'avez pu assister à cet évènement... vous pouvez consulter ou obtenir les documents diffusés au public en cliquant sur le lien "Lire la suite"