Difference between revisions of "Column: Timereg period"
(jrfconvert import) |
Cg huyphong (talk | contribs) |
||
Line 1: | Line 1: | ||
− | [[Category: | + | [[Category:Resource data caches]] |
| | ||
Line 40: | Line 40: | ||
Typically the axis for this column will look something like the below: | Typically the axis for this column will look something like the below: | ||
− | Axis text: "Time registration period"Math base: "TimeregPeriod"Pct base: "TimeregPeriod!=empty" | + | Axis text: "Time registration period" |
+ | <br>Math base: "TimeregPeriod" | ||
+ | <br>Pct base: "TimeregPeriod!=empty" | ||
− | Option 1: Name="Registrations Q1 2009"; Value="TimeregPeriod==123"Option 2: Name="...."; Value="TimeregPeriod==...", etc. | + | Option 1: Name="Registrations Q1 2009"; Value="TimeregPeriod==123" |
+ | <br>Option 2: Name="...."; Value="TimeregPeriod==...", etc. | ||
|- 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: | ||
| style="border: 1px solid #010101" width="839" | | | style="border: 1px solid #010101" width="839" | | ||
N/A | N/A | ||
− | |||
<!-- imported from file: 7815.htm--> | <!-- imported from file: 7815.htm--> |
Latest revision as of 08:42, 26 April 2011
Column: Timereg period
Column |
Timereg period |
Source |
The timereg period that the returned time registration record belongs to. |
Automatically given column name |
TimeregPeriod |
Column type |
Number |
Resource types that use it |
Folder, Project, Product, Report, Questionnaire, User, Group, Task |
How axis set information is built |
This column is what we call a "search string dependent axis option". This means that the axis set for it is rebuilt each time that the resource cache is rebuilt. The reason for this is, that the number of possible option outcomes for the column is changing each time the column is updated. For this column it will not make sense if you try to update its options directly in the axis set, since these will be reset on resource cache rebuild anyway. The axis set is built upon first extracting all the IDs that are in the "Timereg period" column, then creating one option in the axis set for each unique value. The option will be named the same as the time registration period record in catglobe that owns the ID. Let us say that the system finds the value "123" in this column. The system will then look up the time registration period name of the record with this ID and create an option in the axis with this name. Typically the axis for this column will look something like the below: Axis text: "Time registration period"
Option 1: Name="Registrations Q1 2009"; Value="TimeregPeriod==123"
|
Comment |
N/A |