ICP input value’s List of value is not visible on redwood, — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ICP input value’s List of value is not visible on redwood,

Summary:

Hi everyone,
We are able to retrieve the table values set values on Redwood ICP pages. The value set is fetching the selected employee's dependent name. We identified that this issue is occurring due to the {Parameter.PersonId} in the query.

Value Set Query is below

select ppnf1.display_name
from
per_contact_relationships pcr,
per_person_names_f ppnf,
per_person_names_f ppnf1,
per_persons per
where
sysdate between ppnf.effective_start_date and ppnf.effective_end_date
and ppnf.name_type='GLOBAL'
and sysdate between ppnf1.effective_start_date and ppnf1.effective_end_date
and ppnf1.name_type='GLOBAL'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!