Previous | Next | Contents | Index | Navigation | Glossary | Library |
The view uses each structure's segment names as view column names. The context (structure) column uses the context prompt as the view column name (this may be something like "Context_Value" or "Client_Type"). In the view column names, underscores ( _ ) replace all non-alphanumeric characters. For example, "Context Value" becomes "CONTEXT_VALUE" and "Manager's Title" becomes "MANAGER_S_TITLE".
If segments in different structures (contexts) have identical names, these segments share the same view column. If two or more segments share a view column, then these segments should use value sets of the same format type.
The Descriptive Flexfield View also shows the concatenated segment values in the flexfield as a single column in the view. That column also contains the context value as a "segment" value. The CONCATENATED_SEGMENTS column contains global segments (if any are enabled), the context value, and any context-sensitive segments, in that order. The view does not contain any other columns from the underlying table except a ROW_ID (not ROWID) column, the context column and the columns that are used by enabled segments. The ROW_ID column in the view corresponds to ROWID in the actual table.
Key Flexfield Concatenated Segment View
Using Flexfield Views to Write a Report
Descriptive Flexfield View Example
Previous | Next | Contents | Index | Navigation | Glossary | Library |