Table column control

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

Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

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: Open the probsummary.qbe.g form in the Design view of Forms Designer In the left-hand pane, click the Priority column header. 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". 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.

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.

Specify the object’s horizontal position based on the left edge of the object.

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:

Open the probsummary.qbe.g form in the Design view of Forms Designer
In the left-hand pane, click the Priority column header.
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".
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.

Related concepts