Detail: In v1 the search is a swap among all columns in the database, which could return inaccurate results. For example when user inputs "1984" aiming to get a recommendation of films released in the year 1984, the film NAMED "1984" will be included in the list. Expected behaviour: - Searching can be processed in given type
How to enhance: - Added to adopt prefix for search parameter - Perform searching in the specific column with respect to the prefix Potential affected areas - Recommendation Affected versions - >= v2 Testing steps 1. Edit a test database with four movies in it. Enter movie info to satisfy following (e.g. given search parameter "-Y 1984"): MovieA: movie_title="1984" title_year="2018" budget="379000" MovieB: movie_title="Hello world" title_year="2016" budget="19849000" MovieB: movie_title="CS3343" title_year="1984" budget="379000" 2. Enter "2" to select "Film Recommendation" in [System Home] 3. Enter "1" to select "Start New Recommendation" in [Office Box Prediction] 4. Enter keyword ("-Y 1984") to process recommendation Expected results - Printed output: MovieB - Searching should be performed only in "title_year" column, hence only MovieB should match the keyword and be printed Testing results - Printed output: MovieB