"show multiple values as separate entries" bug

[1uptheman]

It seems I found a Notes bug with the "show multiple values as separate entires" in the View properties. If you have a view where each column has the value of a multi-value field

ie. a document with

FIELD customer := "customer A" : "customer B";
FIELD location := "NY" : "CA";

that displays as

Customer | Location
______________________

customer A | NY
customer B | CA


once I sort one of the columns ascending or descending, I only see customer A's information. Has anyone else experienced this problem? Is this a known Notes bug?

 

[pmonett]

Lotus will tell you that it is not a bug. When you use a column sort, Notes breaks a lot of view functionality, especially with Categories and multi-value sorting.
If you need to retain sort by customer with multi-value fields, I would urge you to design another view that shows the data the way you feel it should be with a column sort, then redirect the initial view's column sort to that view.

Pascal.

 

[1uptheman]

then redirect the initial view's column sort to that view"

How can I do this? I wasn't aware that we can perform an action on column sort

 

[pmonett]

When you choose Click on Column Header in the Properties Sort tab of the column, you get a drop-down box. The last choice in that list is a redirect. Choose that and you get to choose the view that the option should direct to.

Hint : the view needs to exist before redirecting to it !

Pascal.