如何取得视图中文档的个数?

[hrbzzh]

在代理中实现,lotusscript,能根据给定的select 公式来对某个视图中的数据进行检索,并返回文档数

目的:在网站主页上显示某个模块的数据库中需要当前用户办理的文件数目

谢谢!

[jeremyruan]

Dim session As New notessession
Dim db,cdb As notesdatabase
Dim collection As NotesDocumentCollection
Set db=session.getdatabase(服务器名,数据库名")
query =搜索条件
Set collection =db.search(query,dt,0)
count=collection.count

[chenyg2000]

lotus script :
Dim session As New NotesSession
Dim db As NotesDatabase
Dim view As NotesView
Dim vc As NotesViewEntryCollection

Set db = session.CurrentDatabase
Set view = db.GetView("By Category")
vc = view.AllEntries
Messagebox vc.Count

[chenyg2000]

formula:
@Elements(@DbColumn( "": "NoCache" ; @DbName ; viewname ; 1 ))

[Layto]

chenyg2000(icerain)说的@Elements(@DbColumn( "": "NoCache" ; @DbName ; viewname ; 1 ))

不好，当数据超过64K，就报错

[Layto]

用代理好

[gjd111686]

整个主页用servlet输出就好控制了.