CEA query maintenance

From PTAGISWiki

Jump to: navigation, search


03/23/2006 @ 13:02 ---------------------

Fixed in development by removing extraneous spaces from the where clause:

pittag.cea_coil_tally.obs_site IN ($(Site))

The spaces around $(Site) were causing the IN to behave badly.

03/23/2006 @ 11:17 ---------------------

selecting multiple sites and running a year-to-date report causes the report to display data for only the first site in the list. If there is no data for the first site, then no data is displayed at all.

The parameters in the header show that it is doing a report for multiple sites (Site: BO1 BO2 BO3 BO4 TimeInterval: daily ReportDate: 200) but the data is only for the first site in the list: BO1. Query is CEA_ytd

The same parameters for a single day (Site: BO1 BO2 BO3 BO4 TimeInterval: daily ReportDate: 200) uses the query CEA_oneDay and it works correctly.

Retrieved from "http://php.ptagis.org/wiki/index.php/CEA_query_maintenance"
Personal tools