To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
In table value set how to fetch XML cachedata in Transaction table
Summary:
I am currently using below query in data model and getting correct output. But when moved to value set :
TABLE(per_bipntf_utility.extractXMLSequenceForEO(txnd.transaction_id,'ElementEntryValueDEO',0)) , this table is not taken properly as the transaction ID highlighted is dynamic.
Any suggestions to use the above in value set to retrieve data properly.
--------------------------------------------------------------------------------------------------------------------
select txnh.transaction_id
FROM hrc_txn_header txnh, hrc_txn_data txnd, TABLE(per_bipntf_utility.extractXMLSequenceForEO(txnd.transaction_id,'ElementEntryValueDEO',0)) CompensationDetails
where txnd.status = 'PENDING'
and txnh.subject_id = :{PARAMETER.P_PERSON_ID}
and txnh.object = 'CMP_VC_PER_ELIG_PLANS'
and txnh.transaction_id = txnd.transaction_id