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
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
Answer Verified By: Sushma Choure
Rob,
Wow, this is BRILLIANT! Exactly what I needed, thank you so much!
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.
Excellent, thank you so much for your help, Jesse!