@command([fileopendatabase]) does not get the exact document

HCL Domino Domino Forum
1

hello all:LI am using this formula to open a certain document from another database

@Command([FileOpenDatabase];(@Command( [FileOpenDBRepID];

“86256A31:00556DFB”)):“Purchase.nsf”;“NonInvHdrCompletedforPO”;“RequestingSource”);@Command([OpenDocument])

my fields are ok but I get the wrong document all the time I think it has something to do with the view although it is sorted by RequestingSource

any ideas

thanx

Dalia

2

Subject: @command([fileopendatabase]) does not get the exact document

Two possible reasons :1. @Command([FileOpenDatabase] and (@Command( [FileOpenDBRepID] do basically the same thing, the only difference is one takes a file name and the other a replica ID. Why are you doing the OpenDatabase first, without any parameters?

  1. Your FileOpenDBRepID is asking to find the first document in the designated view “NonInvHdrCompletedforPO” that has the literal “RequestingSource” in the first sorted column. Maybe you mean RequestingSource (without quote marks, being the name of a field)

HTH