Documentation Center

Finding Objects of Selected Object Type

By dragging and dropping, a user can populate the right side of the window with the desired property sheet fields from the selected object type.

Once the user clicks on the Create Form button, the following query finds all the objects in the database of the selected object type,. Here [MODULE] is a variable and the value depends on the object type.
SELECT Name, Pdm_Blobid 
FROM [MODULE] 
WHERE pdm_current = 1 AND
      pdm_blobid = (SELECT DISTINCT child 
                    FROM parent_list);

Example:

Auto Populate Query