Results 1 to 2 of 2

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

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Join Date
    Aug 2013

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

    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.

  2. #2
    Forum Moderator

    Innovyze Employee

    Innovyze Employee

    Join Date
    May 2015

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts