Defaulting Assignment DFF in Redwood with value from SQL query

Summary:

We need to populate a default value in one of the attribute of Assignment DFF. The value is based on SQL statement from Job EFF as below:

Select JEI_INFORMATION1
FROM PER_JOB_EXTRA_INFO_F JEI
Where 1=1
AND JEI.JEI_INFORMATION_CATEGORY ='Office Designation'
AND JEI.JOB_ID = :{PARAMETER.JOB_ID}

The above query is part of the Value Set default value as SQL.

But no value is not coming up in assignment change or any other changes/actions.

We need a solution to default value for Redwood page with the above query. Please help.

Thanks,

Content (please ensure you mask any confidential information):