CODEWITHSUNDEEP
viewfieldlotus-notes
Florin M.
Florin M.

Reputation: 2169

Lotus Notes: A view of that name cannot be found in the specified database

There is a computed hidden number field called flag, which has its default value:

 _view := "vwAll";

code := @Unique ( @DbColumn( "" : "NoCache" ; @DbName ;"vwSetupCode" ; 1 )  ); 

x :=@Sort(@Unique ( @DbColumn( "" : "NoCache" ;  code; _view; 1 ) );[Ascending]);

@If(txt_1=""|txt_2="";5;
@If(@IsNotMember(@UpperCase(txt_1);x);1;
@If(@IsNotMember(@UpperCase(txt_2);x);0;
2)))

The _view is from another DB which has its code in the vwSetupCode.

It works fine for some users, but for couple of them I get the error:

Field "flag': `A view of that name cannot be found in the specified database`.

There is a issue at the ACL? PLease help.

I appreciate your time.

Upvotes: 0

Views: 1325

Answers (2)

Phil Donaldson
Phil Donaldson

Reputation: 101

code := @Unique ( @DbColumn( "" : "NoCache" ; @DbName ;"vwSetupCode" ; 1 ) );

Or if the returned value code is multi-valued. IE the first @DBColumn returned unique multi-values ... good luck

Upvotes: 1

Knut Herrmann
Knut Herrmann

Reputation: 30960

Sounds like the view is protected and not accessible to all users.

Open view in designer and check last tab of view properties. There you can find a list of "Who may use this view". Probably check-box "All readers or above" is not set and some of your users are not in groups listed there.

Upvotes: 2

Related Questions