How to Convert DFF Default Value using SQL in VBCS
Summary:
We have a DFF used in Job Offer. This DFF has a default value using SQL (getting value from another DFF in Requisition page).
SQL is this:
select REQ.ATTRIBUTE_NUMBER1
from
IRC_REQUISITIONS_B REQ,
IRC_SUBMISSIONS SUB
where
REQ.REQUISITION_ID=SUB.REQUISITION_ID
AND SUB.SUBMISSION_ID=:{PARAMETER.SUBMISSION_ID}
How do we convert this to VBCS Default Value?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):