View source for Column: Timereg duplicate record

[[Category:Resource data caches]]


===Column: Timereg duplicate record===

{| class="tableintopic" style="border-collapse: collapse; border: 1px solid #010101" width="1067" border="1" cellpadding="2"
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Column
| style="border: 1px solid #010101" width="839" |
Timereg duplicate record
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Source
| style="border: 1px solid #010101" width="839" |
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.
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Automatically given column name
| style="border: 1px solid #010101" width="839" |
TimeregDuplicateRecord
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Column type
| style="border: 1px solid #010101" width="839" |
Boolean
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Resource types that use it
| style="border: 1px solid #010101" width="839" |
Folder, Project, Product, Report, Questionnaire, User, Group, Task
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
How axis set information is built
| style="border: 1px solid #010101" width="839" |
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"
<br>Math base: "TimeregDuplicateRecord"
<br>Pct base: "TimeregDuplicateRecord!=empty"

Option 1: Name="False"; Value="!TimeregDuplicateRecord"
<br>Option 2: Name="True"; Value="TimeregDuplicateRecord"
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Comment
| style="border: 1px solid #010101" width="839" |
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:

<nowiki>= sum(TimeregTime) where (TimeregUser == 10 &amp;&amp; Id == 12 &amp;&amp; TimeregDuplicate == FALSE)</nowiki>
<!-- imported from file: 7817.htm-->