How to use raw sort condition

Question

cevin opened this issue a year ago · 2 comments

model::search('keyword')->orderBy('weight()', 'desc')

"sphinxql: syntax error, unexpected $undefined near '`weight()` desc, `id` desc limit 20 OPTION max_matches=1000;'"

Answer 1 · 2023-08-24T20:06:04.000Z

model::search('keyword', fn($builder) => $builder->orderByRaw('weight() DESC'))->get();

Answer 2 · 2023-08-24T20:07:35.000Z

Scout builder does not support sorting by expression