Hi, in my web application, there is html Query View together with $$ViewTemplate. All works fine and quick. But i need to get information about how many documents is returned by SQL query in the view and process that information in the $$ViewTemplate form to make e.g. easy site navigation.
In *.nsf version, there I used this with @elements(@dbcolumn(…)) and computed field … but with sql and QueryView, it doesn’t work. 
Any idea?
Subject: Hits
On a $$Searchtemplate you can create a numeric field called hits that will tell you the # of docs returned.
Subject: Not useful for me
Yes, that’s true. But it doesn’t solve my problem. I use QueryView together with $$WiewTemplate, there is no hits field like in fulltext $$SearchTemplate form
Subject: You could do a count in the sql query and pass it to a column
But unlike notes there are a few limits, the default lines per view (normally 30), the Query View row limit: (normally 500) and the Maximum lines per view page:
These will limit the size returned.
If the view is left as a normal Notes view, then you can use javascript to count the rows in the html table.