Natural sort order

[MJH]

Hello,

 

is there a "natural sort" order available with Daminion?

 

At the moment folders and files are sorted like this:

 

1

10

11

12

13

2

3

4

5

6

7

8

9

 

 

I would like a sort order like this:

 

1

2

3

4

5

6

7

8

9

10

11

12

[Murat]

Strings values (like Folders) are sorted differently than numeric values.

 

You will see the same sorting order if you'll open these folders by Windows Explorer.

 

To avoid problem with sorting folders with numeric names, I suggest you to append preceding zeros to each folder name, like:

 

01

02

03

...

11

12

22

33

[MJH]

You will see the same sorting order if you'll open these folders by Windows Explorer.

 

No. Windows (7) ist sorting these folders better. If I open these folders with Windows Explorer, I see the following sorting order:

 

1

2

3

4

5

6

7

8

9

10

11

12

 

 

Windows must have a function to do this. Windows Explorer automatically sorts folders this way.

 

I also use xplorer2 as a file explorer. Normally xplorer2 also sorts folders strictly by numeric values (1, 10, 11, 12, 2, 3, ...). But there is a option to use natural number sort from windows (it requires Windows xp or later). If this is activated, the sorting order of these folders is (1,2,3,...9,10,11,12,13).

 

So somewehre the must be a function in windows to do this. It would be wonderful if daminion could use it...

[Murat]

Technically say: sorting text fields as numeric fields requires adding a regular expression into the query (to truncate the textual part and sort by digital part).

 

This could leads to dropping the tag loading performance especially if you work with a shared catalog and there are a lot of connections to the Daminion Server. Anyway it necessary some time for testing, that we miss at the moment since of our focus in development of the features like: Custom Tags, Some Optimizations and User Roles. We can get back to this feature a bit later.