Silverpeas » Silverpeas Components » FormsOnline

Voici la requête utilisé pour faire l'export :

SELECT specificid,formSUP02.* from (
SELECT TF.recordid, FI.STATE AS STATEID,
CASE
WHEN FI.STATE=1 THEN 'UNREAD'
WHEN FI.STATE=2 THEN 'READ'
WHEN FI.STATE=3 THEN 'ACCEPTED'
WHEN FI.STATE=4 THEN 'REFUSED'
ELSE 'UNKOWN'
END AS "STATE",
MAX(CASE WHEN TF.FIELDNAME = 'site'
THEN TF.FIELDVALUE
ELSE NULL END) AS "SITE",
MAX(CASE WHEN TF.FIELDNAME = 'COMMENTS'
THEN TF.FIELDVALUE
ELSE NULL END) AS "COMMENTS",
MAX(CASE WHEN TF.FIELDNAME = 'USER'
THEN TF.FIELDVALUE
ELSE NULL END) AS "IDDEUSER",
MAX(CASE WHEN TF.FIELDNAME = 'INCIDENTNUMBER'
THEN TF.FIELDVALUE
ELSE NULL END) AS "INCIDENTNUMBER",
MAX(CASE WHEN TF.FIELDNAME = 'APPLICATION'
THEN TF.FIELDVALUE
ELSE NULL END) AS "APPLICATION",
MAX(CASE WHEN TF.FIELDNAME = 'DESCRIPTION'
THEN TF.FIELDVALUE
ELSE NULL END) AS "DESCRIPTION",
MAX(CASE WHEN TF.FIELDNAME = 'STARTDATE'
THEN TF.FIELDVALUE
ELSE NULL END) AS "STARTDATE",
MAX(CASE WHEN TF.FIELDNAME = 'STARTTIME'
THEN TF.FIELDVALUE
ELSE NULL END) AS "STARTTIME",
MAX(CASE WHEN TF.FIELDNAME = 'ENDDATE'
THEN TF.FIELDVALUE
ELSE NULL END) AS "ENDDATE",
MAX(CASE WHEN TF.FIELDNAME = 'ENDTIME'
THEN TF.FIELDVALUE
ELSE NULL END) AS "ENDTIME",
MAX(CASE WHEN TF.FIELDNAME = 'ORIGIN'
THEN TF.FIELDVALUE
ELSE NULL END) AS "ORIGIN"
FROM sb_formtemplate_textfield TF, sb_formtemplate_record TR, sc_formsonline_forminstances FI
WHERE
TR.TEMPLATEID = 1915
AND TR.RECORDID = TF.RECORDID
AND TR.externalid::int = FI.id
GROUP BY TF.RECORDID, FI.STATE) AS formSUP02,st_user
WHERE
formSUP02."IDDEUSER"::int=st_user.id

Mais un outil d'export serait beaucoup plus pratique.