Applications → Managing Tables → About Tables → About the Value Display Format
The value display format setting controls many features:
Guidelines for the value display format follow:
You can set the order in which the fields appear, add text to the format, and use HTML tags to format the content. For example, specify this value display format:
<Title> - <b><Owner></b>
Items from the table will appear in search results as follows:
ITEM10098 This is the title of the item - Item's owner
The value display format determines how values appear in Single Relational and Multi-Relational selection lists on forms. For example, the value display format for a Versions table might be <Product Name> <Version Name>.
Relational field values based on auxiliary tables are sorted by the table's value display format. To change the order in which values sort for the Relational field, modify the value display format for the auxiliary table.
The value display format determines the fields that are searched and the order in which values are searched for:
For example, if you add the Item ID and Description fields as the value display format for a primary table, users can search for values by item ID or keyword for relational fields that reference the table.
The display order of the fields affects how the Value Find feature operates. Value Find separates the entered values based on spaces, and then searches for the first value in the first column, the second value in the second column, and so on.
For example, if users search for manager doe and the value display format is <FullName> - <Position>, the Value Find results will be None.
In addition, if users search for john doe with the value display format of <FullName> - <Position>, the Value Find results will be None. This is because Value Find looks for a <FullName> containing john and a <Position> containing doe.
Users must use quotation marks to treat the value as single entity when searching each column. For example, entering "john doe" in Value Find will yield the results John Doe - Manager.
If you specify multiple fields for the value display format for auxiliary tables, the fields are automatically shown in the first column of search results for the Manage Auxiliary Data feature.
This enables users to sort results by the value display format. For example, if the column contains a Title and First Name field in that order, results may appear as:
Copyright © 2007–2018 Serena Software, Inc., a Micro Focus company. All rights reserved.