Handler - BusinessTimeBetween
BusinessTimeBetween handler calculates elapsed time between two date (and time) fields in a data card.
If BusinessHours or SLA information is defined, the result is shown as business time, otherwise the result is shown in real time. For example, if SLA attribute or BusinessHours attribute tells that business hours are 8-16, start date is 15 and end date is 9 on the next day, the result will be 2 hours. If the SLA/BusinessHours information is not defined, the result will be 18 hours. Check more information on BusinessHoursFinder and SLAFinder.
By default the result will be shown as minutes. Admin can define the unit to be used by metadata. Also, the rounding of conversion can be defined, for example 2.16332hours -> 2.2hours or 2.16hours.
The result will be calculated, when a data card is stored - not when user changes the values from user interface.
The following tables provide information on the attribute settings and metadata requirements for BusinessTimeBetween handler. Compulsory metadata is provided in a Required attribute metadata table, including proposals for possible metadata values.
Table 1. Attribute Settings
| Handler name | Datatype |
|---|---|
BusinessTimeBetween |
Decimal number |
Table 2. Required Attribute Metadata
| Name | Value | Description |
|---|---|---|
Start time attribute |
[attribute_code] | Attribute code of start time |
End time attribute |
[attribute_code] | Attribute code of end time |
Table 3. Optional Attribute Metadata
| Name | Value | Description |
|---|---|---|
Business Hours attribute |
[attribute_code] |
Code of Business Hours attribute of this template. If BusinessTime is not used, leave this blank. If you have Service Level Management configuration and SLA cards contain information about business hours, leave this blank. Defining this metadata overrides all SLA metadata configurations. Check more information on BusinessHoursFinder |
SLA attribute |
[attribute_code] |
Attribute code of attribute containing a reference to SLA data card used. The attribute may contain an Check more information on |
Default SLA data card |
[name of the default SLA data card] |
Name of the default SLA data card. Identifies the default SLA data card together with the defaultSLATemplate metadata. If defaultSLA settings are configured, default SLA will be used as a fallback SLA configuration if no SLA data cards are found using other configurations. Check more information on |
Default SLA template |
[template_code] |
Template code of the SLA template. Identifies the default SLA data card together with the defaultSLA metadata. Check more information on |
Pattern |
[###0.# | ###0.##] | Pattern of result. Rounding the values is defined here. 0.## defines the maximum number of decimals. |
Unit |
[minute | hour | day] |
Original value is in minutes. You can define here another unit. Possible values are hour and day (24 hours). If you want another unit, you can use denominator metadata. It is a good idea to set the attribute footer to match with the setting here. Note, that this metadata overwrites |
Denominator |
[integer value] |
Original value is in minutes. You can define here the denominator for the result. For example, setting the denominator to 60 you get the value in hours. Alternatively you can also use unit = hour or unit = day to alter the time unit. For example, to see how many 7,5-hour business days fit in a timeframe, you would set the denominator to 450 (7,5 * 60). Note, that this metadata is overwritten by |
Reduced attribute |
[attribute_code] | Attribute code of an attribute containing time in minutes which is to be reduced from the result. This metadata can be inserted multiple times. The data type of the target attribute must be either Number or Decimal number. |
Table of Contents