Extend GrantHub search query syntax to support discovery of all supported grants
Context
Bookshelf has a new NIH project that requires providing NIH funding information. When testing searching for these grants in the BCMS we ran into problems because the current search expects an exact match but in some cases a grant can have several matches if it is also a portion of another grant.
Proposal
Extend the GrantHub search integration that:
- IF not search is found as an EXACT MATCH, THEN
- Run a secondary search to search for a partial number by changing search from “=” to “LIKE” and add a wildcard
See example:
We need to retrieve this grant that exists in GrantHub: "DK124395"
Existing GrantHub search does not work currently.
This query will retrieve the grant:
Design
Acceptance criteria
-
System Admin, Org Admin, Editor can retrieve any award number by a partial award number -
UI will display all partial numbers if more than one is retrieved for user to pick which one is accurate -
System Admin, Org Admin, Editor can find and select this real grant number in GrantHub - DK124395
Definition of ready
-
BCMS User Story / Context has been well defined -
The priority of the user story is specified and agreed -
Digital assets added (design, database scheme, mockups etc if relevant) -
Coko Technical Proposal approved by NCBI -
Testable Acceptance Criteria approved by NCBI -
Estimate of effort to complete (time or points) -
The issue has been broken down into development tasks (if necessary) -
Requirements Clarified -
The product owner and development team agree that the user story is ready for development -
NCBI adds “Dev_Ready”
Definition of done
-
All coding tasks are finished and implemented -
QA approved -
Deployed and tested on “ncbidev” (by Coko team) -
Deployed and tested on “ncbi” (by NCBI team) -
Acceptance Criteria Met
Implementation
Alternative approaches (if applicable)
Scheduling
-
Milestone is linked -
Iteration is linked -
Dependencies: ("None" or list issue numbers if relevant) -
Development estimate is added to issue time tracking