Skip to content

Change start value for accession numbers

Björn Albers edited this page Mar 8, 2022 · 1 revision

If you have existing studies in your PACS then you'll likely create new orders with an accession number offset.
This is what I did inside the web container to create accession numbers starting at 500.000:

$ bin/rails db -e production                                                                                                                                                  
SQLite version 3.7.13 2012-07-17 17:46:21                                                                                                                                     
Enter ".help" for instructions                                                                                                                                                
Enter SQL statements terminated with a ";"                                                                                                                                    
sqlite> UPDATE SQLITE_SEQUENCE SET seq = 500000 where name = 'orders';                                                                                                        
sqlite> SELECT name, seq FROM SQLITE_SEQUENCE;                                                                                                                                
stations|10                                                                                                                                                                   
orders|500000                                                                                                                                                                 
sqlite> .quit
Clone this wiki locally