WaterGEMS Scenario Search

Hello Youssef, 

Could you please elaborate your query, please insert screenshots if required.

Do you mean you want to search using scenario ID in scenario manager as there are multiple child/base scenarios? 

Elaborating your query would help us to answer it. 

Hi Sushma,

The model has more than 1,000 scenarios, what is the best way to go about finding a specific scenario?  The scenario names are generally regularly updated based on client modifications.  The only constant that I am aware of is the scenario ID.  Can I use a scenario ID to search for a scenario?  Or am I expected to manually go through >1,000 scenarios to find a scenario that I created a few years ago?   

1000 scenarios has got to be some kind of dubious record. Sometimes it's good to archive an old model file and clean up the remaining file. Remove many of the old scenarios you will never use again.

I agree with Tom - it may be best to focus on cleaning up the scenarios rather than trying to live with them. See the section called "Deleting Scenarios and Alternatives" in this article: Scenario and Alternative Management

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.  

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

Rob,

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

Regards,

Youssef 

Rob,

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

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

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

Regards,

Youssef