Menu Close

Identifying transition group IDs

Syncrosim Forums ST-Sim & State-and-Transition Simulation Models Identifying transition group IDs

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #6045
    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.



    Thanks, Leonardo. I was able to replicate the code and think that I can transfer this to my own .ssim. Much appreciated!

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.