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 Value in Value Set based on SQL Query not auto-populated but user has to select.

Received Response

Hi All,

We are trying to set up an Initial Default on a descriptive flexfield. We are trying to achieve it based on a SQL Query.

The field to be defaulted is a Value Set with values either as Y or N and to be derived based on an attribute(attribute1) in projects table based on Project number. This is not defaulting the field as expected. It is only restricting the value as either Y or N based on the query and user has to manually select the displayed option. Ideally we would want the value as either Y or N to be present automatically and not require user to select. Appreciate any leads or guidance on this.

Howdy, Stranger!

Log In

To view full details, sign in.


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