...

Name

Description

Screen (Click to view)

Resource Field ID

Field ID to validate the availability of a resource during the specific time specified.

Figure 2: Date and Time Duplicate Validator > Filter

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

Extra Conditions

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

Info

title	Syntax Query

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

Info

title	HQL is accepted

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

Code Block

title	Sample

e.customProperties.title = 'Trip'

A hash variable is accepted here.

Code Block

title	Sample

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

Userview Key can be used as part of the condition.

Code Block

language	sql
title	Sample

e.customProperties.category_id = '#userviewKey#'

Download Plugin and App

...

Meeting Room Booking App
Date and Time Duplicate Validator
...