Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sravan Kumar Kaleru (SravanKumarK3988)
Tata Consultancy Services

Tata Consultancy Services
IN
SravanKumarK3988 Member since 2015 9 posts
Tata Consultancy Services
Posted: Jan 11, 2016
Last activity: Jan 11, 2016
Posted: 11 Jan 2016 9:25 EST
Last activity: 11 Jan 2016 18:11 EST
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..

To see attachments, please log in.
Data Integration

Posted: 10 years ago
Posted: 11 Jan 2016 18:11 EST
Ravi Kumar Pisupati (Mr.Pisupati)
CVS Health
Lead Solutions Architect
CVS Health
US

Hello Saravan,

As pySkills is a pagelist property and is present in BLOB in PR_OPERATORS table, you need to build a logic from Pega by using Obj-Browse and all. Below is the generated SQL from Clipboard after I ran the activity on Operators table using Obj-Browse.

pxSQLStatementPost SELECT pzPVStream AS "pzPVStream" from pr_operators WHERE ( PYUSERIDENTIFIER = ? ) AND ( pxObjClass = ? )
pxSQLStatementPre SELECT pzPVStream AS "pzPVStream" from {CLASS:Data-Admin-Operator-ID} WHERE ( PYUSERIDENTIFIER = {pyReportParameters_temp.pyPreparedValues(1)} ) AND ( pxObjClass = {pyReportParameters_temp.pyPreparedValues(2)} )

SingleValue properties of page pySkills(1)

Property Value
pxObjClass Embed-Data-Admin-Skill
pySkillName

pySkillRating

Hope this gives an idea for your requirement.

Thanks,

Show More

Hello Saravan,

As pySkills is a pagelist property and is present in BLOB in PR_OPERATORS table, you need to build a logic from Pega by using Obj-Browse and all. Below is the generated SQL from Clipboard after I ran the activity on Operators table using Obj-Browse.

pxSQLStatementPost SELECT pzPVStream AS "pzPVStream" from pr_operators WHERE ( PYUSERIDENTIFIER = ? ) AND ( pxObjClass = ? )
pxSQLStatementPre SELECT pzPVStream AS "pzPVStream" from {CLASS:Data-Admin-Operator-ID} WHERE ( PYUSERIDENTIFIER = {pyReportParameters_temp.pyPreparedValues(1)} ) AND ( pxObjClass = {pyReportParameters_temp.pyPreparedValues(2)} )

SingleValue properties of page pySkills(1)

Property Value
pxObjClass Embed-Data-Admin-Skill
pySkillName

pySkillRating

Hope this gives an idea for your requirement.

Thanks,

Ravi Kumar


Show Less
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice