| Bonjour,
Nous avons un problème sur la génération d'un rapport qui ne s'affiche pas même après plusieurs heures :
9 Requête correspond à cette écran capture dans la base :
SELECT TO_CHAR (seprev.eventdate, 'YYYY'), TO_CHAR (seprev.eventdate, 'MM'),
TO_CHAR (seprev.eventdate, 'DD'), aseprev.agentnewstate,
SUM (((senext.eventdate - seprev.eventdate) * 86400))
FROM statevent seprev,
agentstatevent aseprev,
statevent senext,
agentstatevent asenext
WHERE seprev.eventkind = 3
AND seprev.eventdate >= :1
AND seprev.eventdate <= :2
AND seprev.stateventid = aseprev.stateventid
AND aseprev.agentnewstate <> 0
AND aseprev.stateventid = asenext.previd
AND senext.stateventid = asenext.stateventid
AND senext.eventdate >= :3
AND senext.eventdate <= :4
AND aseprev.agentid = :5
GROUP BY TO_CHAR (seprev.eventdate, 'YYYY'),
TO_CHAR (seprev.eventdate, 'MM'),
TO_CHAR (seprev.eventdate, 'DD'),
aseprev.agentnewstate
ORDER BY 1 ASC, 2 ASC, 3 ASC
9 Si on substitue les variables date et agentid comme suivant, on a tout de suite les résultats.
SELECT TO_CHAR (seprev.eventdate, 'YYYY'), TO_CHAR (seprev.eventdate, 'MM'),
TO_CHAR (seprev.eventdate, 'DD'), aseprev.agentnewstate,
SUM (((senext.eventdate - seprev.eventdate) * 86400))
FROM eptiuser.statevent seprev,
eptiuser.agentstatevent aseprev,
eptiuser.statevent senext,
eptiuser.agentstatevent asenext
WHERE seprev.eventkind = 3
AND seprev.eventdate >= '01/02/2007'
AND seprev.eventdate <= '01/03/2007'
AND seprev.stateventid = aseprev.stateventid
AND aseprev.agentnewstate <> 0
AND aseprev.stateventid = asenext.previd
AND senext.stateventid = asenext.stateventid
AND senext.eventdate >= '01/02/2007'
AND senext.eventdate <= '01/03/2007'
AND aseprev.agentid = 12
GROUP BY TO_CHAR (seprev.eventdate, 'YYYY'),
TO_CHAR (seprev.eventdate, 'MM'),
TO_CHAR (seprev.eventdate, 'DD'),
aseprev.agentnewstate
ORDER BY 1 ASC, 2 ASC, 3 ASC
Cordialement
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.
Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------
|