Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question

Revision history [back]

Reporting Measure sql file manipulation

Hello Unmet,

I am currently writing a reporting measure script to output information from a models sql file. I ran into a specific road block when trying to use the execAndReturnVectorOfDouble method. I need to now loop through this vector and grab the data from the column %Grand Total, however whenever I try to use common vector methods like .length() or .size(), I get an error saying ":

Peak Sensible Load section failed and was skipped because: undefined method `name' for OpenStudio::OptionalDoubleVector:0x0001a263305ac8

Here Is a screenshot of my sql statement.

image description

Any help would be greatly appreciated!

thank you

Reporting Measure sql file manipulation

Hello Unmet,

I am currently writing a reporting measure script to output information from a models sql file. I ran into a specific road block when trying to use the execAndReturnVectorOfDouble method. I need to now loop through this vector and grab the data from the column %Grand Total, however whenever I try to use common vector methods like .length() or .size(), I get an error saying ":

Peak Sensible Load section failed and was skipped because: undefined method `name' `size' for OpenStudio::OptionalDoubleVector:0x0001a263305ac8

Here Is a screenshot of my sql statement.

image description

Any help would be greatly appreciated!

thank you