[Help Needed] Orthanc with MS SQL Server ODBC – Studies Not Auto-Loading or Sorted by Latest in Browser

General
1

Hey Orthanc Community,

When I keep the database on default SQLite on my Windows PC, the studies load properly in the browser – for example, it shows like “50/200 studies”, and the latest study appears at the top, which is exactly what I want.

But when I switch to Microsoft SQL Server using ODBC, the total number of studies still shows correctly, but they do not auto-load. For example, if I use the “Today” filter, the studies do appear, but not in the correct order – the latest study is not at the top and sorting by series doesn’t happen.

How can I fix this? I want the latest study to appear on top and studies to load automatically like before.

Please help!
orthanc-explorer-2.txt (23.8 KB)

2

Hi,

So far, ordering of studies has only been implemented in SQLite and PostgreSQL plugin.

ODBC and MySQL plugins are quite far behind in terms of performances and functionalities right now and they probably won’t catch up until someone funds the development :frowning:

Best regards,

Alain

1 Like