fbenoist68
/
mobileportal
1
0
Fork 0
Code Issues 739 Pull Requests Packages Projects Releases Wiki Activity

[FogBugz #301] Attention connect by prior et abandon is null #364

New Issue
Open
opened 2023-07-04 07:20:16 +02:00 by fbenoist68 · 5 comments
fbenoist68 commented 2023-07-04 07:20:16 +02:00
Owner

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:20:20 +02:00
Poster
Owner

Event ID: 1349
Date: 2014-06-25T03:08:57Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist

Event ID: 1349 Date: 2014-06-25T03:08:57Z Person: Frederik Benoist Description: Fermé par Frederik Benoist
fbenoist68 commented 2023-07-04 07:20:27 +02:00
Poster
Owner

Event ID: 1348
Date: 2014-06-25T03:08:57Z
Person: Frederik Benoist
Description: Résolu (Corrigé) and assigned to Frederik Benoist by Frederik Benoist

"and abandon is null" ajouté mais il manquait qq fois le where au dessus ....

Donc peut-être inutile ?

Event ID: 1348 Date: 2014-06-25T03:08:57Z Person: Frederik Benoist Description: R&#233;solu (Corrig&#233;) and assigned to Frederik Benoist by Frederik Benoist <p> &quot;and abandon is null&quot; ajout&eacute; mais il manquait qq fois le where au dessus ....</p> <p> Donc peut-&ecirc;tre inutile ?</p>
fbenoist68 commented 2023-07-04 07:20:30 +02:00
Poster
Owner

Event ID: 1312
Date: 2014-06-16T14:13:01Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Exemple :
 
 
WITH hierarchie
                     AS (SELECT     a.id_employe,
                                       INITCAP (emp_e.prenom)
                                    || ' '
                                    || UPPER (emp_e.nom)
                                       AS nom,
                                    mth.libelle,
                                    LEVEL AS niveau
                               FROM mr_hierarchie a
                                    JOIN employes emp_e
                                       ON emp_e.id_employe = a.id_employe
                                    JOIN mr_type_hierarchie mth
                                       ON mth.id_type_hierarchie =
                                             a.id_type_hierarchie
where a.abandon is null
                         START WITH a.id_employe = v_employe
                         CONNECT BY PRIOR a.id_employe = a.id_responsable and a.abandon is null)
Event ID: 1312 Date: 2014-06-16T14:13:01Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <div> Exemple :</div> <div> &nbsp;</div> <div> &nbsp;</div> <div> WITH hierarchie</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS (SELECT &nbsp; &nbsp; a.id_employe,</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;INITCAP (emp_e.prenom)</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || &#39; &#39;</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || UPPER (emp_e.nom)</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS nom,</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mth.libelle,</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LEVEL AS niveau</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM mr_hierarchie a</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JOIN employes emp_e</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ON emp_e.id_employe = a.id_employe</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JOIN mr_type_hierarchie mth</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ON mth.id_type_hierarchie =</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a.id_type_hierarchie</div> <div> <strong>where a.abandon is null</strong></div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;START WITH a.id_employe = v_employe</div> <div> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CONNECT BY PRIOR a.id_employe = a.id_responsable <strong>and a.abandon is null</strong>)</div>
fbenoist68 commented 2023-07-04 07:20:32 +02:00
Poster
Owner

Event ID: 1311
Date: 2014-06-16T14:11:51Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 1311 Date: 2014-06-16T14:11:51Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
fbenoist68 commented 2023-07-04 07:20:36 +02:00
Poster
Owner

Event ID: 1310
Date: 2014-06-16T14:11:50Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Event ID: 1310 Date: 2014-06-16T14:11:50Z Person: Frederik Benoist Description: Ouvert par Frederik Benoist
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
main
Labels
Clear labels
No items
No Label
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: fbenoist68/mobileportal#364
There is no content yet.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may exist for a short time before cleaning up, in most cases it CANNOT be undone. Continue?