Column: Respondent

From Catglobe Wiki
Revision as of 08:06, 26 April 2011 by Cg huyphong (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search



Column: Respondent

Column

Respondent

Source

The user id of the user who is set as respondent of an answer sheet. May be null if answer sheet has no respondent.

Automatically given column name

Respondent

Column type

Number

Resource types that use it

Questionnaire

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 "Respondent" column, then creating one option in the axis set for each unique value. The option will be named the same as the resource 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 username of the user with this ID and create an option in the axis automatically generated for the column.

Typically the axis for this column will look something like the below:

Axis text: "Respondent"
Math base: "Respondent"
Pct base: "Respondent!=empty"

Option 1: Name="UserABCDE"; Value="Respondent==123"
Option 2: Name="...."; Value="Respondent==...", etc.

Comment

N/A