Get User and Users Manager record in single query from the same table

Below query gives you user XXXXXX record and XXXXXX manager records ie total 2 rows from the table hr_source

select hrview.userName,hrview.firstName,hrview.lastName,hrview.email,hrview.employeeNumber,hrview.supervisor
from hr_source hrview
where hrview.employeeNumber in( select hrview1.supervisor from hr_source hrview1 WHERE hrview1.userName='XXXXXX' )
UNION
select hrview1.userName,hrview1.firstName,hrview1.lastName,hrview1.email,hrview1.employeeNumber,hrview1.supervisor
from hr_source hrview1
WHERE hrview1.userName='XXXXXX'

Comments

Post a Comment

Popular posts from this blog

Rules in Sailpoint

Rules in Sailpoint Below are few commonly used rules in Sailpoint Sailpoint rules gets executed in the below order during aggregation Flow: Pre-Iterate Rule BuildMap Rule Managed Entitlement Customization Rule Customization rule Correlation rule Manager correlation rule Creation rule PostIterate Rule Pre-Iterate Rule: 1st rule that runs during aggregation You can perform below operations in this rule Check file existence Modify the data in the files Merge files BuildMap Rule: 2nd Rule thats runs during aggregation, Using build map rule you can deal with application schema ex: populate value for custom column for the application. Build map is not available for connected apps(JDBC has jdbc buildmap). Available only for disconnected apps like delimited files. Customization Rule:  Runs after buildmap rule, this can be used to transform data of resource object/account data during account aggregation Ex: if you have status value...
Read more

Sailpoint Installation Steps (IdentityIQ 7.3 Installation in Windows Machine)

This document helps you set up Sailpoint IdentityIQ 7.3 in Windows Operating System Softwares Required: MySQL 5.6 server Click here to download Apache Tomcat  9.0 Click here to download Java JDK 1.8 and above Click here to download Sailpoint IdentityIQ 7.3 application You may require to login into Sailpoint community to download Install the above softwares, update JDK, MySQL paths in environment Path variable Note: If you are facing issue in MySQL service then try running below commands mysqld –install net start mysql Sailpoint Configuration Steps: Create an \idenityiq directory under the Tomcat webapps directory: for example, C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\identityiq Unzip the identityiq-7.3.zip file. Copy iidentityiq.war file to the C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\identityiq Run below command to extract identityiq.war jar -xvf C:\Program Files\Apa...
Read more

How to develop a Scheduler in OIM

Image
Below steps help us in developing a new Scheduler in OIM 11G R2 PS3. Create a new Java project in Eclipse and add external jars from design console(you can add whatever Jars required for your scheduler) Create a new class which extends oracle.iam.scheduler.vo.TaskSupport as super class Write your business logic in Execute method Below is the basic structure of the Scheduler package com.ghr; import java.util.HashMap; import oracle.iam.scheduler.vo.TaskSupport; public class UpdateTCADRemovalDate extends TaskSupport { @Override public void execute(HashMap taskparams) throws Exception { // TODO Auto-generated method stub } @Override public HashMap getAttributes() { // TODO Auto-generated method stub return null; } @Override public void setAttributes() { // TODO Auto-generated method stub } } 3. Reading Task input parameters All the task input parameters available in taskparams variable which is of...
Read more