This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

WaterGEMS Scenario Search

Hello,

I hope that this message finds you well.  Is there a way to search for a scenario using the Scenario ID?  Thank you so much for your help.

Regards,

Youssef 

  • Excellent, thank you so much for your help, Jesse!  

    Regards,

    Youssef 

  • To close the loop, enhancement # 594754 has been filed for our developers to look into adding a search button to the Scenario manager, to search by scenario label or ID. I have added a note about this to the following wiki article: Managing large number of scenarios


    Regards,

    Jesse Dringoli
    Technical Support Manager, OpenFlows
    Bentley Communities Site Administrator
    Bentley Systems, Inc.

    Answer Verified By: Sushma Choure 

  • Rob,

    Wow, this is BRILLIANT!  Exactly what I needed, thank you so much!  

    Regards,

    Youssef 

  • Hi Youssef,

    If you want to go a bit more low level you can go directly to the sqlite file.

    Download SQLite Expert Personal (it is a very good tool and the personal version is freeware).

    http://www.sqliteexpert.com/

    Open the WaterGEMS database e.g. Example5.wtg.sqlite (best to not have the file open in WaterGEMS when you do this)

    Use this Query:

    SELECT HMIScenario.ScenarioID, HMIScenario.ParentID, HmiModelingElement.Label
    FROM HmiScenario
    INNER JOIN HmiModelingElement ON HmiScenario.ScenarioID = HmiModelingElement.ElementID
    WHERE HmiScenario.IsDeleted = false

    Rob

    p.s.

    I include the ParentID in the result so you can infer the hierarchy to more easily track things down.  The scenarios with "(null)" ParentID are base scenarios

    Answer Verified By: Sushma Choure 

  • Tom / Jesse - I see your point of view.  The client and I are required to maintain all scenarios in the same model version as we are working with regulators on modeling scenarios (as old as 2017) for significant capital planning associated with various administrative consent orders.  While what you are offering is a reasonable suggestion, having multiple "archives" of the model is not feasible for our case and will not be accepted by the regulators.  Similar to search for a model element using an ID, can we have the same thing for the scenario?  Scenario names constantly change when models are "handed over" or "inherited" and the only constant becomes the scenario ID, which is a great feature in the first place, but is it possible to actually make it searchable for us?  Search for a scenario using a scenario ID.