Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Merged
merged 4 commits into from
Jul 17, 2024

Conversation

wwelling
Copy link

@wwelling wwelling commented Jul 15, 2024

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;

@wwelling wwelling requested a review from qtamu July 15, 2024 18:37
@wwelling wwelling linked an issue Jul 15, 2024 that may be closed by this pull request
@wwelling wwelling requested review from jsavell and kaladay July 16, 2024 14:34
@jsavell
Copy link
Member

jsavell commented Jul 17, 2024

My review is code only.

@wwelling wwelling merged commit c55858f into sprint2-staging Jul 17, 2024
0 of 2 checks passed
@wwelling wwelling removed the request for review from kaladay July 19, 2024 12:34
@wwelling wwelling changed the title Submission list combined predicate column sort [Issue 51]: Submission list combined predicate column sort Jul 31, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Display First and Last Name in single column
3 participants