[US] Search Page with Search Functionality

Alexicazana commented 3 days ago

As a an application user, I want to have access to a search page, so that I can query and search for specific rows from all available tables and column names and get a search result.

MoSCoW	Risk	Story Points
Should	Medium	7

Acceptance Criteria

Search page accessible through nav bar for USER role
User can successfully select the table they want to search (from a list of all available tables in the database)
User can successfully select which column they want to search
User can enter the value of the column they're looking for
User can either see the result of their query displayed, or sees an error message indicating the row was not found

Risks

Being able to fetch and display all tables and columns of those tables in a meaningful way for the user
Allowing application user role to access this page though it sits at the same level as Settings page (which is NOT accessible to user role)
Ensuring query results are correct and complete information for the user (validation required)

Pre-requisites

[x] VMD is appropriately accessible
[x] Roles are well defined for this new page

Tasks

[ ] Create separate search page accessible from NavBar
[ ] Allow app user roles to access this
[ ] Create search functionality
[ ] Create search output
[ ] Ensure UI is consistent
[ ] Add testing to make sure the displayed information from the search results is accurate and complete!

Alexicazana commented 3 days ago

Initial UI mockups for Search Page:

Alexicazana commented 3 days ago

Search handles value in input field appropriately; for column 'tool_description', the rows outputted are all those that contain the value in the input field; no need for exact match since description is lengthy, and user may not know exact description.