Question-and-Answer Resource for the Building Energy Modeling Community
 | 1 | initial version |
Someone can correct me if I'm wrong, but I don't think any of the built-in sqlFile methods can handle custom subcategories; I think the categories and subcategories are hard-coded into OpenStudio.
One way to get the value you want is with a simple SQL query:
query = "SELECT Value FROM TabularDataWithStrings WHERE ReportName='AnnualBuildingUtilityPerformanceSummary' AND ReportForString='Entire Facility' AND TableName='End Uses By Subcategory' AND RowName='Pumps:HW Pumps' AND ColumnName='Electricity' AND Units='GJ''"
value = sql_file.execAndReturnFirstDouble(query).get
| | 2 | No.2 Revision |
Someone can correct me if I'm wrong, but I don't think any of the built-in sqlFile methods can handle custom subcategories; I think the categories and subcategories are hard-coded into OpenStudio.
One way to get the value you want is with a simple SQL query:
query = "SELECT Value FROM TabularDataWithStrings WHERE ReportName='AnnualBuildingUtilityPerformanceSummary' AND ReportForString='Entire Facility' AND TableName='End Uses By Subcategory' AND RowName='Pumps:HW Pumps' AND ColumnName='Electricity' AND Units='GJ''"
Units='GJ'"
value = sql_file.execAndReturnFirstDouble(query).get
| | 3 | No.3 Revision |
Someone can correct me if I'm wrong, but I don't think any of the built-in sqlFile methods can handle custom subcategories; I think the categories and standard EnergyPlus subcategories are hard-coded into OpenStudio.
One way to get the value you want is with a simple SQL query:
query = "SELECT Value FROM TabularDataWithStrings WHERE ReportName='AnnualBuildingUtilityPerformanceSummary' AND ReportForString='Entire Facility' AND TableName='End Uses By Subcategory' AND RowName='Pumps:HW Pumps' AND ColumnName='Electricity' AND Units='GJ'"
value = sql_file.execAndReturnFirstDouble(query).get
