Hi there
I’m trying to add a ranking to my advanced intersect statement but I have no clue how to do it.
Usecase:
I compare the list values of two fields of each user in the user table. It works fine.
But the question is, how can I rank the search results (users) by the number of matches?
For instance:
CURRENT USER:
dictCanonDiagnoses: ValD1, ValD2, ValD3
dictCanonMedications: ValM1, ValM2, ValM3
USER A:
dictCanonDiagnoses: ValD3
dictCanonMedications: ValM1
USER B:
dictCanonDiagnoses: ValD2, ValD3
dictCanonMedications: ValM1, ValM2
USER B should be at the top of the list.
Thank you for your help!
Here is my statement:
