Sorting by rank when matching with combined vector

[tariksetia]

Consider the following example from documentation:

import sqlalchemy as sa
from sqlalchemy_searchable import parse_search_query

search_query = u'matrix'

combined_search_vector = Article.search_vector | Category.search_vector

articles = (
    session.query(Article)
    .join(Category)
    .filter(
        combined_search_vector.match(
            sa.func.tsq_parse(search_query)
        )
    )
)

How do I sort the result by rank?

[tariksetia]

Any help is deeply appreciated.

[tariksetia]

I'm still not able to solve this. @kvesteri, any help is deeply appreciated.

[davidjb99]

Have you tried to weight them?

https://sqlalchemy-searchable.readthedocs.io/en/latest/configuration.html#weighting-search-results

[jpvanhal]

Use the search function with sort=True parameter to sort the results by rank:

import sqlalchemy as sa

from sqlalchemy_searchable import search

combined_search_vector = Article.search_vector | Category.search_vector
articles = session.scalars(
    search(
        sa.select(Article).join(Category),
        search_query="matrix",
        vector=combined_search_vector,
        sort=True,
    )
).all()