View Forum Topic

Forums
CS520
hw 6 order by

Author	Message
pateln04 Posts: 22	Posted 14:25 Nov 17, 2012 \| not sure what the order by for fts is "The search results should be ordered by their relevancy scores with the most relevant result first"
cysun Posts: 2935	Posted 14:41 Nov 17, 2012 \| It's the relevancy score, which can be calculated using ts_rank().
ummata Posts: 68	Posted 17:09 Nov 20, 2012 \| Do we need to set different weights to project name and description?
cysun Posts: 2935	Posted 17:11 Nov 20, 2012 \| ummata wrote: Do we need to set different weights to project name and description? It's not required, but obviously you should do it anyway for better results.
ummata Posts: 68	Posted 22:36 Nov 20, 2012 \| What is the query condition for search keyword do we use for this homework? 'AND' or 'OR' for the keywords. I assume we use 'OR' .
cysun Posts: 2935	Posted 22:41 Nov 20, 2012 \| ummata wrote: What is the query condition for search keyword do we use for this homework? 'AND' or 'OR' for the keywords. I assume we use 'OR' . Choose the one you think would give you better results.
ummata Posts: 68	Posted 23:30 Nov 20, 2012 \| I use native sql to query, both asc and desc give me the same result on the web page. But it works correctly when I run query. Anyone run into this problem?
ummata Posts: 68	Posted 02:29 Nov 21, 2012 \| I use native sql to query, both asc and desc give me the same result on the web page. But it works correctly when I run query. Anyone run into this problem? I got a solution but I don't know what causes the problem. I define my SQL in NamedQueries.hbm.xml and every time I edit my script, I have to clean my project to get it works.