Data extraction help required

Squiz Matrix Support
1

Is it possible to extract all the following information for asset type 'Custom Form', from and oracle database for the CMS version 3.12


* Asset ID

* Status

* Asset Type

* URLs

2

This query will give you info about all URLs of custom forms. You get the URL, the asset ID of the URL, the name of the form and the status of the form.

    SELECT l.url, a.name, a.assetid, a.status
    FROM sq_ast a, sq_ast_lookup l
    WHERE a.type_code = 'page_custom_form' AND l.assetid = a.assetid;
    ORDER BY a.assetid


You will get duplicate entries if your custom forms have multiple URLs. The type_code of custom forms is always 'page_custom_form' so I didn't bother returning that in the query.

Status values are numeric. They are mapped in the PHP code like this:

    define('SQ_STATUS_ARCHIVED',           1); // asset is archived
    define('SQ_STATUS_UNDER_CONSTRUCTION', 2); // asset is under construction
    define('SQ_STATUS_PENDING_APPROVAL',   4); // asset is currently in workflow
    define('SQ_STATUS_APPROVED',           8); // asset is approved waiting to go live from under construction
    define('SQ_STATUS_LIVE',              16); // asset is live
    define('SQ_STATUS_LIVE_APPROVAL',     32); // asset is up for review
    define('SQ_STATUS_EDITING',           64); // asset is currently safe editing
    define('SQ_STATUS_EDITING_APPROVAL', 128); // asset is currently in workflow from safe edit
    define('SQ_STATUS_EDITING_APPROVED', 256); // asset is approved waiting to go live from safe edit