Results 1 to 2 of 2

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

  1. #1

    Join Date
    Aug 2013
    Posts
    22

    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
    Posts
    417
    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

Posting Permissions

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