SEE PBI#115128 - CAWIS WSDRS - Feedback Magazine Datasets time frames for extractions needs to be more flexible
Feedback magazine is to be published quarterly by the Continuing Airworthiness publications group. Unfortunately when it is published late, the hard coded time parameters in the application will not permit the client to extract the Service Difficulty Reporting (SDR) & Airworthiness Directive (AD) data for the required time frame.
The code to do this is available in the attachment here :
Note: in TOAD, the three scripts, for SDR, Equipment AD and AD need to be run separately.
Simply replace the <> values with the required dates, run the queries, drop the data into an Excel spreadsheet, attach the spreadsheet to the PBI (one tab per result set), and notify the requestor.
A future CAWIS enhancement should be to remove these time frame restrictions on the data extract, and let the user select their own start and end dates.
0 Comments