Table column control

Use this control to add a column to an existing table.

Note To avoid unpredictable behavior, do not set a DVD condition to use a variable that is based on a record displayed in the Table widget.

To add a column to a table, click Table column and then click the table.
Be sure to put the name of the database field or variable that you want to associate with this control into the Input property.

Best practice

Column headings should follow book title capitalization rules, for example, File Name not file name or file.name.

Property Usage
Name Specify a unique identifier for the object on the screen. (Optional)

This name is used by external applications, such as RAD, to dynamically change the properties of the object.
X Specify the object’s horizontal position based on the left edge of the object.
Y Specify the object’s vertical position based on the top edge of the object.
Width Specify the width of the object in alignment grid units.
Height Specify the height of the object in alignment grid units.
Visible Select this option to make the object visible on the form. Clear the check box to hide the object from view on the form.
Visible Condition Specify an expression to override the Visible property when that expression evaluates to true.
Caption Specify a text caption for the object.
Caption Condition Specify an expression to override the Caption property when that expression evaluates to true.
Input Specify the database field or variable to associate with this control.
Accessible Name Specify a component name for use with accessibility software. (Optional)

Note: This function is only supported by the Web client.

If no name is present, the Web client defaults to looking for a nearby label to use for the name of the component. For buttons, check boxes, or radio buttons, it uses the component’s text. Accessibility software can query the Web client to get this information and use it to present data to the user in a variety of ways. For example, speech simulation software says the name and the type of component when the component has focus.
Accessible Description Specify a component description for use with accessibility software. (Optional)

Note: This function is only supported by the Web client.

If no description is present, the Web client defaults to looking for a nearby label to use for the name of the component. For buttons, check boxes, or radio buttons, the Web client will use the component’s text. Accessibility software can query the Web client to get this information, and use it to present it to the user in a variety of ways. For example, when a component gets focus, speech simulation software will say the name and the type of component, based on the settings in the Accessible Name and Accessible Description fields.
Field In the case where the array specified in the input property is an array of structure, it specifies the field in the structure for this object.
Column Width Percent Enables you to set the column width to a percentage of the page.
Minimum Column Width Enables you to set the minimum width of the column in a table.
Clickable Title Select this option to allow the user to click the title.
Button ID When an individual column Button ID is set to 0, the Default Button ID is used.
Show Title Select this option to make the title appear in the table.
Value List In conjunction with the Input property, defines how the Display List values are identified in the database. Value and Display Lists are entered using the Edit List dialog box. You can enter hard coded entries for each list, or you can supply a variable as the first and only entry. The run time values of the variable are used to populate these lists.

This property is supported only in association with the toolbar configuration Knowledge Management Extended, which is not intended to be used outside of the out-of-box Knowledge Management module.
Image File

Specifies the name of an image file to display on the control. The image file must reside in one of the following paths:

Windows client:

  • <Service Manager>\Client\plugins\com.hp.ov.sm.client.common_x.xx.xxx\src\resources\icons

  • A local directory on the client machine, which is specified in the Image path field (Window > Preferences). For example: C:\smCustomImages.

Web client:

  • <Service Manager web tier>\images. For example: <Tomcat>\webapps\webtier-x.xx\images.

Note You do not need to include the image file suffix for this property; the image file name must be unique.

For example, you would like to display an image instead of text for the Priority column. To do this, follow these steps:

  1. Open the probsummary.qbe.g form in the Design view of Forms Designer
  2. In the left-hand pane, click the Priority column header.
  3. In the right-hand (Table Column) pane, update the Value List option to "1;2;3;4" and the Image File option to "critical;high;mid;low".
  4. Add four image files (named "critical.png", "high.png", "mid.png", and "low.png") to the following paths:
    • Windows client:

      ...\plugins\com.hp.ov.sm.client.common_x.xx\src\resources\icons\obj16

    • Web client on Tomcat (for example):

      ...\<Tomcat>\webapps\webtier-x.xx\images\obj16

 

Display List Specify the values that appear in the drop-down list at run time. There must be a one–to–one correspondence between the values for Value List and for Display List. If the Display List is the only populated property, the display values are what is written to the database.
Select Only Setting Select Only to Yes by checking the box requires the user to select from the Combo Box drop-down list. If the user makes a manual entry, the value must already exist in the drop-down list (defined in the Value List and Display List properties).

Setting it to No by leaving the box unchecked allows the user to select from the drop-down list or to manually enter a value. No works with or without a drop-down list as defined in the and Display List properties.
Read-Only Select this option to disable editing capabilities and provide only viewing access to the field. Give read–only fields a tab–stop value of –1 to prevent users from tabbing into them.
Maximum Chars Specify the number of characters the user can enter in the field. The default is 0 (unlimited).
Maximum Characters Beep When set to Yes by checking the box, it notifies the user by sounding a beep that they reached the maximum number of characters. Not available on UNIX systems.
Case Conversion Specify how to change the case of text entered in the field. The choices are None, Upper, Lower.
Decimals Specify the number of decimal points for numbers in this field.
Service Manager modifies numbers entered in the field to the number of decimal points you specify.
Parse Select this option to verify that the text entered in a field is the correct syntax. The syntax for the field is defined by the type of field it displays (date, expression, number, and so forth).
Justification Specify the justification for the object label as Left, Right, or Center.
Input Conversion Specify the name of an Input Conversion routine. This property is used by RAD subroutines that mask the display of data on an input field, or check and validate the entry of data into an input field. If specified, the routine is called at runtime to convert the contents of the field before it is displayed on the screen. For examples, refer to the RAD input and output routines.
Mask Specify the mask value (the condition that sets a value to be passed for this field to the input and output conversion routines). When a field has a mask value and you save the record, the format of the mask value displays in the field. For example, you decide to update the purchase cost information of a contract in Configuration Management. You enter a date in the Currency EX Date field of the Financial tab as 02/26/09. The condition for the mask value is set as: xxx dd,yyyy. When you save the record, the Currency Ex Date field displays the date format of February 26, 2009. Valid values for the mask vary depending on the routine being called.
Output Conversion Specify the name of an Output Conversion routine. This property is used by RAD subroutines that mask the display of data on an output field, or check and validate the entry of data into an input field. If specified, the routine is called at runtime to convert the contents of the field before it is displayed on the screen. For examples, refer to the RAD input and output routines.
Password Select this option to make the text entered in the field a series of asterisks on the screen. The data is not encrypted, just transposed.