Skip to Main Content

Integration

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!

Display multiple values in LOV's in PCS Web Forms

Hi Team,
My requirement is to concatenate multiple element values from the same array set and display in LOV fields
Ex: we are storing the below REST API response in a BusinessType variable.
{"SSOTRelationshipQuery": [
{
"RelationshipId": "10309",
"RelationshipName": "",
"MajorProductId": 10011,
"SSOTProductId": 10088,
"SSOTModuleId": 10018,
"SSOTModalityId": 10002,
"SSOTUnitId": 10018,
"MajorProductName": "BIL",
"SSOTProductName": "Participant Fee Configured (Production Fee Excluded)",
"SSOTModuleName": "Cultivating Networks And Partnerships",
"SSOTModalityName": "Non Applicable",
"SSOTUnitName": "Participant/ Day"
},
{
"RelationshipId": "10334",
"RelationshipName": "",
"MajorProductId": 10011,
"SSOTProductId": 10293,
"SSOTModuleId": 10053,
"SSOTModalityId": 10002,
"SSOTUnitId": 10015,
"MajorProductName": "BIL",
"SSOTProductName": "Participant Fee Half-day Course",
"SSOTModuleName": "Mastering Emotional Intelligence",
"SSOTModalityName": "Non Applicable",
"SSOTUnitName": "Course/ Participant"
} ] }
Now we want to populate the following in LOV's
Expected Output - LOV:
Option 1: "MajorProductName": "BIL", "SSOTProductName": "Participant Fee Configured (Production Fee Excluded)", "SSOTModuleName": "Cultivating Networks And Partnerships", "SSOTModalityName": "Non Applicable", "SSOTUnitName": "Participant/ Day"
Option 2: "MajorProductName": "BIL","SSOTProductName": "Participant Fee Configured (Production Fee Excluded)","SSOTModuleName": "Cultivating Networks And Partnerships","SSOTModalityName": "Non Applicable","SSOTUnitName": "Participant/ Day"
How can we achieve the above scenario. ?

Thanks in Advance!!

Thank you,
Jagadeesh Kumar

Comments
Post Details
Added on Mar 1 2021
1 comment
123 views