Skip to Main Content

LiveLabs & Workshops

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

substring in Expression Language (EL)

We have a requirement to add a hyperlink component to the Person Management page to point users to a PeopleSoft environment by passing employee number as parameter for checking Job data history in PeopleSoft. in Cloud, We placed the Hyperlink under Assignment Details section in the Person Management page. As the Person Number is not available as bind variable under Assignment details section, we are using bind variable Assignment Number to get the employee assignment number and remove the letter 'E' from assignment number from the value returned using Expression Language (EL) and pass only employee number as parameter in the URL. Is there any substring function or alternate way to remove letter 'E' from the value returned using EL?
Below is the screenshot where we placed Hyperlink.
Capture111.PNG
Here's the full EL expression for the hyperlink (with a placeholder for the base URL).
http://<HOST>/psp/HDEV/EMPLOYEE/HRMS/c/ADMINISTER_WORKFORCE_(GBL).JOB_DATA.GBL?&EMPLID=
#{bindings.AssignmentNumber.inputValue}

I've reviewed all available documentation related to EL, but couldn't find what I was looking for.

Comments
Post Details
Added on Aug 18 2022
1 comment
1,013 views