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

Revision history [back]

This is related to SQL but not exactly related to your question, yet I don't think it needs a separate post as there is no answer to be given.

Anyway, the SQL issues still persist on 8.2.0 Update 1.

In EnergyPlus SQL output there are usually two main views, depending on what you asked in terms of output.

One is called TabularDataWithStrings and works as expected (contains all the tables from the report.html as far as I can tell).

The other one, is called ReportVariableWithTime and it is empty. The SELECT in the CREATE VIEW statement doesn't produce an error but doesn't return anything and that's the problem.

I've checked several sql files and the same problem is always present.

This was nonetheless fixed in the freshly out EnergyPlus 8.3.0 as far as I can tell, after running the same IDF file and checking the sql file.