EnergyPlus SQL Query Returns Incorrect Value
I'm looking at the results a bit closer at the results from an SQL query in EnergyPlus and I'm finding some issues. I'm able to access the HVAC Sizing Summary report properly, but the Sensible Heat Gain Summary report is a bit odd. The SQL query appears to mix up the values from the table.
For instance, the value from the SensibleHeatGainSummary report, Peak Cooling Sensible Heat Gain Components table, and Equipment Sensible Heat Removal column returns 720 W. The query using the Python bindings in OpenStudio looks like this:
sql_query = select Value from TabularDataWithStrings WHERE ReportName=\'SensibleHeatGainSummary\' and ReportForString=\'Entire Facility\' and TableName=\'Peak Cooling Sensible Heat Gain Components\' and ColumnName=\'Equipment Sensible Heat Removal\' and RowName=\'ZONE 0\';
sql_file.execAndReturnFirstDouble(sql_query).get()
The HTML report shows that 720 W is the value for Lights Sensible Heat Addition. It is not the value for Equipment Sensible Heat Removal.
Is there a mistake in my query syntax or a bug in EnergyPlus or OpenStudio? I'd greatly appreciate any help with this.