Lookup using LotusScript

HCL Domino Domino Forum
1

Hi All,

I need to edit an agent so I can retrieve some information from another database (located within notes) using lotusscript.

Firstly I need to parse the Subject Line of document and then I need to use that information to retrieve the relevant information within my agent for use.

Pretty much I have a separate reference db with numeric values that refer to fieldnames I need to set within my agent.

I know how to do this with the function language but can I do it with lotusscript because I’m within an pre-existing agent?

Could someone point me in the right direction?

Thanks in advance for your time!

-Chuck

2

Subject: lookup using LotusScript

I would guess from your question that you have never done any LS coding before. That bing the case I would really suggest that you get an introductory book of LotusScript - search Amazon or Borders there are several around. Explaining how LS Classes etc work is really beyond the scope of this forum.

If this is not the case then perhaps you could post the @Formula Code and we could get you started in the right direction.

3

Subject: RE: lookup using LotusScript

I have done some LS coding. I know my way around LS and can understand it but it’s been a few years since I did any real coding in LS.

The two things I need to do are:

  1. Extract The first 10 characters(this part I have already done)and seperate the numbers from within the bracets in a subject line similar to this:

GDSCHEDLEA (0003;0002;9999)

  1. Use each of those numbers to reference a db and return the information contained in the second column. For example:

0003 = “Policy No.” in RefTable.nsf

I can bumble my way through the code and I can research what I need to do to get the desired result. Unfortunately because of time restraints on this project any kind of starting help would be very appreciated.

Thanks again for your time,

-Chuck

4

Subject: Use a view sorted by RefNo and either getdocumentbykey or getentrybykey

You may also need the split function; as I read it, you will, anyway. Those would be the broad strokes of where to start; your LS experience should pull you through the details.

5

Subject: RE: Use a view sorted by RefNo and either getdocumentbykey or getentrybykey

If you are doing lookups against a view, using a key, LotusScript is terribly slow at doing this,

A neat trick is to take the @DbLookup formula and use the LotusScript Evaluate function. The difficulty (mild) is making a string of the formula, but once you have that sorted, lookups will take a fraction of the time.