# Tag editor scan classes unsorted **URL:** \ **Category:** Ignition\ **Created:** [April 29, 2018, 5:32am UTC](https://forum.inductiveautomation.com/t/tag-editor-scan-classes-unsorted/17860 "2018-04-29T05:32:28Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Post date:** [April 29, 2018, 5:32am UTC](https://forum.inductiveautomation.com/t/tag-editor-scan-classes-unsorted/17860/1 "2018-04-29T05:32:28Z")
In the Scan class editor, all scan classes are sorted alphabetically. But in Tag editor dropdown for choosing Scan Class they are shown unsorted in some weird order and it’s very difficult to find the right scan class if you have many of them. ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/e/e401b8aa588c2f597f955308fa4e1a1bfa55d6ec.PNG) ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/6c4d6426dc0606122227f8a0330cf01978e463a0.PNG) Is there anything that can be done from my side? If this is a ‘bug’ then it’s present for a long time (and it’s 7.9.7 version now)…😐 Where are this scan classes stored? ---
**Author:** ![Kyle\_Chase](https://avatars.discourse-cdn.com/v4/letter/k/9de0a6/32.png) [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Post date:** [April 29, 2018, 6:04am UTC](https://forum.inductiveautomation.com/t/tag-editor-scan-classes-unsorted/17860/2 "2018-04-29T06:04:13Z")
The scan classes are stores in the SQLTSCANCLASS table, which is updated whenever any changes to scan classes happen. My guess is the editor retrieves and sorts on the NAME column, whereas the scan class selector for a tag is sorted by the SQLTSCANCLASS\_ID column. ---
**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Post date:** [April 29, 2018, 6:55am UTC](https://forum.inductiveautomation.com/t/tag-editor-scan-classes-unsorted/17860/3 "2018-04-29T06:55:17Z")
Where is that SQLTSCANCLASS table? How can I see it? ---
**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Post date:** [April 29, 2018, 7:39am UTC](https://forum.inductiveautomation.com/t/tag-editor-scan-classes-unsorted/17860/4 "2018-04-29T07:39:12Z")
OK, I found it in internal DB in the Ignition gateway. But there is no logic in this… When you export the scan classes in CSV file, they are sorted by NAME. So I exported all scan classes, delete all scan classes from Scan Class editor, save, import back from CSV and it’s the same… When you look at the internal DB (select \* from SQLTSCANCLASS), you can see the ID column and NAME column are OK, but in the dropdown, in the Tag Editor, it’s still everything messed up… ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/e/e942eccfa8287778f672ad22eca09b72a9b6f5ed.PNG) ---
**Author:** ![Kyle\_Chase](https://avatars.discourse-cdn.com/v4/letter/k/9de0a6/32.png) [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Post date:** [April 29, 2018, 5:21pm UTC](https://forum.inductiveautomation.com/t/tag-editor-scan-classes-unsorted/17860/5 "2018-04-29T17:21:24Z")
Did you restart the server after importing the scan classes? Changes to the internal database that do not go through the ORM need a service restart to take effect. ---
**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Post date:** [April 30, 2018, 4:44am UTC](https://forum.inductiveautomation.com/t/tag-editor-scan-classes-unsorted/17860/6 "2018-04-30T04:44:46Z")
Yup, I restarted Ignition, restarted server (VM), cleared the cache (.ignition folder), … nothing helps… 😕 ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [April 30, 2018, 3:15pm UTC](https://forum.inductiveautomation.com/t/tag-editor-scan-classes-unsorted/17860/7 "2018-04-30T15:15:30Z")
(Realtime) scan classes will be sorted to match the scan class editing window in 7.9.8; see: [http://ideas.inductiveautomation.com/forums/255378-ignition-features-and-ideas/suggestions/32166658-sort-scan-classes-in-the-tag-edit-create-window](http://ideas.inductiveautomation.com/forums/255378-ignition-features-and-ideas/suggestions/32166658-sort-scan-classes-in-the-tag-edit-create-window)