How to retrieve the Full Text Search metadata during search?

[aramallo]

Hi All,

I am struggling to get the result I need from Full Text Search (FTS).

Using the docs example that demonstrates how to get the 10 tops scores for a query on the v column of table.

?[s, k, v] := ~table:index_name {k, v |
    query: $q,
    k: 10,
    filter: 1 + 1 == 2,
    score_kind: 'tf_idf',
    bind_score: s
}

:order -s

That works fine, but in my use case I need to get the index metadata for those matches, that is I need the query to return also the values for the index columns word, offset_from and offset_to, position.

The idea is to show the user the text surrounding every match extracting the position of the match in the text and adding X chars before and after.

Any ideas?

[aramallo]

Having thought about this a little bit more, what I think the FTS index should return is not only {s, k, v} in the above example but the set of all matches found i.e. {s, k, v, word, offset_from, offset_to, position}.