Menu Close

Reply To: Identifying transition group IDs

Leonardo FridLeonardo Frid

Hi Kevin,

Yes, this is an internal code that is the primary key to the table. We are planning to have a way to access these codes that are project definition ID values in an upcoming release. In the meantime you can use the following code that requires the RSQLite package:

> library(RSQLite)
> myLibPath = “Path to your library/myLibrary.ssim
> mySQLStatement = “Select TransitionGroupID, Name From STSim_TransitionGroup Where TransitionGroupID = 489”
> myLib = dbConnect(RSQLite::SQLite(), myLibPath)
> dbGetQuery(myLib, mySQLStatement)
TransitionGroupID Name
1 489 Fire

Note that if you remove the where clause from the SQL statement you will get all the transition groups and their corresponding ID values.

Let me know if you have any questions.