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

Default EFF or DFF value using 'Default Type' SQL

edited Sep 24, 2025 6:57AM in Product Development 1 comment

Summary:

Need to update Change Order EFF with Business Unit of the Change Requester.

Content (please ensure you mask any confidential information):

Need to update Change Order EFF with Business Unit Assigned to Change Requester, 'Manage Users' → 'Business Unit'.

Trying to achieve it using 'Default Type' SQL in the EFF setup. In the Product Documentation, found that we can use #{PARAMETER.<PARAMETER_NAME>} in the WHERE clause.

Help me with 'PARAMETER_NAME' for Change Requester. Tried passing RequestorId and AssigneeId, getting error as invalid value.

Version (include the version you are using, if applicable):

25C

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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