Obtain the 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 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;