New documents not sorting correctly

HCL Domino Domino Forum
1

I have a view sorted on and categorized by two similar computed column values. The first column is hidden and not categorized, the second is visible and categorized. Here are their formulas:first column:

tmp := @If(

UserName = @UserName; 1;

@IsMember(@UserName; (list of names fields)); 2;

@UserName = DAdmin; 3;

4);

tmp;

second column:

tmp := @If(

UserName = @UserName; "My Docs";

@IsMember(@UserName; (same list of field names)); "I'm an Approver";

@UserName = DAdmin; "I'm an Admin";

"Others");

tmp;

When new documents are added to the view, they show (for me) incorrectly under the “My Docs” category.

They sort properly under “Others” after I press [Shift]-[F9] to rebuild the view index.

I don’t want to have to do this every day. Can anyone explain what’s wrong?

Additional info: This view is default frame content for one of the frames in the default frameset. It has a PostOpen event of [ @SetViewInfo([SetViewFilter]; temp ; 0 ;1) ] to undo the effects of prior uses of SetViewFilter if accessed after those other uses.

2

Subject: New documents not sorting correctly

Read the Designer Help topic on @UserName, I’m not going to post it here.

3

Subject: New documents not sorting correctly

You cannot add references to @username or any other dynamic keyword in a view formula or column formula, because your index is maintened for all the users.

You will have to change your view design to either a private on first use view or a single category embedded view on a page.

Good luck!

Nicolas Abesdris

Quintessence e-solutions Inc.

4

Subject: RE: New documents not sorting correctly

If you want to use @Username in a column formula, then in order to display correctly, the view should be “Shared Private on First Use”. If it is a shared view, then using @Username should only be in the view selection formula. But should not be in the formula of the view columns