Friday, 28 February 2020
autanabp
List of values
The value lists entity is a fairly simple entity in Siebel and with very limited use of displaying values from the picklist.
- Set of values to teach in a picklist;
- Only the values in the list that have the Asset Flag selected are taught
The values in a list can be used in:
- Picklists
- Scripts
- calculated fields
- expressions
They are used for:
- Comply with business rules
- Facilitate data insertion
- Facilitate future changes without having to touch code
Unify the way to represent the same value
- Avoid mistakes
- Avoid different ways of representing the same value
Picklist
It is what allows the user to choose a value from a list. A picklist can have a search specification to restrict the values in the List of values to be taught or a sort specification to indicate how the values in the list will be presented.
Types of Picklists
- Static
- Visible values by drop-down list
- Displays values saved in table S_LST_OF_VAL
- Based on the business component Picklist Generic or Picklist hierarchical
- Values can be bounded or unbounded
- Values do not change at run time
- Dynamics
- Values visible by pick applet
- Displays values from any business component (to be chosen)
- Dynamic values that depend on business component records
- Values change at run time
- Limited (bounded)
- User can define a value from a range of predefined values
- The user cannot, when choosing a value from the list, enter a value that suits him
- An error is thrown when trying
- Unbounded
- User can define a value from a range of predefined values
- User can insert other values that are not in the list
Picklist Generic
A simple picklist, it shows the value and has no dependencies. Example: MR_MS
Picklist Hierarchical
A picklist that has dependencies. There are values that depend on a parent value. Example: The Area and Subarea fields of the Service Request entity. They respectively have the picklists “PickList SR Area” and “PickList SR Hierarchical Sub-Area”. The value of the Subarea field will show values that will depend on the value you choose in the Area field.
- Why use a Hierarchical Picklist?
- To better model the client’s business needs
- To restrict values based on other picklists or other values in the same picklist
