Results 1 to 4 of 4

Thread: ICM, SQL "Duration()" or Pump Runtimes

  1. #1

    Join Date
    Aug 2013
    Posts
    22

    ICM, SQL "Duration()" or Pump Runtimes

    Is there a way to find the pump runtime during a simulation?

    I know that WS has a "duration()" SQL aggregate function that can be used to find the "duration the flow was greater than 0"... Is there an equivalent SQL function in ICM?

  2. #2
    Forum Moderator

    Innovyze Employee



    Join Date
    Feb 2013
    Posts
    133
    Yes, if you are using version 6 or later then this functionality is available.

    You can return the number of minutes that the pump flow is greater than 0 using the following query:-

    Select Duration (tsr.ds_flow>0)

    Note, that this will be the total duration and may not be contiguous. It is possible to limit the time periods within which the query is run.

  3. #3

    Join Date
    Aug 2013
    Posts
    22
    We're using 5.0.2.10020 (32 bit) July 2014. I guess their isn't a way to do it pre-version 6.

  4. #4
    Forum Moderator

    Innovyze Employee



    Join Date
    Feb 2013
    Posts
    133
    The specific SQL functionality is not available in earlier versions. Depending on your model, it might be possible to determine the duration using statistics reports based on downstream flow or similar.

Posting Permissions

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