Question

1
Replies
203
Views
SravanKumarK3988 Member since 2015 8 posts
Tata Consultancy Services
Posted: 4 years ago
Last activity: 4 years 9 months ago
Closed

query to get current op ID in sql developer

Hi,

As part of my requirement i have to write an store proc for getnextwork(whenever a user click on the button a case has to be picked based on the skills, prority , region and certain other parameters).

In Oracle Sql developer. i have below tables:

Skill Table:(columns: SKILL_ID,  SKILL_SEQ_NO, SKILL_NAME, CALL_TYPE, BUSINESS_UNIT,SPECIALITY_TYPE)

Call Type: (columns: CALL_TYPE, PRIORITY)

OCL Table: contains caseID

Please find the below algorithm:

in sql query how to get the skills of current operator ID so that i can query with the skill table and can get the remaining details for the particular skill.

Please help on this..

Thanks in advance..

Data Integration
Moderation Team has archived post
Share this page LinkedIn