Home › Discussions › Questions & Answers › API for Archiving Previous SQL Definitions

API for Archiving Previous SQL Definitions

Avatar photoCustomer Questions & Answers 3 replies

We need to meet a compliance requirement by archiving all historical SQL definitions. Does the export API support extracting previous versions, and how is that controlled?

3 replies

  • Support Enginatics

    Yes, the export function `XXEN_API.export_file_data` supports historical data extraction by setting the parameter `p_type` to ‘SQL Versions’. When using this type, you can further restrict the versions exported based on their creation date using the parameter `p_creation_date`.

  • Avatar photoCustomer

    If I simply export a report 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.