Hello all,
is it possible to display total number of documents in a view name… like
ViewName (number of docs)
Thanks in advance
Jasna
Subject: sum
put a column in the view, add the value “1”, use @Sum to summarize this column in a page that displays the view
Subject: RE: sum
Could you please explain this in a little more detail or point me to an example? Thanks.
Subject: RE: sum
If you have the column in a view with the value of “1”. Then you can summarize this in a form or page with @Sum(@TextToNumber(@DbColumn(“”:“”;“”:“”;“viewname”;columnnubber)))
Subject: RE: sum
This is unnecessarily complex. First, it’s silly to have a column display a text value, then convert that value to a number to do match on it. Put a number in the column to begin with. Second, @Elements can be used on any column, so it’s not even necessary to have a special column to sum.
Of course, using @DbColumn to read data from every row in the view is likely to be slow. If this is a web application, consider using a WebQueryOpen event on the view template form instead.