SQL Search/iFind to find out how many matches are there
I have an SQL text index defined like this
Index TextIndex On (Text) As %iFind.Index.Basic(IGNOREPUNCTUATION = 1, INDEXOPTION = 0, LANGUAGE = "en", LOWER = 1);
If I run a query like this:
SELECT Text FROM Post WHERE %ID %FIND search_index("TextIndex",'ABC')
I get 20 results with posts containing the term
But each post can contain the term
ABC several times.
Is there a way to get a total count of
Is there a way to get a count of
ABC term in each Post?