Bug 266

Summary: [SearchEngine] Support to search within specified type
Product: MovieXXX Reporter: tomfong521
Component: MovieAnalysisEngineAssignee: salinang3-c
Status: RESOLVED FIXED    
Severity: enhancement    
Priority: Normal    
Version: 1.0   
Hardware: PC   
OS: Windows   
Deadline: 2018-11-17   

Description tomfong521 2018-11-29 13:13:02 HKT 
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
Comment 1 salinang3-c 2018-11-29 23:26:10 HKT 
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