LOVD Setup

Custom columns

Editing custom column default settings
After a custom column is added to a variant table or the patient table, part of the settings can be edited by curators or managers. But the default column settings are stored separately and cannot be edited by curators for three reasons:
  • Variant columns can have different appearance settings per gene.
  • Curators can modify some basic settings, but do not have permissions to edit the more advanced settings.
  • If a column's settings are screwed up for whatever reason, they can be reset to default settings which can be defined by a manager.

Because of this separation of settings, by default not all changes you make will take effect if the column has also been added to a variant table or the patient table, because some changes are overridden by the local display settings of that column. Changes to some advanced options do take effect immediately, like the MySQL data type and form field type. You can do two things to apply all of your changes also to selected columns;
  • You can (one by one) reset a selected column to the (new) default settings, to easily apply your changes to a selected column in a variant table or the patient table.
  • You can have your changes applied immediately by overriding all local display settings, by selecting the checkbox "Apply changes to patient table where this column is active" in case of a patient table or "Apply changes to all genes where this column is active" in case of a variant table. This checkbox will only appear if the column has actually been added to any of the tables.

If you wish to change the default order in which variant columns appear in future gene databases, click the "Manage all custom column default settings" link in the setup area and click the "Change default column order (for new genes)" button.

Edit column default settings
To edit the custom column default settings, click the "Manage all custom column default settings" link in the setup area, select the column of interest and click the "Edit column default settings" link. The fields on this form are explained in the creating new columns section.

Edit column ID (columns created by users only)
For columns which have been created by users of LOVD, you can change the column ID (the name the column is referenced by the system, such as "Variant/DNA") or move the column from the Patient to the Variant side or vice-versa, only if the column is currently not in use in the Patient table or any of the Variant tables. Click the "Manage all custom column default settings" link in the setup area, select the column of interest, click the "Edit column ID" link and complete the form.

Information This feature was added in LOVD 2.0-15, released 2009-02-03.

« Creating new columns Deleting custom columns »

Last modified 2014/08/25 14:48:31 CEST

When using or discussing LOVD please refer to:
Fokkema IF, Taschner PE, Schaafsma GC, Celli J, Laros JF, den Dunnen JT (2011). LOVD v.2.0: the next generation in gene variant databases. Hum Mutat. 2011 May;32(5):557-63.

LOVD has received funding from the European Community's Seventh Framework Programme
(FP7/2007-2013) under grant agreement nº 200754 - the GEN2PHEN project.
Leiden University Medical Center, Netherlands
Ing. Ivo F.A.C. Fokkema, Dr. Johan T. den Dunnen