I have a view selection formula SELECT @If( @Date(@Now) = @Date(@Created); @All; @False) and I want it to select all documents from the past 7 days rather than just today's. Thanks in advance for any help. ...
EDIT: Just realised that the reason for the additional results is down to another line in the query! Don't think I have enough rep to close this question. I'm editing some existing SQL code which is searching a Lotus Notes DB. I have this line: @Contains(Title; "blah blah 1.5") and I want to return only those records which contain e...
I found this code that goes through and prints out csv for both columns. I later parse and count the two columns. I want to count it here instead of printing and counting later. I've been mucking around but couldn't figure it out. Dim entry As NotesViewEntry Dim vc As NotesViewEntryCollection Dim rowstring As String Dim session As Ne...
Hi, I'm trying to use the current day in GetAllEntriesByKey by passing an array. The array so far looks like this Dim keyarray(2) As Variant keyarray(0) = "FF Thompson ADT" Set keyarray(1) = dateTime I would like to say this Set vc = view.GetAllEntriesByKey(keyarray, False) Here is a row of what it looks like when it work...
Is it possible to update an entry in Lotus Notes via email just like posterous? If it is possible, how can i do that? Thanks. ...
I am using the Lotus Notes 6.5.1 java API to read an .nsf file. Every document in the .nsf file has multiple document history. While traversing through the documents in the .nsf file using the LN java api I am getting all the document versions as separate documents. How do I ensure only the latest version of each document is retrieved by...
I want to return a List from a Function in LotusScript. eg. Function myfunc() List As Variant Dim mylist List As Variant mylist("one") = 1 mylist("two") = "2" myfunc = mylist End Function Dim mylist List As Variant mylist = myfunc() Is this possible? If so, what is the correct syntax? ...
When a document is associated with another document (e.g. as address connected to a customer), how does notes stores the information? Does it create a new document to represent the association or does it tags the linked document as a response document? ...
I am migrating a Lotus Notes database to SQL Server using the LN java API. While traversing through each LN field in the documents I find all tabular info have field names like fld, fld_1, fld_2 etc where fld represents the name of a column and the numbering scheme is to take care of each individual row. Is there an simple way of extract...
Hi there I'm not a developer and so am unaware of best practices. I created this to bypass manual data copying of log data. This agent is for a single feed which I'll copy and adjust for each additional one. For the specified feed it reads the log for the last time processed and number of files processed so far today and for yesterday...
Are there ways to get around the upper database size limit on Notes databases? We are compacting a database that is still approaching 60 gigs in size. Thank you very much if you can offer a suggestion. ...
I was just doing some yicky code and I thought, instead of using three dynamic arrays, as such: dim x() as string, y() as string, z() as string It will be nicer to have a 3 dimensional dynamic array. But; the help and my fumbling experiments has not revealed the method of defining them. This does not work: dim x()() or dim(,2) or d...
First, some background: Our product needs to integrate with the Lotus Notes client by adding or updating a line in the NOTES.INI file. We don't have a problem if we're dealing with a single-user installation of Notes (i.e. if there are multiple Windows users on the machine, they'll all use the same Notes configuration). In this case, t...
I am using a Java based Portal Platform. I need to show within my portal information stored in Lotus Notes. Considering security issues, what are the recommended ways to do this? Are there any open source JSR 168 portlets out there that integrate with Lotus Notes? From my portal platform, I can call web services to get this informati...
What is the maximum number of characters for a Lotus Notes text field? In Lotus Notes clients, I am encountering a 32K error. ...
I currantly have a simple agent running for forwarding email to an alternative email address, unfortuately the formula's i have tried for also keeping the subject have failed. the subject come in as the server it was sent from. last code tried "[" + @Implode( SendTo; ";")+ "] " + Subject ...
I am trying to make a view which selects all unread mails which also belong to a specific list of folders and subfolders. I created a view by coying the existing "view unread" one, but despite my research in the documentation and in google I am at a loss as to how to restrict the content of the view to documents in a list of folders. ...
Hello, The company I am working is looking for a way to automate functional tests on Lotus Notes 8.5. We have tried different tools including Testcomplete 6 and Rational Robot 7. But we have found issues recognizing objects and implement verifications. Has anyone try to automate this type of tests? Which tools(approach) you recommend...
A Lotus Notes installation, Domino 7x, which ends up trying to start a IBM SameTime 7.5.1 chat client, fails on some machines. Specifically, it fails on Windows XP machines that has SP3 slipstreamed, whereas Windows XP machines which has had SP3 installed afterwards, works fine. The problem can be worked around temporarily by adjusting...