Changes between Version 4 and Version 5 of REDCap sql fields

Timestamp:

01/31/14 10:19:08 (11 years ago)

Author:

Nick Holden

Comment:

--

REDCap sql fields

@@ -46 +46 @@
 value VARCHAR(100),
 label VARCHAR(100),
+sort_order TINYINT,
 INDEX reference (project,form,field),
+INDEX sort_order_1 (sort_order),
+INDEX sort_order_2 (sort_order,label),
 KEY value_key (project,form,field,value),
 KEY label_key (project,form,field,label)
@@ -92 +95 @@
 }}}
 
+=== Display order === 
+
+As per #173 (the first use case / ticket for SQL fields in our REDCap) Daisy asked to have one specific option (in this case 'Other') elevated to first in the list. This seems a generalisable requirement (e.g. country might well offer UK before an alphabetised list. Best way to deliver would be to have a 'sort order' column, and use that as the first order by column, reverting to alphabetical as a second order by column, if desired.
+
+Table definition above has been edited. Amendment in test.