You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

Introduction

Date and Time Duplicate Validator is a form validator plugin to check for conflict in date and time fields. An example of the use of this plugin is in the Meeting Room Booking App.

This validator is used in "Edit Date Picker > Validator = Date and Time Duplicate Validator > Validator (Date and Time Duplicate Validator)" properties.

For this plugin to work, it requires a pair of "Start Date" and "End Date" field IDs. These fields must already exist in your form.


Date and Time Duplicate Validator Properties

NameDescription
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.
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. 

Figure 2: Date and Time Duplicate Validator > Filter


Filter Conditions

Filter Conditions

NameDescription
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
ValueFilter value
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#'

Download Demo App From Marketplace


Meeting Room Booking App

Download Plugin From Marketplace


Date and Time Duplicate Validator


  • No labels