My colleague recently had this request to open a document from a different db given its UNID and DB path (using only formula).
Although simple, when you search the web you only see solutions that either use LS or extra view mechanism.
Here is a simpler solution:
msg:=”notes://”+server+”/” + DBReplicaID + “/0/” + docid + “?OpenDocument”;
@URLOpen(msg)
This can be very useful when you need to open the parent document from a link in child document.
I don’t know of any shortcomings of this approach, let me know if you can think of any.
Here is a short formula I wrote a long time ago to simulate the Magic (8) Ball…
I have added this as a separate button on my custom toolbar and play with every now and the
hope you like it..
REM {Formula to throw Magic 8 Ball predictions. EnJoy!};
opt:=”As I see it, yes”:”Ask again later”:”Better not tell you now”:”Cannot predict now”:”Concentrate and ask again”:”Don’t count on it”:”It is certain”:”It is decidedly so”:”Most likely”:”My reply is no”:”My sources say no”:”Outlook good”:”Outlook not so good”:”Reply hazy, try again”:”Signs point to yes”:”Very doubtful”:
“Without a doubt”:”Yes”:”Yes – definitely”:”You may rely on it”;
rand:=@Round((19*@Random ) + 1);
@Prompt([Ok];”Magic 8 Ball says “; opt[rand])
We recently had a situation where there were a lot more documents in the db than visible. This can happen when the document’s Readers field has a particular name/role not assigned to anybody. In our case though the db did not have any Readers controlled form. We had to recover /delete those documents (we later found out that a user had accidentally copied documents from another db(which was readers controlled) and pasted here).
The simplest way to resolve this is to use the Full access administrator feature and read all documents, but, what if you do not have that luxury?
Here is how you recover those docs having just Manager access to the db.
- Create a new view in the db to show all docs (select @all)
- Add a categorized column $Readers as the value. This would add categories for all the readers fields used in the db
- Spot the categories without any documents and note the category name
- If the category is a role, add it as part of the current db’s acl with access to yourself
All documents would magically appear again to be processed /deleted.
This technique can be used to troubleshoot so many other Readers field issues.
Hello, and welcome to my blog! I’m not sure exactly what I’ll be writing about, but having started this blog for more than a year now, I am compelled to finally put some content in it.
I am a developer with expertise in Lotus notes/VBA/C# and interest in so many other platforms. I am mainly looking to write about Notes, and its interaction with other technologies.
Watch this space . . .
Posted in misc
|
Tagged misc
|
