Write a test for this query: Number of COVID trials assigned to JHU.

[dcarsey]

1) Attempt to run this query manually. 2) Identify information we need or functionalities the dashboard needs in order to get the answer. 3) Accomplish these items as needed. ^^^ (make new ticket if need be) 4) Run the query and see if CTMD and TIN match. 5) Make adjustments as necessary. 6) Give the steps for execution to Ryan so that it can be added to the testing.

[dcarsey]

In order to close this ticket:

• [ ] Write SQL to answer queries, identify missing fields [Data Modeler]
• [ ] Write script to answer queries with CTMD, identify missing proposal_table fields, and if join is needed, missing tools[Data Modeler]
• [ ] Add missing fields to dashboard proposal table [Developer]
• [ ] Review/compare answers with expected [PM/Data Modeller/Vandy/Duke]
• [ ] Write tickets for any new Features/Tools requested from above [PM]
• [ ] Add SQL and dashboard tests to automated tests, update expected output of existing tests with cut-off submission date as current date [Developer]

[dcarsey]

A new COVID field was added to CTMD to satisfy this query. We tested with TIN and CTMD on 9-1-2020, and they are in synch on this query. Final step: Add SQL and dashboard tests to automated tests, update expected output of existing tests with cut-off submission date as current date

[dcarsey]

Go to PROPOSALS tab

Make sure at least these tickboxes are clicked:

• ID
• PROPOSAL NAME
• PROPOSAL STATUS
• ASSIGNED TIC/RIC
• COVID STUDY

Drag the COVID STUDY column to the upper left / grouped by feature. Select the COVID STUDY : YES group by clicking on the left caret to expose the proposals. Sort ASSIGNED TIC/RIC column Scroll down and count the number assigned to JHU/TUFTS TIC

confirm w/ Shruti