Documentation Center

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;