had no Where clause; lacking a Between statement; added or replaced the Where clause on Page 4 to your original post
select null link, SAMPLE_DATE label, READING value1 from "METER_DATA"."METER_READINGS"
Button named; Submit Date Range redirected the application to Page 3; deleted that button and added a button Submit that submitted the page and rendered the chart
select null link, SAMPLE_DATE label, READING value1 FROM meter_readings WHERE sample_date BETWEEN To_date(:P4_START_DATE, 'DD-MON-YYYY') AND To_date( :P4_END_DATE, 'DD-MON-YYYY') ORDER BY sample_date;
My Requirement is also looks like same, but am not able figure it out the reason why am getting no data found message in my chart(report).
I have a page, where two date picker(html5) items let say P30_FROM_DATE, P30_TO_DATE are there, apart from this i have one button as well,
when the user select the from and to date from the date picker, and as soon as click on the button (SHOW), need to display the 2D Stacked Bar Char.
so to achieve this, i have created a blank page, under region i have created a chart (2D Stacked Bar Chart), under items--> i have created two date picker items and one button.
my query is
SELECT NULL LINK,
BETWEEN TO_DATE(:P30_FROM_DATE,'DD-MON-YYYY') AND TO_DATE(:P30_TO_DATE,'DD-MON-YYYY')
GROUP BY FLOW_STATUS_CODE;
Once i select the From and To Date, when am click on Show button, am not able to see as desired chart, instead am getting no data found message in the chart location.
Can you please tell me how to do this.
i would like to know that, how do i capture those two date item values in my query, and how do i initiate my report when am pressing button.
please revert back to my below mail.
Santhosh Kumar. K