TAMULib / Vireo

Vireo is a turnkey Electronic Thesis and Dissertation (ETD) Management System.
http://vireoetd.org/vireo/
1 stars 0 forks source link

[Issue 51]: Submission list combined predicate column sort #89

Closed wwelling closed 1 month ago

wwelling commented 1 month ago

Here is a migration script adding Student Name submission list column:

INSERT INTO submission_list_column (predicate,status,title,input_type_id) VALUES ('last_name, first_name middle_name', NULL, 'Student Name', 1);

WITH submission AS (
  SELECT id 
  FROM submission_list_column 
  WHERE predicate = 'last_name, first_name middle_name'
)
INSERT INTO submission_list_column_value_path (submission_list_column_id, value_path, value_path_order)
SELECT id, 'fieldValues', 0 
FROM submission
UNION ALL
SELECT id, 'value', 1
FROM submission;
jsavell commented 1 month ago

My review is code only.