Using @Elements

HCL Domino Domino Forum
1

Hi all,

I have created a View and then counting the no of documents inside the view using @Elements. The formula is:

temp :=@Elements(@DbColumn(“Notes”;@DbName;“Name of View”;1));

temp+1;

After that, i will increase the no of documents by 1. I want to do so because i want to keep track the no of documents in the view.

But after that, sometimes i create a document and the no of document WILL NOT increase by one, and sometimes will. This is strange. Hope someone can help me.

Thanks

2

Subject: Using @Elements

I think it’s a cache problem

from the @DBLookup help:

“NoCache” gets the results of the lookup from the database; no cache is used. If you want to ensure that Domino retrieves the latest information for every lookup, specify this option.

so try

temp :=@Elements(@DbColumn(“”:“NoCache”;@DbName;“Name of View”;1)); temp+1

3

Subject: RE: Using @Elements

Thanks, problem solved.