Applies to version: 2020.1.x and above; author: Franciszek Sakławski
When designing the processes and individual workflows in WEBCON BPS, it is good to know how the data is stored in the tables, what are the relations between them and how individual information is displayed on the form. This article describes the Calendars table.
The Calendars table stores the calendar days. To modify the calendar, go to the “System settings” and in the “Global parameters” tab select the “Working days calendar” option.
Fig. 1. The configuration of the calendar in WEBCON BPS Designer Studio
You can define the non-working days of week and non-working dates (e.g. holidays) in a given year.
Storing the data
Below three most often used columns from the user’s point of view was displayed:
- CAL_IsDeleted – information whether the row was deleted
- CAL_WorkingDate – a date
- CAL_IsWorkingDay – information whether a current day is a working day
The data in the Calendars table:
Fig. 2. The Calendars table
The simple “Leave of absence” workflow used to register the absence requests was created.
Fig. 3. The “Leave of absence” workflow
At the exit from the “Registration” step, the “Calculate days off” action has been created. This action calculates how many working days were selected by the employee in the planned date and then, displays this information on the form. After approving the request, the number of days is subtracted from the employee pool.
Fig. 4. The configuration of the action
The SQL query used in this action:
Fig. 5. The SQL query uses to calculate the working days
This query uses the Calendar table. From this table in the third row, you can limit the extracted rows by the date range defined on the request (”Leave start”, “Leave end”) and then, in the fourth row limit these days to working days only (CAL_IsWorkingDay = 1) and deleted the entries from the table.
The Calendars table allows you to operate the non-working and working days by defining them in WEBCON BPS Designer Studio. A properly configured calendar can bring many benefits. The chosen business example is only one of the many possibilities of using the table.