Documentation Center

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;