energyConsumptionsByMonth in OpenStudio returns nothing?

edit

Also notice that function returns an optional double, you should check that it is initialized before called get to return the value as a double.

Dan, I think this is really great direction. I think that my only question, is: Is there not a way to add Table Monthly reports directly from the OpenStudio dll's, without having to rely on run manager? As far as I know, I still can't access the Run Manager via C#. We tried to at the hackathon but it failed to work at that time. If that is the case, does this leave me with having to post-edit the idf in my script after OpenStudio has created it?

Also wanted to add...your advice on using the Queries was right on. There is not a ReportName WHERE ReportName="Building Energy Performance", so I think that confirms why nothing is returned. I find it interesting though that SQLite doesn't return an error even when that table is not present.

If you aren't able to get RunManager to work then yes I think the best approach is to grab the Idf after you have translated your OpenStudio model to Idf and add those objects directly.

Dan-I took your advice and have been working on an implementation where I modify the idf file after OS has created it. One thing that I've noticed, though I'm not quite done with this exercise, is that in your github example showing source code for energyConsumptionByMonth...the sql query looks like :

"SELECT Value FROM tabulardatawithstrings WHERE \ .... ..."

The thing I notice when I open the sql file is that after we call OS and write to IDF, we have a table "TabularData" but not "TabularDataWithStrings".

I realize that this is not a real table. Wonder if this is somehow contributing