1 2 3
| if(ALARME_I_ORIGINE = 1 AND ALARME_I_VERSION = 1,CONCAT_WS('@$',CAST(1 AS CHAR),PLANNING.PLA_DATE_DEB,PLANNING.PLA_HEURE_DEB,ADRESSE.TITRE_CODE,ADRESSE.ADR_CODE,PLANNING.PLA_MEMO, ALARME.ALARME_MEMO),
if(ALARME_I_ORIGINE = 2 AND ALARME_I_VERSION = 1,CONCAT_WS('@$',CAST(1 AS CHAR),OBLIGATION.EXO_CODE,OBLIGATION.PREST_CODE,OBLIGATION.OBLIG_DATE_FIN,ADRESSE.TITRE_CODE,ADRESSE.ADR_CODE,OBLIGATION.OBLIG_LIBELLE,ALARME.ALARME_MEMO),
if(ALARME_I_ORIGINE = 3 AND ALARME_I_VERSION = 1,CONCAT_WS('@$',CAST(1 AS CHAR),EVE_I_CATEGORIE,EVENEMENT.COL_CODE_CREAT,QUALIFEVE_ID_N1,QUALIFEVE_ID_N2,QUALIFEVE_ID_N3,ADRESSE.TITRE_CODE,ADRESSE.ADR_CODE,EVENEMENT.COR_ID,EVENEMENT.EVE_TEL_REPONSE,EVENEMENT.EVE_FAX_REPONSE,EVENEMENT.EVE_EMAIL_REPONSE,EVENEMENT.EVE_MEMO_DESCRIPTION,EVENEMENT.EVE_MEMO_SOLUTION,ALARME.ALARME_MEMO), ALARME.ALARME_MEMO))) AS MEMO, |
Partager