Versions Compared

Old Version 1

changes.mady.by.user Lim Yi Zheng

Saved on

compared with

New Version 2

changes.mady.by.user Lim Yi Zheng

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

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

NameDescription
Start Date Field ID *Field ID for "From" date range. This field is mandatory.

Image Added

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.
MandatoryWhen checked, field must be filled. 
Mandatory Error Message *Custom error message to display for duplicate value found.


Advanced

Filter

NameDescriptionScreen (Click to view)
Resource Field IDField ID to validate the availability of a resource during the specific time specified. This field is mandatory.
Filter Conditions

Filter Conditions

NameDescription
Join Type
  • And
  • Or
Field

Field ID. (e.g. title)

Image Added

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
ValueFilter value

Image Added

Figure 2: Date and Time Duplicate Validator > Filter

Extra Conditions

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

Info
titleSyntax Query
Start your filter name with e.customProperties. followed by the field id (i.e. title)
Image Added
Info
titleHQL is accepted

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

Image Added

Code Block
titleSample
e.customProperties.title = 'Trip'

A hash variable is accepted here.

Code Block
titleSample
e.customProperties.submitted_by = '#currentUser.id#'

Userview Key can be used as part of the condition.

Code Block
languagesql
titleSample
e.customProperties.category_id = '#userviewKey#'

Download Demo App From Marketplace


Meeting Room Booking App