Column: Timereg duplicate record
Column: Timereg duplicate record
|
Column |
Timereg duplicate record |
|
Source |
This column will be set to true for the first instance of the same time registration record that is added for a resource cache. Should any duplicates be added, then these will be set to false. The reason that duplicates may exist is when a resource cache has both CATI contact log records AND time registration records included in columns. In this situation a time registration record will be copied multiple times for each cati contact log record. |
|
Automatically given column name |
TimeregDuplicateRecord |
|
Column type |
Boolean |
|
Resource types that use it |
Folder, Project, Product, Report, Questionnaire, User, Group, Task |
|
How axis set information is built |
Since this is a boolean column, then the possible values that can exist in this column are only 0 and 1, which corresponds to "False" and "True". It is therefore easy to create the axis since we have a limited well defined number of outcomes. The axis generated for this column will look like below: Axis text: "Time registration duplicate record"
Option 1: Name="False"; Value="!TimeregDuplicateRecord"
|
|
Comment |
As a time registration record can occur in more than one data row, this column helps you “SELECT DISTINCT” time registration records in a resource cache, so for example the following expression will return the actual time the user with Id 10 has spent on the resource with Id 12: = sum(TimeregTime) where (TimeregUser == 10 && Id == 12 && TimeregDuplicate == FALSE) |
