Home › Discussions › Questions & Answers › API for Exporting Historical SQL Versions

API for Exporting Historical SQL Versions

Avatar photoCustomer Questions & Answers 5 replies

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?

5 replies

  • Support Enginatics

    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

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

  • Support Enginatics

    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

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

  • Support Enginatics

    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.

  • You must be logged in to reply to this post.