Question

  Asked: May 30 2008   4:52 AM GMT
  Asked by: Jacksaro


Open notes database in formula language


Lotus development, Web development, Formula Language

Hi,
How to open a notes database(e.g names.nsf) and browse through records in Formula Language?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



Although your question is rather vague, you may want to try the following @Command:

@Command( [FileOpenDatabase]; server : database ; viewName ; key ; newinstance ; temporary )

This command will open up the database on the defined server, opening the specified view. If you replace the "key" value with "", no document will be selected and the user can browse as desired. The newinstance value will cause the view to open in a new window if set to "1" (text), the temporary value will block adding the database icon to the user's desktop if set to "1" (text).

You can also use this command to open a specified navigator:

@Command( [FileOpenDatabase]; server : database ; navigator ; solo ; newinstance ; temporary )

This command opens the database in a similar fashion, allowing you to specify the navigator instead of the view alone (the view will be defined by the navigator settings in this case). The solo parameter operates just like the newinstance value in the first example.

I hope that this provides the functionality that you are looking for. Please feel free to redefine your quesstion if this answer is not quite what you had in mind.

Bill
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Lotus Domino and Development.

Looking for relevant Lotus Domino Whitepapers? Visit the SearchDomino.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Jacksaro  |   Jun 2 2008  5:41AM GMT

Thank you, i used the below method and got it

@DbLookup( class : cache ; server : database ; view ; key ; fieldName ; keywords )

From help file, i understand that key is the first sorted column in view. i have given value of first sorted column and got the output.

Is it possible to specify the column name and its value to search the view and get the result.

Say for example, i am searching in names.nsf
i have a view called “User”. In this Full name is the first sorted column
I passed a full name in key filed and got the results.
Instead, i would like to pass UniqueID as input in this search and get corresponding values. Is this possbile?