Open notes database in formula language
Hi,
How to open a notes database(e.g names.nsf) and browse through records in Formula Language?
Software/Hardware used:
Software/Hardware used:
ASKED:
May 30, 2008 4:52 AM
UPDATED:
June 2, 2008 5:41 AM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
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?