Infoworks WS, Simulation Results for a specific time interval in SQL

[DCJ]

Is it possible to write an SQL query that, for example, would return the average pressure of the selected nodes during 4:00AM and 6:00AM?

I've been experimenting with tsr, but I'm not having any luck.

Any assistance is greatly appreciated.

[Patrick Moore]

DCJ,

Our apologies that your question was not answered earlier. We are working to improve our ability to get our staff who have better knowledgebase of InfoWorks WS to regularly check the forums. We apologize that this question appears to have fallen through the cracks.

I checked with a couple of our staff who are more knowledgeable with InfoWorks WS and here is what they informed me:


1) As far as I know, that cannot be done with SQL. They would need to do that in Excel.

2) I agree – I couldn’t find a way to do it with SQL. My suggestion is to only run the simulation from 4:00 until 6:00 and use the existing Av pressure function.

Hopefully this can assist you.

Innovyze Support

If you find you need further assistance you can feel free to contact us at support@innovyze.com