Value Display Format….What is that?

Value Display Format….What is that?

 

Normal 0 false false false EN-US X-NONE X-NONE

tableproperty.png

This property is actually very important as it drives the view in many places when looking at workflow items or auxiliary table items.

  1. Built-In Report display
  2. Relational Field display
  3. Linked Item display
  4. Sub-task widget display
  5. Relational Field Sorting and Searches

What happens when you don’t want to just view the record id and the title field in these locations?

For each of these areas where the value display format is used, you have two options.

The first option is the same for all, you can change the value display format.  Unfortunately for primary tables, you will always have the record id as the first bit of data, but then everything after that is configurable.  You change the configuration by putting your mouse in the value display format attribute in the Data Design in Composer and then type a curly brace { then a popup will list the fields in your table and you select what you want to include.  You can add colons, semi-colons, spaces, etc. to separate the data elements you include.  You can even include HTML.  There are two gotchas.

1.      The format will apply to everything in that table for all of the displays mentioned above.

2.      If you have a list of items, they will not be neatly laid out in columns.  Each line is rendered independently.  Which means your display could get end up being pretty ugly. 

multi-relational_display.png

Here are your alternatives.

  1. Built-in Reports – Create your own listing reports.
  2. Relational field display – Use a relational grid/embedded report
    1. The relational grid is an option when using the embedded report widget.
    2. Essentially you are creating a report in Composer and using the embedded report instead of the relational field. (NOTE: if going this route, the relational field is not allowed on your form…Composer will throw an error and tell you to remove it.)
    3. There are two major benefits.
      1. Especially if you are using an auxiliary table and want to show more columns of data for a user to select from, you can show this nicely with the relational grid.
      2. You can include a text element and some helpful text to make the searching more intuitive.
  3. Linked Item Display – Use relational fields instead/relational grids/embedded report
  4. Sub-task widget Display – Use relational fields/relational grids/embedded report.

Relational Grid Sample:

relationalgrid.png

Embedded Report Sample:

embeddedreport.png

 More details on the Value Display Format are available in the SBM Composer Guide.

 

Labels (1)

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Comments
x
Top Contributors
Version history
Revision #:
2 of 2
Last update:
‎2020-01-30 18:20
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.