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?
The sqlFile.execAndReturn... methods query values from whatever Sql table you ask it to. It is not hard-coded to query the TabularDataWithStrings table.
For example, here is a query from one of my own reporting measures that queries the ReportMeterData table:
query = "SELECT SUM(VariableValue) FROM ReportMeterData WHERE ReportMeterDataDictionaryIndex IN (SELECT ReportMeterDataDictionaryIndex FROM ReportMeterDataDictionary WHERE VariableName='Electricity:Facility' AND ReportingFrequency='Run Period' AND VariableUnits='J')"
value = sqlFile.execAndReturnFirstDouble(query).get
puts value
Asked: 2020-09-29 07:09:33 -0500
Seen: 194 times
Last updated: Sep 29 '20
