Introduction

Date and Time Duplicate Validator makes sure that no duplicate date and time is entered into the form for the designated field id.

Date and Time Duplicate Validator Properties

Name	Description
Start Date Field ID *	Field ID for "From" date range. This field is mandatory.	Figure 1: Date and Time Duplicate Validator
End Date Field ID *	Field ID for "To" date range. This field is mandatory.
Data Format *	In Java date format; e.g. yyyy-MM-dd for 2011-06-01. This field is mandatory.
Display Format *	Please refer to http://docs.jquery.com/UI/Datepicker/formatDate. This field is mandatory.
Validation Error Message *	Custom error message to display for duplicate value found. This field is mandatory.
Mandatory	When checked, field must be filled.
Mandatory Error Message *	Custom error message to display for duplicate value found.

Name

Description

Screen (Click to view)

Resource Field ID

Field ID to validate the availability of a resource during the specific time specified. This field is mandatory.

Filter Conditions

Name	Description
Join Type	And Or
Field	Field ID. (e.g. title)
Operator	Equal Not Equal Greater Than Greater Than Or Equal Less Than Less Than Or Equal Like Not Like In Not In Is True Is False Is Null Is Not Null
Value	Filter value

Figure 2: Date and Time Duplicate Validator > Filter

Extra Conditions

Additional condition(s) for filtering the data set. HQL is expected here.

Syntax Query

Start your filter name with e.customProperties. followed by the field id (i.e. title)

HQL is accepted

You may even use an operator such as "LIKE" to narrow down your data set.

Sample

e.customProperties.title = 'Trip'

A hash variable is accepted here.

Sample

e.customProperties.submitted_by = '#currentUser.id#'

Userview Key can be used as part of the condition.

Sample

e.customProperties.category_id = '#userviewKey#'