Reporting Measure sql file manipulation

asked 2019-01-07 08:59:02 -0500

updated 2019-01-07 09:04:22 -0500

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 `size' for OpenStudio::OptionalDoubleVector:0x0001a263305ac8

Here Is a screenshot of my sql statement.

image description

Any help would be greatly appreciated!

thank you

edit retag flag offensive close merge delete

add a comment

2 Answers

Sort by » oldest newest most voted

answered 2019-01-07 12:46:32 -0500

shorowit

10881 ●179 ●9 https://www.nrel.gov/b...

As you indicated, your query returned an OptionalDoubleVEctor object, not a DoubleVector object. See the "OpenStudio Measures and the boost::optional Type" section in the Measure Writer's Reference Guide for background information on how to deal with these types of optional objects.

edit flag offensive delete link

add a comment

answered 2019-01-07 12:09:59 -0500

David Goldwasser

20295 ●94 ●14 http://www.openstudio.net/

Here is an example with similar method but with strings.

row_names = sqlFile.execAndReturnVectorOfString(rows_name_query).get
rows = []
row_names.each do |row_name|
  rows << row_name
end

rows is now a standard ruby array and you can use methods like rows.size. In my use case I then loop through rows array and perform additional tabular sql queries on each header entry for each row.