Joget DX 8 Beta Released
The beta release for Joget DX 8 is now available, with a focus on UX and Governance.
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 these fields; "Start Date" and "End Date" field IDs. These fields must already exist in your form.
This plugin source code is available in a new open source repository at https://github.com/jogetoss/. JogetOSS is a community-led team for open source software related to the Joget no-code/low-code application platform. Projects under JogetOSS are community-driven and community-supported, and you are welcome to contribute to the projects.
Figure 1: Date and Time Duplicate Validator
|Start Date Field ID *||Field ID for "From" date range. This field is mandatory.|
|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.|
Figure 2: Date and Time Duplicate Validator > Filter
|Resource Field ID||Field ID to validate the availability of a resource during the specific time specified.|
Additional condition(s) for filtering the data set. HQL is expected here.
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.
e.customProperties.title = 'Trip'
A hash variable is accepted here.
e.customProperties.submitted_by = '#currentUser.id#'
Userview Key can be used as part of the condition.
e.customProperties.category_id = '#userviewKey#'