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

Fix null value in committee name in ofec_sched_e_mv #5247

Closed
3 tasks done
hcaofec opened this issue Oct 3, 2022 · 0 comments · Fixed by #5248
Closed
3 tasks done

Fix null value in committee name in ofec_sched_e_mv #5247

hcaofec opened this issue Oct 3, 2022 · 0 comments · Fixed by #5248
Assignees
Milestone

Comments

@hcaofec
Copy link
Contributor

hcaofec commented Oct 3, 2022

What we’re after

Null value in committee name column in ofec_sched_e_mv will return incorrect results when searching schedule E by committee ID/name text.

Because the committee name column is always null in SE base table, cmte_name has to be pulled from other table.

Related ticket(s)

Action item(s)

(These are the smaller tasks that should happen in order to complete this work)

  • Add coalesce function
  • Pull committee name from other table

Completion criteria

  • Add migration file
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant