Hello team, I would like to consult about the following situation and how to resolve it: I have three fields:

name

and

intro

(both are text fields) and I want to sort the results by

message count

. I want to perform a search that matches the

name

field and sort those results by

message count

. Then, I want to perform a search that matches the

intro

field and sort those results by

message count

, placing the matches from the

intro

field after those from the

name

field. What would be a good solution for this?What data needs to be cleared?