[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


DBLOOK UP Lotus Notes Designer

Posted on 2004-11-05
Medium Priority
Last Modified: 2013-12-18
have a view using DbLookUp to find a field, however, the field is not categorizing. I looked at another posting which stated that DbLookUp fields cannot be categorized unless they are in the far most left column. I changed my view, so that the DbLookUp field is in that column. The field is still not categorizing. Any thoughts?
Question by:christie_holtz
LVL 19

Expert Comment

ID: 12506960
I am not sure if I understand your problem fully. I am offering some generic help. Perhaps that will help.

To use DBLookup on a view the view should meet these conditions:

(1) The View must be sorted on the first column (left most). Categorized or not, does not matter.
(2) The first column must contain values based on formula to be looked up. It can be a single field value or a composite made out of many fields put together.
(3) The view must contain the column that contains the return value.

Now compare this with your scenario. Do you see any gaps?

Author Comment

ID: 12507061
I have a view called 'External Summary'.  On that view, I have the following fields, Reviewer, Quarter, PC,and Name.  I am using a DBLookUp for Reviewer.  The DBLookUp code is @DbLookup("";"";"intlookup";qtrid;int_onc).  I am tryin to get int_onc from another view called 'Internal Summary', the field there is called int_onc, but labeled Reviewer. This field is the first column in the view and is sorted.  
Does this help?
LVL 14

Expert Comment

ID: 12507343
Are you trying to use Dblookup in view column formula, If yes then it will not work. From your dblookup, this is what i infer

Intlookup - is the view name
qtrid - key
int_onc - value to be fetched

qtrid i am not sure what you have in that


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.


Author Comment

ID: 12507380
Yes, I have my DBLookUp in the column's formula section.  Since that won't work, what would you suggest I do?
LVL 14

Accepted Solution

p_partha earned 2000 total points
ID: 12507397
Create a field in the current document which will evaluate to this dblookup: something in this line:

Create a agent and put this code and run on all the documents

I am assuming that int_onc and qtrid are there in that document

field newdblookupfieldname:=@DbLookup("";"";"intlookup";qtrid;int_onc);  


Author Comment

ID: 12507530
I am totally new to LN....I think this might be out of my league.....when I copy that code and put it into an agent....when I go back to it the code as a SELECT statement in there....what does that mean?
LVL 46

Expert Comment

by:Sjef Bosman
ID: 12508157
Could you please explain what you want to accomplish, in logical terms, or in terms of output? E.g. "I want to show X, Y, and Z on one line, where X and Y come from one document and Z comes from the other".

As you may have found out the hard way (which is unfortunately the best way), Notes is by no means a relational database. If you explain your view in some relational SQL-select statement, we can see if it is easy to do. You have to accept that, in Notes, data sometimes must be duplicated to other documents (records) in order to ascertain relationships, and that you have to maintain these relationships yourself.

LVL 14

Expert Comment

ID: 12508263
Notes add select @all after any statement, Forget that and run on selected documents,


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses
Course of the Month19 days, 17 hours left to enroll

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question