Home Discussions Questions & Answers API for Exporting Historical SQL Versions

API for Exporting Historical SQL Versions

Avatar photoCustomer February 3, 2022 at 6:09 pm

We need to archive the historical SQL definitions for compliance purposes. Does the export API support extracting previous versions of report SQL, or just the current version?

Viewing 4 reply threads
  • Author
    Replies
    • Support February 4, 2022 at 12:22 pm  

      Yes, the export mechanism supports historical data. You use the function `XXEN_API.export_file_data` with the parameter `p_type` set to **’SQL Versions’**.

    • Avatar photoCustomer February 5, 2022 at 7:09 pm  

      If I select ‘SQL Versions’, can I restrict the export by date?

    • Support February 6, 2022 at 11:34 pm  

      Yes, when `p_type` is ‘SQL Versions’, you can use the parameter **`p_creation_date`** to restrict the versions exported based on their creation date.

    • Avatar photoCustomer February 8, 2022 at 7:57 pm  

      If I export reports normally (p_type=’Reports’), does that XML include the SQL history?

    • Support February 10, 2022 at 10:49 pm  

      No, report load scripts and XML files generated by choosing ‘Reports’ contain the **current report SQL versions only**; they do not include previous version SQL history.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: