I would like to be able to scale the existing ranking (or adjust record order) depending on the category, for example. E.g. to allow a user to declare that they prefer a certain type of information and have hits for other types pushed down the list.
So:
1. am I correct in assuming that the ranking is a black box except for the various knobs to do with proximity, lead etc
2. does the rank get calculated before ORDER BY and IF there is an ORDER BY, this will re-order the previously-rank-ordered dataset.
3. would it be possible to ORDER BY a calculated value such as (rank+category_weighting*200)?
Cheers
So:
1. am I correct in assuming that the ranking is a black box except for the various knobs to do with proximity, lead etc
2. does the rank get calculated before ORDER BY and IF there is an ORDER BY, this will re-order the previously-rank-ordered dataset.
3. would it be possible to ORDER BY a calculated value such as (rank+category_weighting*200)?
Cheers