I have an application I designed with a Sencha Architect front end and RPG backend. It has a grid displaying records, and the user can select a FROM and TO date from the drop-down calendar to limit the records selected. This works fine for display.
BUT, clicking the download button produces an empty Excel file. Comparing the two requests being made, I see that the format of the dates is different when just displaying the grid vs. requesting a download. When doing the download, the date format is incorrect and no data is selected, resulting in the empty Excel file.
Request when displaying the grid:
V_Grid.JPG
This one above that is sent when in the grid works correctly in the SQL statement on the back end and returns the correct records.
Request when clicking the download button:
V_Download.JPG
This second one that is sent when doing the download does not work correctly in the SQL statement on the back end and therefore no records are returned in the resulting Excel file.
How to fix? Thanks!
BUT, clicking the download button produces an empty Excel file. Comparing the two requests being made, I see that the format of the dates is different when just displaying the grid vs. requesting a download. When doing the download, the date format is incorrect and no data is selected, resulting in the empty Excel file.
Request when displaying the grid:
V_Grid.JPG
This one above that is sent when in the grid works correctly in the SQL statement on the back end and returns the correct records.
Request when clicking the download button:
V_Download.JPG
This second one that is sent when doing the download does not work correctly in the SQL statement on the back end and therefore no records are returned in the resulting Excel file.
How to fix? Thanks!
Comment