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

Revision history [back]

click to hide/show revision 1
initial version

Reporting measure syntax

Hello, 1.i do not fully understand the arguments in OpenStudio::IdfObject.load("Output:Variable,,Zone Mechanical Ventilation Current Density Volume Flow Rate,Hourly;") - Why second fields Variable,,Zone was skipped ? That idfobject.load is simillar with sql query or not ? Which query in SQLbrower i should make to get same result as OpenStudio::IdfObject.load ?

query = 'SELECT Value FROM tabulardatawithstrings WHERE ' query << "ReportName='AnnualBuildingUtilityPerformanceSummary' and " query << "ReportForString='Entire Facility' and " query << "TableName='Building Area' and " query << "RowName='Total Building Area' and " query << "ColumnName='Area' and " query << "Units='m2';

3. Have any difference to access OSM object (Model::Object) or WorkspaceObject (E+ object) to get input data when i code an reporting measure class OpenStudio::Ruleset::ReportingUserScript when compare with ModelUserScript and WorkspaceUserScript

Reporting measure syntax

Hello, 1.i do not fully understand the arguments in OpenStudio::IdfObject.load("Output:Variable,,Zone Mechanical Ventilation Current Density Volume Flow Rate,Hourly;") - Why second fields Variable,,Zone was skipped ? That idfobject.load is simillar with sql query or not ? Which query in SQLbrower i should make to get same result as OpenStudio::IdfObject.load OpenStudio::IdfObject.load ?

query = 'SELECT Value FROM tabulardatawithstrings WHERE ' query << "ReportName='AnnualBuildingUtilityPerformanceSummary' and " query << "ReportForString='Entire Facility' and " query << "TableName='Building Area' and " query << "RowName='Total Building Area' and " query << "ColumnName='Area' and " query << "Units='m2';

3. Have any difference to access OSM object (Model::Object) or WorkspaceObject (E+ object) to get input data when i code an reporting measure class OpenStudio::Ruleset::ReportingUserScript when compare with ModelUserScript and WorkspaceUserScript

Reporting measure syntax

Hello, 1.i do not fully understand the arguments in OpenStudio::IdfObject.load("Output:Variable,,Zone Mechanical Ventilation Current Density Volume Flow Rate,Hourly;") - Why second fields Variable,,Zone was skipped ? That idfobject.load is simillar with sql query or not ? Which query in SQLbrower i should make to get same result as OpenStudio::IdfObject.load ?

query = 'SELECT Value FROM tabulardatawithstrings WHERE ' query << "ReportName='AnnualBuildingUtilityPerformanceSummary' and " query << "ReportForString='Entire Facility' and " query << "TableName='Building Area' and " query << "RowName='Total Building Area' and " query << "ColumnName='Area' and " query << "Units='m2';

3. Have any difference to access OSM object (Model::Object) or WorkspaceObject (E+ object) to get input data when i code an reporting measure class OpenStudio::Ruleset::ReportingUserScript when compare with ModelUserScript and WorkspaceUserScript