Property Qualifier form
Completing the Table Edit tab

Table editing is part of property and page validation. If an input value for a property doesn't match the table edits, the property name and the invalid value remain on the clipboard, but during validation the system adds a message and error text to the clipboard page that contains the property. The presence of the message ordinarily prevents the system from saving the clipboard page (which contains invalid data) into the database. The message does not prevent an activity from reading or using the (invalid) property value.

Table Edit comparisons require an exact text match except for case. Use Table Edits carefully if the Type of the property is not Identifier or Text. For example, a value of 23.0 does not match a list entry of 23. ERNSG 4/12/05 B-13029

Although the value is compared with the table elements a case-insensitive way, the system corrects the case. For example, if the values recorded in a Local List on this tab are all lowercase, a user can enter at runtime the value in uppercase, mixed case, or lowercase letters. The system accepts a matching value but converts it to lowercase. R-5957

03-02 new checkbox?The fields on the Table Edit tab change after you select the Type of Table field.

Choose Local List as the Type of Table if your property value is permanently limited to a modest number of known values in a single language. (Use a Prompt List, not a Local List, to accomplish a similar localized presentation.)

You cannot use a Local List if the Type of the property is Password, True or False, Date, or DateTime. R-5870

A Table Values array appears. Complete the array listing each possible value as a literal. Order is not significant.

R-5543 Not working?If, at runtime, a user input or other processing assigns a non-null value to the property that is not on this list, the value is accepted but, when the page is later validated, the system adds an error message to the page.

For properties using this Table Edit option, a standard HTML Property rule named PromptSelect or RadioButtonsPROJ-183 is often used to present a selection list.

Select Class Key Value when a concrete class has either

• Two key parts that operate similarly to the second and third key parts of Rule-Obj-FieldValue rule type, or
• Three key parts where the first key part is the pyClassName property and the second and third key part. BUG-12565

The system uses that concrete class rather than field value rules as the source of allowable values for the property.

When you select Class Key Value, Table Description fields appear. Complete them to identify a range of keys in another class.

For example, assume that the class Data-CustomerTerritory class has key parts for state code and county name. Enter Data-CustomerTerritory as the Validation Class and "NY" as the Subset Name, to restrict the property to the county names in New York state.

The Class Key Value facility is a generalization of the Field Value case. For example, fifty-one standard field value rules have Data-Party as the first key part and pyState as the second key part (the Field Name key part). Values for the third key part range from AK (for Alaska) to WY (for Wyoming), identifying codes for 50 states and the District of Columbia. Two standard properties, Data-Party.pyHomeState and Data-Party.pyWorkState, use these field values through the Class Key Values. They use:

• Rule-Obj-FieldValue as the Class
• pyState as the Field Name

At runtime, if your system contains other field value rules in this key range (in an application RuleSet) such as PR for Puerto Rico, they also are acceptable values for pyHomeState and pyWorkState.

Choose Remote List when the set of valid values is not constant or not short, but is available at runtime as the keys of a certain known class.

Complete the fields that appear: