[FogBugz #292] Dans lecture de mr_visite_data_text ajouter : and abandon is null #355

New Issue

fbenoist68 · 2023-07-04T07:17:18+02:00

fbenoist68 commented

2023-07-04 07:17:18 +02:00

Assigned To: CLOSED
Project: Mobile Portal
Area: Divers
Category: Bogue
Priority: A fixer impérativement

Assigned To: CLOSED Project: Mobile Portal Area: Divers Category: Bogue Priority: A fixer impérativement

fbenoist68 commented

2023-07-04 07:17:21 +02:00

Event ID: 1281
Date: 2014-04-06T06:46:01Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist

Event ID: 1281 Date: 2014-04-06T06:46:01Z Person: Frederik Benoist Description: Fermé par Frederik Benoist

fbenoist68 commented

2023-07-04 07:17:24 +02:00

Event ID: 1280
Date: 2014-04-06T06:46:01Z
Person: Frederik Benoist
Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist

dans gen_visite_pdf :

BEGIN

SELECT SUBSTR (mvdt.data_clob, 1, 32000)

INTO v_synthese_gen

FROM mr_visite_data_text mvdt

WHERE mvdt.id_visite = pid_visite AND mvdt.id_visite_data_type = 1 AND mvdt.abandon IS null;

EXCEPTION

WHEN NO_DATA_FOUND

THEN

v_synthese_gen := NULL;

END;

Event ID: 1280 Date: 2014-04-06T06:46:01Z Person: Frederik Benoist Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist <div> dans gen_visite_pdf :</div> <div>  </div> <div>  BEGIN</div> <div>          SELECT SUBSTR (mvdt.data_clob, 1, 32000)</div> <div>            INTO v_synthese_gen</div> <div>            FROM mr_visite_data_text mvdt</div> <div>           WHERE mvdt.id_visite = pid_visite AND mvdt.id_visite_data_type = 1 <strong>AND mvdt.abandon IS null;</strong></div> <div>       EXCEPTION</div> <div>          WHEN NO_DATA_FOUND</div> <div>          THEN</div> <div>             v_synthese_gen := NULL;</div> <div>       END;</div>

fbenoist68 commented

2023-07-04 07:17:30 +02:00

Event ID: 1279
Date: 2014-04-02T09:42:26Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 1279 Date: 2014-04-02T09:42:26Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist

fbenoist68 commented

2023-07-04 07:17:33 +02:00

Event ID: 1278
Date: 2014-04-02T09:42:25Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Event ID: 1278 Date: 2014-04-02T09:42:25Z Person: Frederik Benoist Description: Ouvert par Frederik Benoist

fbenoist68 referenced this issue

2023-07-04 07:38:17 +02:00

[FogBugz #355] Le dimanche les visites des DR pour un DZ sont fausses #418

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: fbenoist68/mobileportal#355