Unique Case of @ThisValue

I came across this little bug yesterday that I want to share.  A client of mine has a traditional Notes application that has some fields populated from an Oracle database via Lotus Enterprise Integrator (LEI).  There is a Connection document in LEI that includes among the fields mapped to the Notes app, two computed fields that are not actually updated by any data from Oracle.  Those fields in Notes had a formula of ‘@ThisValue’.

What we noticed was that these two fields, after being populated by other formulas within Notes (by some code that ran from an XPage in fact), when LEI would update the document the fields would be left blank.  After some research on the Notes side, in the browser, and in LEI, I managed to narrow it down to a guess that perhaps the @ThisValue was the problem.  So I changed the formula to use the old approach of having just the field name as the value.  Sure enough, that fixed it.

So just a quick word of warning to anyone still using LEI.  This approach might save you some grief.


I am an IT professional with over 20 years of experience. For much of that time I have worked with IBM Lotus Notes and Domino, helping organizations take full advantage of the tool for building workflow collaboration solutions. I have ITIL certification and a background in project management as well. Recently I have invested in how mobile devices may be used to extend business applications outside the office, and have also been learning how to add social components to traditional business applications. Away from work, I have three daughters and recently celebrated my 20th wedding anniversary with my wife in Hawaii. I coach hockey, cycle, and love growing garlic and then finding new ways to use it. I added a section of herbs to my garden last year and was very happy with the result. I ride my bike each year with my wife in the Ride to Conquer Cancer to raise money for research in childhood cancers, particularly brain tumours. Our youngest daughter lost her battle with a brain tumour in 2008 and through this ride we hope to help find a way to prevent other families from experiencing what we went through and continue to live with. If I have any spare time, I like to travel, so you may see the odd photo from our family adventures here too.

Posted in Uncategorized
One comment on “Unique Case of @ThisValue
  1. Joe Brender says:

    I’ve been working with that problem for a couple years. I mentioned it in an unrelated conversation to LEI support, and they were interested in hearing more about it. I’ve had that identical issue, where @ThisValue did not populate the fields, but manually assigning the field value as the field name did work. Frustrating when working with many hundreds of fields.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: