Lotus Domino Document Manager (Domino.Doc) Forum : Multiple Name Display For CreatedBy And CheckOutUserDisplay

This issue happens inf the filecab.ntf template for people that are in multiple groups that are listed in the view "(MappedGroupMembersCache)". In the stock version of Domino.Doc 7.0 there are a few places where a lookup into the view "(MappedGroupMembersCache)" needs to be surrounded by an @Unique like it is done in most places to work correctly. Another issue is created once the MappedDocAuthor Fields have multiple values in them some display fields need the @Unique around them as well. For a permanent fix to this issue do the following:

The permanent resolution of this issue is as follows:

1. Write an agent that Removes Duplicates in the already existing computed fields:
Form AccessTemplate - MappedDocAuthor
Form Document - MappedDocAuthor
Form Binder - MappedDocAuthor
Form ReviewCopy - MappedRvwCurrent, HeaderText
2. Fix Bug #1 - #6 in filecab.ntf

List of bugs to fix below:

#1 AccessTemplateWeb - Field MappedDocAuthor
#2 BinderWeb - Field CreatedBy, CheckOutUserDisplay
#3 DocumentWeb - Field CreatedBy, CheckOutUserDisplay
#4 NewBinderWeb - Field MappedDocAuthor
#5 NewDocumentWeb - Field MappedDocAuthor
#6 ReviewCopy - Field MappedRvwCurrent, HeaderText

-------------------------------------------------------------------

#1 AccessTemplateWeb - Field MappedDocAuthor

MappedDocAuthor - Computed - Value Fromula

Before
temp := @DbLookup("":"NoCache";""; "(MappedGroupMembersCache)"; @UserName; 2);
@If(@IsError(temp);"";temp)

After
temp := @Unique(@DbLookup("":"NoCache";""; "(MappedGroupMembersCache)"; @UserName; 2));
@If(@IsError(temp);"";temp)

-------------------------------------------------------------------

#2 BinderWeb - Field CheckOutUserDisplay

CreatedBy - Computed For Display - Value Fromula

Before
@If(MappedDocAuthor!="";@Name([Abbreviate] ; MappedDocAuthor);@Name([Abbreviate] ; DocAuthor))

After
@If(MappedDocAuthor!="";@Name([Abbreviate] ; @Unique(MappedDocAuthor));@Name([Abbreviate] ; DocAuthor))

---

CheckOutUserDisplay - Computed For Display - Value Fromula

Before
temp := @DbLookup("":"NoCache";""; "(MappedGroupMembersCache)"; CheckOutUser; 2);
@If(@IsError(temp);@Name([Abbreviate] ; CheckOutUser);@Name([Abbreviate] ; temp))

After
temp := @Unique(@DbLookup("":"NoCache";""; "(MappedGroupMembersCache)"; CheckOutUser; 2));
@If(@IsError(temp);@Name([Abbreviate] ; CheckOutUser);@Name([Abbreviate] ; temp))

-------------------------------------------------------------------

#3 DocumentWeb - Field CreatedBy, CheckOutUserDisplay

CreatedBy - Computed For Display - Value Fromula

Before
@If(MappedDocAuthor!="";@Name([Abbreviate] ; MappedDocAuthor);@Name([Abbreviate] ; DocAuthor))

After
@If(MappedDocAuthor!="";@Name([Abbreviate] ; @Unique(MappedDocAuthor));@Name([Abbreviate] ; DocAuthor))

---

CheckOutUserDisplay - Computed For Display - Value Fromula

Before
temp := @DbLookup("":"NoCache";""; "(MappedGroupMembersCache)"; CheckOutUser; 2);
@If(@IsError(temp);@Name([Abbreviate] ; CheckOutUser);@Name([Abbreviate] ; temp))

After
temp := @Unique(@DbLookup("":"NoCache";""; "(MappedGroupMembersCache)"; CheckOutUser; 2));
@If(@IsError(temp);@Name([Abbreviate] ; CheckOutUser);@Name([Abbreviate] ; temp))

-------------------------------------------------------------------

#4 NewBinderWeb - Field MappedDocAuthor

MappedDocAuthor - Computed - Value Fromula

Before
temp := @DbLookup("":"NoCache";""; "(MappedGroupMembersCache)"; @UserName; 2);
@If(@IsError(temp);"";temp)

After
temp := @Unique(@DbLookup("":"NoCache";""; "(MappedGroupMembersCache)"; @UserName; 2));
@If(@IsError(temp);"";temp)

-------------------------------------------------------------------

#5 NewDocumentWeb - Field MappedDocAuthor

MappedDocAuthor - Computed - Value Fromula

Before
temp := @DbLookup("":"NoCache";""; "(MappedGroupMembersCache)"; @UserName; 2);
@If(@IsError(temp);"";temp)

After
temp := @Unique(@DbLookup("":"NoCache";""; "(MappedGroupMembersCache)"; @UserName; 2));
@If(@IsError(temp);"";temp)

-------------------------------------------------------------------

#6 ReviewCopy - Field MappedRvwCurrent, HeaderText

MappedRvwCurrent - Computed - Value Fromula

Before
temp := @DbLookup("":"NoCache";""; "(MappedGroupMembersCache)"; RvwCurrent; 2);
@If(@IsError(temp);@Name([Abbreviate] ; CheckOutUser);@Name([Abbreviate] ; temp))

After
temp := @Unique(@DbLookup("":"NoCache";""; "(MappedGroupMembersCache)"; RvwCurrent; 2));
@If(@IsError(temp);@Name([Abbreviate] ; CheckOutUser);@Name([Abbreviate] ; temp))

---

HeaderText - Computed - Value Fromula

Before
temp := @DbLookup("":"NoCache";""; "(MappedGroupMembersCache)"; @UserName; 2);
@Text(@Now) + " " + @If(@IsError(temp);@Name([Abbreviate] ; @UserName);@Name([Abbreviate];temp))

After
temp := @Unique( @DbLookup("":"NoCache";""; "(MappedGroupMembersCache)"; @UserName; 2));
@Text(@Now) + " " + @If(@IsError(temp);@Name([Abbreviate] ; @UserName);@Name([Abbreviate];temp))

Lotus Domino Document Manager (Domino.Doc) Forum

Resources

Lotus Support

Wikis

Lotus Forums