@DBLookup and private views

HCL Domino Domino Forum
1

Quick question… should @DBLookup be working for me with private views?

I have checked the code behind my @DBLookup a thousand times, and I’m sure that it is right. It works fine when I change it to a public view. I have a private view (stored locally) that I want to use, however no matter what value I put in for the key, I always get “Note Item Not Found”. Is this because it is a private view?

Yes, my key value is the value that is listed in the first sorted column of the private view, and yes I am sure that there are no hidden columns or something.

Thanks!

2

Subject: RE: @DBLookup and private views

I haven’t tried it, but I would be surprised if @DbLookup worked with a desktop private view, and the message you’re seeing is about what I would expect as a failure report in that case.

Assuming the private view is selected with @UserName, surely you could create a shared view that has the name as part of the first sorted column, concatenated with whatever else you wanted to search for, and use that view instead.