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

asked 2020-09-29 07:09:33 -0600

Dr. Fan's avatar

problem of querying the data from the SQLFile using Openstudio measure

We can get values from sqlfile by the command: "sqlFile.execAndReturnFirstString(query)". But it only calls values from the table "tabulardatawithstrings" in sqlfile. If I want to select values from other tables(like "ReportVariableDataDictionary"), what kind of command should I use?

click to hide/show revision 2
retagged

updated 2020-09-29 15:13:02 -0600

shorowit's avatar

problem of querying the data from the SQLFile using Openstudio measure

We can get values from sqlfile by the command: "sqlFile.execAndReturnFirstString(query)". But it only calls values from the table "tabulardatawithstrings" in sqlfile. If I want to select values from other tables(like "ReportVariableDataDictionary"), what kind of command should I use?

About | Help | Privacy | Legal | Contact
Site design and logo: Copyright © 2015 Big Ladder Software LLC. All rights reserved.
The Unmet Hours and Big Ladder names and logos are trademarks of Big Ladder Software LLC.
User contributions licensed under the Creative Commons Attribution Share Alike 3.0 License.
Powered by