Question

Sort file list by numeric value

Web Client Laserfiche

Updated October 16, 2017

asked on October 13, 2017

We have a bunch of folders that have numeric names e.g. 33, 1006, 428

When we open the folder with these the typical alphanumeric sort gets the order wrong in this case 1006, 33, 428

Is there a way to configure the column to try to use a numeric sort?

Or a way to define a "view"? Other options? (I am aware of the leading zeros trick.)

If the user has the folder open with with several thousand of these is there a quick way to find a folder by name ala the File explorer search?

If you right click the column headers there is a Sort Columns menu but the controls that show the sort don't seem to be useful for anything. It would be nice if the Sort Columns dialog had an option to sort by numeric. I guess there is the issue that while we ask for numeric there could be "bad data" in the column which is not numeric.

Note that Windows File Explorer gets the sort order "correct."

Web Client 10.2 (which I assume is Web Access topic)

0 0

Replies

replied on October 13, 2017

Text fields always sort alphabetically. You would need to either format your numbers so that they sort the way you want (by zero-padding to 0033, 1006, 0428) or by extracting the number part into a numeric field and sorting on that. See also this question.

0 0

replied on October 16, 2017

RE: or by extracting the number part into a numeric field and sorting on that

Remember these are folder names displayed by the Web Client - not a data table. I would guess the extraction trick would not apply.

Obviously File Explore uses something other than a simple alpha sort.

0 0

You are not allowed to follow up in this post.

Question

Question

Sort file list by numeric value

Replies

Sign in to reply to this post.