You are viewing limited content. For full access, please sign in.

Question

Question

Dates are not sorting correctly in Laserfiche

asked on September 13, 2018

Hello,

We have a client that is noticing an issue where the documents are not sorting like it used to. This is happening to all users and nothing seems to have changed.

It used to file:
1/5/2018
1/15/2018
1/30/2018

Now it files it as:
1/15/2018
1/15/2018
1/5/2018

See screenshot, which highlights the dates that are out of order.

Laserfiche Client version: 10.2

Out of Order1.png
Out of Order1.png (155.48 KB)
0 0

Replies

replied on September 13, 2018 Show version history

Can you give some context here?  It looks like search results, and the results are sorted by name.  It's not specified how results will be ordered within those groups.  You can sort by one of those columns, but of course then they won't first be sorted by name.

It is possible that even though it's not specified that they used to come back in an order that happened to match one of the date column's ordering.  Depending on the kind of search the order may be determined by the way they are returned from the underlying database, which can in turn be influenced by things like the types of indexes you have or the way those indexes are used, which in turn can depend on the size of the tables involved.  So even just the natural growth of your repository can change the observed behavior.

The Web Client allows you to specify multiple sort columns, so you could sort first by name and then secondarily by another column.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.