Filter button at the top of the
form and use the Valid Values Type, Description, and Valid Values fields
to search for specific records. Click Find to display the search results.A Valid Value is an output from a class, list, or query that counts as an acceptable answer to an event prompt. You can select a Valid Value when you add or modify an event on the Prompt tab of the Event form.
See Also:
Valid Values Field Descriptions
Find, Add, Modify, Delete, or Copy a Valid Value
Using Semantics in the Valid Values Query
Using Prepared Statements in Queries
Valid Values ID
System-generated identification number for the record.
Valid Values Type
Indicates the type of information that will be contained in the Valid Value record.
Class: Group of objects with the same properties and behaviors. For example, com.kaba.pve.erp.otl.validvalues.ChargeCodesValidValues.
List: A list of Valid Values separated by commas. Each valid value should be formatted to include the value that will be stored in the database and the value that will be displayed to the user. For example, the Operation Complete Valid Values are 1:Yes,0:No. The user will be presented with Yes and No options. Yes will return a value of 1 and No will return a value of 0.
Query: A request for information presented to the database. For example, select distinct charge_element.data_group_name FROM charge_element where charge_element.charge_type = 'ORDER'. You can include prepared statements in these queries. You can also use semantics and event prompt values in this query; see Using Semantics in the Valid Values Query.
Description
Description of the Valid Value record. The description is the value that can be selected from the Valid Value field on the Prompt tab of the Events form.
Valid Values
The class, list, or query that has been defined for the Valid Value record.
Empty Value Flag
When this box is checked, the Valid Values that appear for the event prompt will include a blank value. The event prompt will display this blank value by default, instead of defaulting to the first Valid Value in the list.
By default, the Empty Value Flag box is not checked.
System Required
If this box is checked, the record cannot be modified or deleted.
Update Date, Updated By
These fields display when the record was created or updated, and the person who created or updated the record.
To find a valid
value, click the Filter button at the top of the
form and use the Valid Values Type, Description, and Valid Values fields
to search for specific records. Click Find to display the search results.
To add a new valid value, click Add. Enter values in the fields and click Save.
You can modify any setting in the valid value except the Valid Values ID and Valid Values Type. You cannot modify a System Required valid value.
You can copy a valid value and save the duplicate with a new name. To do so, select the valid value and click Copy. Change the fields as necessary and click Save.
You cannot delete a valid value if it has been assigned to an event prompt. You cannot delete a System Required valid value.
You can use the following semantics in a Valid Values Query to specify the person for whom the event is posting, the name of the event, and other values:
[%GID%]
[%DID%]
[%PERSON_ID%]
[%PERSON_NUM%]
[%CREATOR_ID%]
[%EVENT_NAME%]
[%TIMESTAMP%]
[%ROUNDED_TIMESTAMP%]
[%POST_DATE%]
[%TIMEZONE%]
You can also use the event's prompts (defined on the Prompt tab) in the query. For example, if the event has a Project number prompt (F_PROJECT), you can use [%F_PROJECT%] in the query to specify the Project number the user entered. You can use the F_HOURS and F_POSTING_DATE prompts, even if they are not included in the event's prompt configuration.