Default Values

A Default Value is a pre-defined answer that you can add to an event prompt, so that the event prompt displays with a value in it. You can select a Default Value for an event prompt on the Prompt tab of the Events form.

See Also:

Default Values Field Descriptions

Find, Add, Modify, Delete, or Copy a Default Value

Using Semantics in the Default Values Query

Using Prepared Statements in Queries

 

Default Values Field Descriptions

Default Value ID

System generated ID number for the Default Value record.

Default Value Type

Indicates the type of information that will be contained in the Default Value record.

Static: Non-changing, constant value. For example, YES.

Class: Group of objects with the same properties and behaviors. The Default Values of this type are system-required and cannot be modified. For example, com.kaba.pve.erp.otl.defaultvalues.OverCompletionAllowedDefaultValue.

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 Default Values Query.

You can create new Default Values of type Static or Query.

Description

Description of the Default Value record. The description is the value that can be selected from the Default Value field on the Prompt tab of the Events form.

Default Value

The static value, class, or query that has been defined for the Default Value record.

System Required

If this check box is selected, 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.

 

Find, Add, Modify, Delete, or Copy a Default Value

To find a default value, click the Filter button at the top of the form and use the Default Value Type, Description, and Default Value fields to search for specific records. Click Find to display the search results.

To add a new default value, click Add. Enter values in the fields and click Save.

You can modify any setting in the default value except the Default Value ID. You cannot modify a System Required default value.

You can copy a default value and save the duplicate with a new name. To do so, select the default value and click Copy. Change the fields as necessary and click Save.

You cannot delete a default value if it has been assigned to an event prompt. You cannot delete a System Required default value.

 

Using Semantics in the Default Values Query

You can use the following semantics in a Default 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.