Sorting on client vs server is different

HCL Domino Domino Forum
1

Hi, here’s the issue I’m having:

This behavior happens to everyone who uses the database, not just me. There is a certain view in the database that sorts just fine normally. However, if a user clicks on a column heading to sort by that column, the sorting on the server copy is in a different order than on a local copy sorted by the same column. Any idea what could be causing this behavior?

Thanks!

Ben

2

Subject: RE: Sorting on client vs server is different

Is this colum a Date ? Might it be a text-based-date, and the server and client have different display options?

A screen-shot, or more information /example about what’s being sorted wrong, would be helpfull.

3

Subject: RE: Sorting on client vs server is different

Graham, looks like you answered the same question about 8 years ago. May be the same thing here.http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/216877587871519e8525691c0051e315?OpenDocument

4

Subject: Sorting on client vs server is different

Replication doesn’t happen at this level of granularity. It genereally happens at Document level. In recent versions there is provision to replicate read/unread marks.

The design document corresponding to the view doesn’t change when an end user sorts different columns.

By the way, why is the user accessing multiple replicas of same database?

Regards

Litty Joseph

5

Subject: RE: Sorting on client vs server is different

Well, we are presenting on a screen using the server copy, and other people are looking on their local copies, and things are not synching up.

This is not a date column (it’s text), and I’m not doing any lookups, just trying to figure out why clients vs servers sort differently.

Is there a way to attach screenshots to these reports?

Thanks,

6

Subject: Sorting on client vs server is different

Are you referring to differences between a local copy of the database and a server-based copy? My first question would be how have you verified that the sorting is different.

SWAG: I would guess that there may be an issue with what language/character set your server is using vs what your clients are using.

Also, this is probably not what you are saying, but I would caution about ever doing lookups against any view that a user sees – especially if there are sortable columns – especially if it is a local database.