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!
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
Jesse DringoliTechnical Support Manager, OpenFlowsBentley Communities Site AdministratorBentley Systems, Inc.
Answer Verified By: Sushma Choure
Rob,
Wow, this is BRILLIANT! Exactly what I needed, thank you so much!
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.LabelFROM HmiScenarioINNER JOIN HmiModelingElement ON HmiScenario.ScenarioID = HmiModelingElement.ElementIDWHERE 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
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.