Examine query

I’m having a bit of trouble creating an examine query

My index stores two lists of id (comma separated).

I want to compare these lists with other two lists and get the nodes that have more matches

Example:

search1 = “1,20, 50”
search2 = “5”

Index

node1 { list1 = “55,90”, list2 = “1”}
node2 { list1 = “50,90”, list2 = “1”}
node3 { list1 = “1,20,90”, list2 = “5”}

Desidered result

node3 //3 matches
node2 //1 match

obviously search term “1” shold not match “10”

Do you have any ideas?

Thank you


This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/70826-examine-query