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 committee_name in ts_vector column used by q_filer #5416

Closed
2 tasks
hcaofec opened this issue Apr 19, 2023 · 0 comments · Fixed by #5420, #5422 or #5424
Closed
2 tasks

Fix null committee_name in ts_vector column used by q_filer #5416

hcaofec opened this issue Apr 19, 2023 · 0 comments · Fixed by #5420, #5422 or #5424
Assignees
Milestone

Comments

@hcaofec
Copy link
Contributor

hcaofec commented Apr 19, 2023

What we’re after

When there is null value in committee name, especially for unverified committees, the ts_vector column that includes committee name needs to use coalesce function to handle this scenario.

This is for filings an reports endpoint.

https://www.fec.gov/data/filings/?data_type=processed&q_filer=C00780197

https://api.open.fec.gov/v1/filings/?sort=-receipt_date&sort_hide_null=false&sort_nulls_last=false&per_page=20&page=1&sort_null_only=false&q_filer=C00780197&api_key=DEMO_KEY

Related ticket(s)

CMS ticket #5707
#5160

endpoint list with keyword text filter being added

(Include the tickets that either came before, after, or are happening in tandem with this new ticket)
#5219
#5247
PR #5248

Action item(s)

  • Add coalesce to ofec_filings_all_mv and other reports mv

Completion criteria

  • create migration files
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment