Friday 18 July 2014

How to Get Single Employee with Multiple Rules in WorkFlow Query

/* Formatted on 7/18/2014 9:39:03 AM (QP5 v5.115.810.9015) */
SELECT orig_system,
       description,
       orig_system_id,
       name "Login Name",
       display_name "Employee Name"
FROM wf_local_roles wfr1
WHERE (wfr1.orig_system <> 'WF_LOCAL_ROLES' AND wfr1.orig_system_id <> 0)
      AND EXISTS
            (SELECT 'row found'
             FROM wf_local_roles wfr2
             WHERE (wfr2.orig_system <> 'WF_LOCAL_ROLES'
                    AND wfr2.orig_system_id <> 0)
                   AND wfr2.orig_system_id = wfr1.orig_system_id
                   AND wfr2.orig_system = wfr1.orig_system
                   AND wfr2.name <> wfr1.name)
ORDER BY orig_system

No comments:

Post a Comment