First time here? Check out the Help page!
1 | initial version |
The SQL statement you have shown is to get Cat 2 for the space F3:Corridor. Change the zone name in the RowName field for other zones. You may try removing "AND RowName="PEOPLE F3:CORRIDOR")" from the SQL statement and see if it gives you all the zones at once.
If you are only interested in a few zones, it is an easier to get the comfort data from tabular output rather than using SQL. See http://www.jeplus.org/wiki/doku.php?id=docs:manual_1_7_rvx#read_from_e_csv_tabular_report for more details.
Yi