{"queries":[{"id":"days","compiledQueryString":"select * from tradingreport_days","inputQueryString":"select * from tradingreport_days","compiled":false,"inline":true},{"id":"facilities","compiledQueryString":"select facilityCode\nfrom tradingreport_all\nwhere\n(\n ('false' = '${inputs.nonzerorental}' ) OR\n ('true' = '${inputs.nonzerorental}' and (congestionRentalValue is not null and congestionRentalValue <> 0) ) OR\n ('negative' = '${inputs.nonzerorental}' and (congestionRentalValue is not null and congestionRentalValue < 0)) OR\n ('positive' = '${inputs.nonzerorental}' and (congestionRentalValue is not null and congestionRentalValue > 0))\n)\nand dispatchInterval >= DATE '${inputs.mydaterange.start}'\nand dispatchInterval < DATE '${inputs.mydaterange.end}' + INTERVAL '1' DAY\ngroup by 1\norder by 1","inputQueryString":"select facilityCode\nfrom tradingreport_all\nwhere\n(\n ('false' = '${inputs.nonzerorental}' ) OR\n ('true' = '${inputs.nonzerorental}' and (congestionRentalValue is not null and congestionRentalValue <> 0) ) OR\n ('negative' = '${inputs.nonzerorental}' and (congestionRentalValue is not null and congestionRentalValue < 0)) OR\n ('positive' = '${inputs.nonzerorental}' and (congestionRentalValue is not null and congestionRentalValue > 0))\n)\nand dispatchInterval >= DATE '${inputs.mydaterange.start}'\nand dispatchInterval < DATE '${inputs.mydaterange.end}' + INTERVAL '1' DAY\ngroup by 1\norder by 1","compiled":false,"inline":true},{"id":"dataz","compiledQueryString":"select\n DATE_TRUNC('hour',dispatchInterval) dispatchInterval,\n facilityCode,\n APPROX_QUANTILE(congestionRentalValue,0.5)congestionRentalValue\nfrom tradingreport_all\nwhere facilityCode in ${inputs.facdrop.value}\nand dispatchInterval >= DATE '${inputs.mydaterange.start}'\nand dispatchInterval < DATE '${inputs.mydaterange.end}' + INTERVAL '1' DAY\nand (\n ('false' = '${inputs.nonzerorental}' ) OR\n ('true' = '${inputs.nonzerorental}' and (congestionRentalValue is not null and congestionRentalValue <> 0) ) OR\n ('negative' = '${inputs.nonzerorental}' and (congestionRentalValue is not null and congestionRentalValue < 0)) OR\n ('positive' = '${inputs.nonzerorental}' and (congestionRentalValue is not null and congestionRentalValue > 0))\n)\nGROUP BY 1,2\norder by dispatchInterval","inputQueryString":"select\n DATE_TRUNC('hour',dispatchInterval) dispatchInterval,\n facilityCode,\n APPROX_QUANTILE(congestionRentalValue,0.5)congestionRentalValue\nfrom tradingreport_all\nwhere facilityCode in ${inputs.facdrop.value}\nand dispatchInterval >= DATE '${inputs.mydaterange.start}'\nand dispatchInterval < DATE '${inputs.mydaterange.end}' + INTERVAL '1' DAY\nand (\n ('false' = '${inputs.nonzerorental}' ) OR\n ('true' = '${inputs.nonzerorental}' and (congestionRentalValue is not null and congestionRentalValue <> 0) ) OR\n ('negative' = '${inputs.nonzerorental}' and (congestionRentalValue is not null and congestionRentalValue < 0)) OR\n ('positive' = '${inputs.nonzerorental}' and (congestionRentalValue is not null and congestionRentalValue > 0))\n)\nGROUP BY 1,2\norder by dispatchInterval","compiled":false,"inline":true}]}

Congestion Rentals