Question-and-Answer Resource for the Building Energy Modeling Community
 | 1 | initial version |
It turned out that such table exists: in the SQL file. If you ask for a SQL report in EPlus (OpenStudio default), you will have SQL output. For whatever reason, the information I need is reported here and only here. And the best part is: it is not reported through ResultsViewer in OpenStudio.
To access the data, we need to use sqlite3, and the following SQL code will extract the right information:
drop view if exists SurfaceList;
CREATE VIEW IF NOT EXISTS SurfaceList AS SELECT Surfaces.*, Constructions.Name, Constructions.Uvalue FROM Surfaces INNER JOIN Constructions ON ( Constructions.ConstructionIndex = Surfaces.ConstructionIndex );
select * From SurfaceList;
