Default sorting of images when same timestamp

[F-Node-Karlsruhe]

The bug

After moving an album in time completely (select all - change date) all images have the same timestamp and the order in album is broken, despite the image names representing the correct order.

Proposition: if the image timestamps are equals the image names should be used as a second sort property to maintain order.

The OS that Immich Server is running on

Ubuntu 22 Docker compose

Version of Immich Server

v1.121.0

Version of Immich Mobile App

v1.120.2

Platform with the issue

• Server
• Web
• Mobile

Your docker-compose.yml content

version: "3.8"                                                                                                                                                                                                                                  #                                                                                                                       # WARNING: Make sure to use the docker-compose.yml of the current release:                                              #                                                                                                                       # https://github.com/immich-app/immich/releases/latest/download/docker-compose.yml                                      #                                                                                                                       # The compose file on main may not be compatible with the latest release.                                               #                                                                                                                                                                                                                                               name: immich                                                                                                                                                                                                                                    services:                                                                                                                 immich-server:                                                                                                            container_name: immich_server                                                                                           image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}                                                      volumes:                                                                                                                  - ${UPLOAD_LOCATION}:/usr/src/app/upload                                                                                - /etc/localtime:/etc/localtime:ro                                                                                    env_file:                                                                                                                 - .env                                                                                                                ports:                                                                                                                    - 2283:2283                                                                                                           depends_on:                                                                                                               - redis                                                                                                                 - database                                                                                                            restart: always                                                                                                                                                                                                                               immich-machine-learning:                                                                                                  container_name: immich_machine_learning                                                                                 image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release}                                            volumes:                                                                                                                  - ./model-cache:/cache                                                                                                env_file:                                                                                                                 - .env                                                                                                                restart: always                                                                                                                                                                                                                               redis:                                                                                                                    container_name: immich_redis                                                                                            image: redis:6.2-alpine@sha256:b6124ab2e45cc332e16398022a411d7e37181f21ff7874835e0180f56a09e82a                         restart: always                                                                                                                                                                                                                               database:                                                                                                                 container_name: immich_postgres                                                                                         image: tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:90724186f0a3517cf6914295b5ab410db9ce23190a2d9d0b9dd6463e3fa298f0       env_file:                                                                                                                 - .env                                                                                                                environment:                                                                                                              POSTGRES_PASSWORD: ${DB_PASSWORD}                                                                                       POSTGRES_USER: ${DB_USERNAME}                                                                                           POSTGRES_DB: ${DB_DATABASE_NAME}                                                                                      volumes:                                                                                                                  - ./pgdata:/var/lib/postgresql/data                                                                                   restart: always

Your .env content

# You can find documentation for all the supported env variables at https://immich.app/docs/install/environment-variables                                                                                                                                                                                                                                               # The location where your uploaded files are stored                                                                     UPLOAD_LOCATION=./library                                                                                                                                                                                                                       # The Immich version to use. You can pin this to a specific version like "v1.71.0"                                      IMMICH_VERSION=release                                                                                                                                                                                                                          # Connection secrets for postgres and typesense. You should change these to random passwords                            TYPESENSE_API_KEY=xxx
DB_PASSWORD=xxx                                                                                                                                                                                                            # The values below this line do not need to be changed                                                                  ###################################################################################                                     DB_HOSTNAME=immich_postgres                                                                                             DB_USERNAME=postgres                                                                                                    DB_DATABASE_NAME=immich                                                                                                                                                                                                                         REDIS_HOSTNAME=immich_redis

Reproduction steps

1. Go into album
2. Select all images and change date
3. wonder why sorting ir broken
   ...

Relevant log output

No response

Additional information

No response

[F-Node-Karlsruhe]

Would you support a such feature? Then i would do a PR.

[F-Node-Karlsruhe]

I think one would add the second order sort here for mobile

immich/mobile/lib/entities/asset.entity.g.dart

Line 2578 in e0fc873

QueryBuilder<Asset, Asset, QAfterSortBy> sortByFileCreatedAt() {

but i can't find the the sort for the web app

[john-seagull]

It could be very useful feature...
Now i'm scanning my family archive, and i dont'know exact dates, of course.
But i definitely know ORDER of images on a film, and i name it like filmXXX_frameYY.jpg.
I set some date for all images, like 01.06.1980 00:00, and have all photos mixed up in a timeline or album ((
It would be very nice to have same timestamp images sorted be filename.

[L00maca]

I would love this too, same situation as john, setting de dates of pics the same for each film, but the filename is ignored when sorting.
Made some script to set progressive timestamps changing the seconds, but it's less than ideal.

Having filename as a secondary sort mechanism would be ideal.

[thomas001]

+1 to this feature request. This is especially annoying for burst shots where you can easily have 10+ photos with the same timestamp.

Right now, they seem to be randomly sorted, but the sequence number from the camera (in the filename) would give them the right order.