Obtaining the List of Property Sheet Fields
The following query obtains the list of property sheet fields. The value of ls_category is equal to object type.
Additional system fields (predefined in Contenta and hidden from user) pdm_blobid and pdm_revid are also added to the list of available property sheet fields.
SELECT pdm_fields.name
FROM pdm_fields, pdm_metadata
WHERE pdm_fields.abs_number = pdm_metadata.abs_number AND
pdm_metadata.name = ls_category
ORDER BY pdm_fields.name;