Difference between revisions of "Column: Timereg duplicate record"
(jrfconvert import) |
Cg huyphong (talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | [[Category: | + | [[Category:Resource data caches]] |
| | ||
| Line 38: | Line 38: | ||
The axis generated for this column will look like below: | The axis generated for this column will look like below: | ||
| − | Axis text: "Time registration duplicate record"Math base: "TimeregDuplicateRecord"Pct base: "TimeregDuplicateRecord!=empty" | + | Axis text: "Time registration duplicate record" |
| + | <br>Math base: "TimeregDuplicateRecord" | ||
| + | <br>Pct base: "TimeregDuplicateRecord!=empty" | ||
| − | Option 1: Name="False"; Value="!TimeregDuplicateRecord"Option 2: Name="True"; Value="TimeregDuplicateRecord" | + | Option 1: Name="False"; Value="!TimeregDuplicateRecord" |
| + | <br>Option 2: Name="True"; Value="TimeregDuplicateRecord" | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" | | | style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" | | ||
| Line 48: | Line 51: | ||
<nowiki>= sum(TimeregTime) where (TimeregUser == 10 && Id == 12 && TimeregDuplicate == FALSE)</nowiki> | <nowiki>= sum(TimeregTime) where (TimeregUser == 10 && Id == 12 && TimeregDuplicate == FALSE)</nowiki> | ||
| − | |||
<!-- imported from file: 7817.htm--> | <!-- imported from file: 7817.htm--> | ||
Latest revision as of 08:43, 26 April 2011
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) |
