Adding a column
A simple column option looks like this:
$this->columnoptions = array( new rb_column_option( 'course', 'fullname', 'Course Fullname', 'base.fullname' ) );
Requirements
Every column option object must include four required arguments:
- Column type:Â A string which describes the type of the column - typically this might be the same as the table name, and is used to group similar sorts of columns together
- Column value:Â A string describing the column more specifically - together the type and value must be unique within a source, and are used to reference the column elsewhere in the source
- Column name:Â A string which describes the column - this appears in the pulldown menu when choosing columns, and is also the default column heading in the report
- Column field definition:Â A snippet of SQL which describes how the database should access the column - typically this will be of the form 'base.[field name]' to access fields in the base table, or '[join name.field name]' to access fields from other tablesÂ
Once this column option is added to the source, a new option should appear in the pulldown on the columns tab of the report settings page.
See also advanced column options.