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

Question

Question

How do the various Laserfiche applications sort entries by date columns?

Laserfiche Web Client Workflow
Updated June 17, 2022
asked on June 17, 2022

Do the Workflow activities and Client applications sort entries for date columns based on 'Date MM:HH' or 'Date MM:HH:SS'?

In the clients for Last Modified and Creation Date it only shows HH:MM, but in the database it has HH:MM:SS, so I'm wondering if the applications take that into account when sorting. I also noticed SSS is in there, but they are all 000.

0 0

Answer

SELECTED ANSWER
replied on June 17, 2022

Date values are stored as date types in the database. They are only represented as a string in the user interfaces, following the configured locale settings. So they are sorted ascending or descending based on the normal sequence of time, which often will not correspond to lexical sorting in the string representation.

1 0
replied on June 17, 2022

If I have two entries with that have the exact same last modified date value, down to the second, what does it sort by next?

0 0
replied on June 17, 2022

For any sort column, if there is equality in the values then the row order is not specified - it comes out in whichever order SQL server decides. Listings do support secondary (and tertiary, etc) sort columns though, so you can specify which column is used in the case of ties.

1 0
replied on June 17, 2022

I should say that this applies to all listings in Laserfiche. I am not familiar enough with Workflow to say how or if it exposes this functionality.

0 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...