PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

How can I get both the department ID and description to display in the drop down list.

edited May 20, 2020 5:01AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered

Hi, this may seem like a simple question and I hope someone has a simple answer, I am creating a dropdown list in a fluid page, I add department ID  and description to the drop down, but when I view the dropdown in the page, I only see description, how can I get both the department ID and description to display in the drop down. Thanks, here is the code I am using the populate the dropdown:

   &SQL = CreateSQL("SELECT A.DEPTID, A.DESCR FROM PS_DEPT_TBL A WHERE %Substring(A.DESCRSHORT, 1, 5) = :1 AND COMPANY = 'ALC' AND A.EFF_STATUS = 'A' AND A.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_DEPT_TBL B WHERE A.SETID = B.SETID AND A.DEPTID = B.DEPTID AND B.EFFDT <= %CurrentDateIn)", PR_REQUEST.BUSINESS_UNIT);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center