Manage Learn to apply best practices and optimize your operations.

Opening A Required Document Based On The User When Launching A Database

This code opens a document by matching the usrname with the first column value
in a hidden view.

Try the following Code in pOstopen event of the database.

With this method, the view is opened, the appropriate document is placed in
edit mode, and the hidden view is brought to the foreground. The hidden view
is then closed, and the focus returns to the opened document.

I am dblooking in a hidden view "(All)" for the current user name and getting
the Document Unique ID.
Then I am opeining the hiddenview in Background.
Then I am opening the document by the Unique ID
Then I am opening the hidden view in foreground.
Thenn I am closing the hidden view window.

The hidden view has two columns.The first column has usernames sorted and the
second has document Unique ID with formula @Text(@DocumentUniqueID ).
Selection:=@DbLookup("":"NoCache";"":"";"(All)";@Name([Abbreviate];@UserName);2)
;
@Command([OpenView]; "(All)");
@Command( [OpenDocument] ; "0";Selection);
@Command([OpenView]; "(All)");
@Command ([FileCloseWindow])



Surendra Kumar Talluri

Dig Deeper on Domino Resources - Part 5

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchContentManagement

Close