Question

How can I embed the number of results for a search as a column of a table? In my case I am making a code repository and I want to have the following columns:

Algorithm| Number of Submissions

Algorithm is a field on my form that will appear multiple times. Number of Submissions is not stored anywhere - (should be based on number of search results). Any ideas? Thanks in advance.

Environment

-- OmarMussa - 10 Aug 2005

Answer

If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list below the edit box.

Here is an example of a SEARCH that has an embedded %CALC{$ROW(-1)}% to show a linear numbering of the search hits. The CALC's % sign needs to be escaped with $percnt so that it executes once for each search hit. Look at the raw text to see how.

-- PeterThoeny - 13 Aug 2005

I just realize that I misunderstood your question. To get the number of hits and show it in a table cell, you can do a FormattedSearch that increments a spreadsheet variable for each hit. Again, the CALC needs to be escaped.

Example: Search all topics in this web for "Algorithm"

If you want to go fancy: You could do a nested search to dynamically build a table of terms with totals. FormattedSearch has the details.

-- PeterThoeny - 13 Aug 2005