usdigitalresponse / usdr-gost

USDR-hosted grants management tools
http://grants.usdigitalresponse.org
Apache License 2.0
26 stars 20 forks source link

[Forecasted Pipeline] Prevent forecasted grants being displayed #3213

Open jeffsmohan opened 1 week ago

jeffsmohan commented 1 week ago

Why is this issue important?

We want forecasted grants available in our dataset (alongside active grants) so we can integrate them into the product for our users.

Current State

The Grant Finder product shows items from the grants table across the site, but the site is not set up yet to properly show forecasted grants.

Expected State

We want the Grant Finder product to filter out forecasted grants for now (until we've developed the UI to display them properly), so that they won't show up improperly when forecasted grant data starts flowing into the grants table.

Implementation Plan

Blocked on #3212

We want to update all queries that involve the grants table to filter out anything where the new is_forecasted flag is true. Specifically, the grants table queries in the following packages/server/src/db/index.js methods:

jeffsmohan commented 1 week ago

@TylerHendrickson I'd love a quick review of the implementation plan before moving this to ready, thanks!